$table_list = mysql_query("show tables");
while($row=mysql_fetch_array($table_list))
{
if(in_array("login", $row))
{
$agsql="INSERT INTO login(loginId, name, password, email, phone)
VALUES (null,'$name','$password','$email','$phone')";
$result=mysql_query($agsql);
if($result>0)
{
echo "数据插入成功!";
}
else
{
echo "数据保存失败!";
}
}
else
{
$sql="create table login(
loginId int not null primary key auto_increment,
name varchar(32) not null,
password varchar(32) not null,
email varchar(40) not null,
phone varchar(22) not null
)";
mysql_query($sql);
$agsql="INSERT INTO shuju(loginId, name, password, email, phone)
VALUES (null,'$name','$password','$email','$phone')";
$result=mysql_query($agsql);
if($result>0)
{
echo "数据插入成功!";
}
else
{
echo "数据保存失败!";
}
}
while($row=mysql_fetch_array($table_list))
{
if(in_array("login", $row))
{
$agsql="INSERT INTO login(loginId, name, password, email, phone)
VALUES (null,'$name','$password','$email','$phone')";
$result=mysql_query($agsql);
if($result>0)
{
echo "数据插入成功!";
}
else
{
echo "数据保存失败!";
}
}
else
{
$sql="create table login(
loginId int not null primary key auto_increment,
name varchar(32) not null,
password varchar(32) not null,
email varchar(40) not null,
phone varchar(22) not null
)";
mysql_query($sql);
$agsql="INSERT INTO shuju(loginId, name, password, email, phone)
VALUES (null,'$name','$password','$email','$phone')";
$result=mysql_query($agsql);
if($result>0)
{
echo "数据插入成功!";
}
else
{
echo "数据保存失败!";
}
}
if(in_array("login", $row))
存在则插入数据
else
不存在则创建 login 表
然后对 shuju 表插入数据是否合乎逻辑,只有你自己知道
else
{
$sql="create table login(
loginId int not null primary key auto_increment,
name varchar(32) not null,
password varchar(32) not null,
email varchar(40) not null,
phone varchar(22) not null
)";
mysql_query($sql);
$agsql="INSERT INTO shuju(loginId, name, password, email, phone)
VALUES (null,'$name','$password','$email','$phone')";
$result=mysql_query($agsql);上面创建的表名为:login 下面插入的表名叫shuju?