下面直接上代码
复制代码 代码如下:
<?php
//date_default_timezone_set("Asia/Shanghai");

function create_guest()
{
global $conn,$table_guest;
$sql = "create table $table_guest(
gid int(11) auto_increment not null,
g_name varchar(50) not null,
g_site varchar(50) not null,
g_mail varchar(50) not null,
g_cid int(5) not null,
PRIMARY KEY(gid)
)";
$dropsql = "drop table if exists $table_guest";
mysql_query($dropsql,$conn)or die("删除表".$table_guest."失败");
mysql_query($sql,$conn)or die("创建表".$table_guest."失败");
}
function create_sql()
{
global $table_article,$table_member,$table_class,$table_guest,$conn;
echo "创建siteinfo表\r……";
create_siteinfo();
echo "完成<br>";
echo "创建".$table_article."表\r……";
create_article();
echo "完成<br>";
echo "创建".$table_member."表\r……";
create_member();
echo "完成<br>";
echo "创建".$table_class."表\r……";
create_class();
echo "完成<br>";
echo "创建".$table_guest."表\r……";
create_guest();
echo "完成<br>";
mysql_close($conn);
}
?>