[数据库 插入] 提取表单变量插入数据库时报错

scbxfeng

　插入mysql数据库时报错：
代码：
<?
$name=$_POST["name"];
$email=$_POST["email"];
$phone=$_POST["phone"];
$subject=$_POST["subject"];
$word=$_POST["word"];
if (($name==""||($email==""||($phone==""||($subject==""||($word=="")
        {echo "字段不能为空!";
        }
$thedate=date("Y-m-j h:i:s";
$sql="insert into liuyan values ('$name','$email','$phone','$subject','$word','$thedate')";
$link=mysql_connect("localhost","root","bentxf";
$db=mysql_select_db("person",$link);
mysql_query($sql,$link);
header("location:gbook.php";
?>;



执行后：
PHP Notice: Undefined index: name in c:\inetpub\wwwroot\test\gbook.php on line 5 PHP Notice: Undefined index: email in c:\inetpub\wwwroot\test\gbook.php on line 7 PHP Notice: Undefined index: phone in c:\inetpub\wwwroot\test\gbook.php on line 9 PHP Notice: Undefined index: subject in c:\inetpub\wwwroot\test\gbook.php on line 12 PHP Notice: Undefined index: word in c:\inetpub\wwwroot\test\gbook.php on line 16

数据库中并没有任何动作，不知那位大哥能帮帮我，多谢啦。

goodloveboys

在开始处加上error_reporting(0);

或者改php.ini设置

scbxfeng

加了，没什么改变，还是报错。

goodloveboys

if (($name==""||($email==""||($phone==""||($subject==""||($word=="")
{echo "字段不能为空!";
}


而且这个位置,   并不能起到防止空白字符的作用

scbxfeng

但报错跟这个没有关系呀。

imbiss

把 gbook.php  贴出来。

carset

1. $sql="insert into liuyan values ('$name','$email','$phone','$subject','$word','$thedate')";
   
2. $link=mysql_connect("localhost","root","bentxf");
   
3. $db=mysql_select_db("person",$link);
   
4. mysql_query($sql,$link);
   
5. header("location:gbook.php");

复制代码

改成看看

1. $sql="insert into liuyan values ('$name','$email','$phone','$subject','$word','$thedate')";
   
2. $link=mysql_connect("localhost","root","bentxf");
   
3. $db=mysql_select_db("person",$link);
   
4. mysql_query($sql,$link) or die(mysql_error());
   
5. header("location:gbook.php");

复制代码

gaoyikun

原帖由 "scbxfeng" 发表：

$sql="insert into liuyan values ('$name','$email','$phone','$subject','$word','$thedate')";

这个，变量名用单引号括起来就成了普通字符串了吧？

Unicorn_angel

$sql="insert into liuyan values ('."$name".','."$email".','."$phone".','."$subject".','."$word".','."$thedate".')";

gaoyikun

[quote]原帖由 "Unicorn_angel"]$sql="insert into liuyan values ('."$name".','."$email".','."$phone".','."$subject".','."$word".','."$thedate".')";[/quote 发表：

我个人主张用sprintf语句格式化一下