<?
require("connect.php");
$tb="entstd";
$result = mysql_db_query($db,"select * from $tb");
if ($result) {
  echo "Clear all records : ";  
  $query="delete from $tb";
} else {
  echo "Create $tb : ";
  $result=mysql_create_db($db,$connect);
  $query="create table $tb (idstd char(13),ename char(20),esurn char(20),idtype char(4))";
}
$result=mysql_db_query($db,$query);
if ($result) { echo "Ok"; } else { echo "Error"; }  
# ======
insertrecord("84470101","Mr.Tom","Somjet","1004");
insertrecord("84470102","Ms.Jane","Jnet","1004");
insertrecord("84470103","Mr.Kaew","Fukada","1003");
insertrecord("84470104","Mr.Love","Bankok","1003");
insertrecord("84470105","Ms.Idol","Thai","1001");
insertrecord("84470106","Ms.Model","Kyoko","1003");
# =======
$result = mysql_db_query($db,"select * from $tb");
$cnt= mysql_num_rows($result);
echo "<br>Restore $tb $cnt records : Ok<hr>";
$sql="select * from entstd";
$result = mysql_db_query($db,$sql);  
while ($object = mysql_fetch_object($result)) {
  echo $object->idstd."  ".$object->ename."<br>";
}
mysql_close($connect);
# == end ==
function insertrecord($xid,$xname,$xsurn,$xtype) {
  global $db,$tb;
  $query="insert into $tb values('$xid','$xname','$xsurn','$xtype')";  
  $result = mysql_db_query($db,$query);  
  if ($result) { echo "<br>$query : Ok"; } else { echo "<br>$query : Error"; }   
}
?>