|
<? require("connect.php"); $result=mysql_create_db($db,$connect); echo "Create database perlphpasp : "; if ($result) { echo "Ok"; } else { echo "Error"; } # ======= echo "<hr>Create table ohotb : "; $query="create table ohotb (id char(4),descp char(40))"; $result=mysql_db_query($db,$query); if ($result) { echo "Ok"; } else { echo "Error"; } # ======= echo "<hr>Create records : "; $query="insert into ohotb values('1001','Business computer')"; $result = mysql_db_query($db,$query); echo $result; $query="insert into ohotb values('1002','Computer engineering')"; $result = mysql_db_query($db,$query); echo $result; $query="insert into ohotb values('1003','Computer science')"; $result = mysql_db_query($db,$query); echo $result; $query="insert into ohotb values('1004','Information technology')"; $result = mysql_db_query($db,$query); echo $result; # ======= echo "<hr>Display records : <br>"; $query="select * from ohotb"; $result = mysql_db_query($db,$query); while ($object = mysql_fetch_object($result)) { echo $object->id . " " . $object->descp . "<br>"; } $cnt= mysql_num_rows($result); echo $cnt; # ======= echo "<hr>Drop database : "; $result=mysql_drop_db($db,$connect); if ($result) { echo "Ok"; } else { echo "Error"; } mysql_close($connect); ?> |