|
<? require("connect.php"); $tb = "enttype"; $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 (idtype char(4),descp char(40))"; } $result=mysql_db_query($db,$query); if ($result) { echo "Ok"; } else { echo "Error"; } # ====== $query="insert into enttype values('1001','Business computer')"; $result = mysql_db_query($db,$query); $query="insert into enttype values('1002','Computer engineering')"; $result = mysql_db_query($db,$query); $query="insert into enttype values('1003','Computer science')"; $result = mysql_db_query($db,$query); $query="insert into enttype values('1004','Information technology')"; $result = mysql_db_query($db,$query); # ======= $result = mysql_db_query($db,"select * from $tb"); $cnt= mysql_num_rows($result); echo "<br>Restore $tb $cnt records : Ok"; mysql_close($connect); ?> |