<?
require("connect.php");
echo "Delete existing database and all table : ";
$result=mysql_drop_db($db,$connect);
if ($result) { echo "Ok"; } else { echo "Error"; }
echo "<br>Create perlphpasp database for VDO system : ";
$result=mysql_create_db($db,$connect);
if ($result) { echo "Ok"; } else { echo "Error"; }
# =======
$tb = "vdo"; 
$query="create table vdo (vid char(13),flag char(1))";
$result=mysql_db_query($db,$query);
insertrec("2","t4400001m0001","B","",""); 
insertrec("2","t4400002m0001","A","","");
insertrec("2","t4400003m0001","B","","");
insertrec("2","t4400004m0001","F","","");
insertrec("2","t4400004c0001","B","","");
insertrec("2","t4400004c0002","A","","");
insertrec("2","t4400004c0003","B","","");
insertrec("2","t4400005m0101","B","","");
insertrec("2","t4400005m0201","B","","");
insertrec("2","t4400005m0301","B","","");
tocntrec();
$tb = "story"; 
$query="create table story (vid8 char(8),vname char(20))";
$result=mysql_db_query($db,$query);
insertrec("2","t4400001","Batman","","");
insertrec("2","t4400002","Superman","","");
insertrec("2","t4400003","Love Z","","");
insertrec("2","t4400004","Pokemon","","");
insertrec("2","t4400005","Doramon","","");
tocntrec();
$tb = "stock"; 
$query="create table stock (vid11 char(11),getdate date,amt int(3))";
$result=mysql_db_query($db,$query);
insertrec("3","t4400001m00","2000-11-06",1,"");
insertrec("3","t4400002m00","2000-11-31",1,"");
insertrec("3","t4400003m00","2001-06-06",1,"");
insertrec("3","t4400004m00","2001-06-06",1,"");
insertrec("3","t4400004c00","2001-06-06",3,"");
insertrec("3","t4400005m01","2001-06-06",1,"");
insertrec("3","t4400005m02","2001-06-06",1,"");
insertrec("3","t4400005m03","2001-06-06",1,"");
tocntrec();
$tb = "borrow"; 
$query="create table borrow (bid char(11),bdate date,cid char(7),eid char(5))";
$result=mysql_db_query($db,$query);
insertrec("4","r4400000151","2001-11-28","c440001","e4401");
insertrec("4","r4400000152","2001-12-21","c440001","e4401");
insertrec("4","r4400000153","2001-12-22","c440002","e4402");
tocntrec();
$tb = "borrowd"; 
$query="create table borrowd (bid char(11),vid char(13),bflag char(1),sdate date)";
$result=mysql_db_query($db,$query);
insertrec("4","r4400000151","t4400004c0001","S","2001-12-1");
insertrec("4","r4400000151","t4400004c0002","S","2001-11-30");
insertrec("4","r4400000152","t4400001m0001","B","2001-12-28");
insertrec("4","r4400000152","t4400004c0001","F","2001-12-25");
insertrec("4","r4400000152","t4400004c0002","S","2001-12-26");
insertrec("4","r4400000152","t4400004c0003","S","2001-12-25");
insertrec("4","r4400000153","t4400005m0301","S","2001-12-26");
tocntrec();
$tb = "empl"; 
$query="create table empl (eid char(5),ename char(20),cryptpasswd char(13))";
$result=mysql_db_query($db,$query);
$pass = "abc";
$key = "thaiall";
$cryptpasswd = crypt($pass,$key);
insertrec("3c","e4401","Mr.Tatsanee","$cryptpasswd","");
insertrec("3c","e4402","Mr.Suwit","$cryptpasswd","");
tocntrec();
$tb = "cust"; 
$query="create table cust (cid char(7),cname char(20),addr char(40))";
$result=mysql_db_query($db,$query);
insertrec("3c","c440001","Ms.Pong","Yonok college lampang 52000","");
insertrec("3c","c440002","Ms.Ketsarin","Yonok college lampang 52000","");
insertrec("3c","c440003","Ms.Phimine","146 T.Sala A.Korkar Lampang 52130","");
tocntrec();
mysql_close($connect);
# == end ==
function insertrec($cntx,$x1,$x2,$x3,$x4) {
  global $db,$tb;
  if ($cntx=="2"){$query="insert into $tb values('$x1','$x2')";}
  if ($cntx=="3"){$query="insert into $tb values('$x1','$x2',$x3)";}
  if ($cntx=="3c"){$query="insert into $tb values('$x1','$x2','$x3')";}
  if ($cntx=="4"){$query="insert into $tb values('$x1','$x2','$x3','$x4')";}  
  $result = mysql_db_query($db,$query);  
  if ($result) { echo "<br>$query : Ok"; } else { echo "<br>$query : Error"; }   
}
function tocntrec(){
  global $db,$tb;
  $result = mysql_db_query($db,"select * from $tb");
  $cnt=mysql_num_rows($result);
  echo "<br>Total record : $cnt <hr>";
}
?>