<?
  $connect=mysql_connect("127.0.0.1","","");
  mysql_select_db("ebusiness");
  
  $result=mysql_list_tables("ebusiness");
  $i=0;
  $flag=false;

  //判定是否存在表User  
  while($i<mysql_num_rows($result))
  {
     if(mysql_tablename($reslut,$i)=="User" || mysql_tablename($reslut,$i)=="user")
     {
        $flag=true;
        break;
     }
     $i++;
  }

  //不存在則創(chuàng)建之
  if(!$flag)
  {
     $query="Creat table User"
     (
        UserID int unsigned not null auto_increment primary key,
        UserName varchar(20),
        UserPassWd char(32),
        UserEmail varchar(40) not null,
        UserTel varchar(16),
        UserAddr varchar(100),
        ACreateTime datetime,
        LLoginTime datetime,
        CLoginTime datetime,
        LoginCount int not null,
        UserCredit int not null,
        Liking1 varchar(30),
        Liking2 varchar(30),
        Liking3 varchar(30)
     )";

  //輸出成功信息
     if (mysql_query($query))
      echo "用戶信息表創(chuàng)建成功！";

  }

  //輸出表項已存在的信息
    else
     echo "The table User already exists!";
    mysql_close($connect);
?>