createuser.php.txt

来自「一个PHP的购物系统源代码」· 文本 代码 · 共 51 行

<?
  $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++;
  }

  //不存在则创建之
  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 "Success!";

  }

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