执行mysql插入语句_php mysql执行插入语句报错

最新推荐文章于 2023-01-04 17:37:58 发布

Certain Y

最新推荐文章于 2023-01-04 17:37:58 发布

阅读量351

点赞数

文章标签：执行mysql插入语句

本文链接：https://blog.csdn.net/weixin_42519489/article/details/113306070

版权

$sql="insertintotest1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result)values('$str','$name','$sex','$age','$telephone','$hos...

$sql="insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result')";

$result=mysql_query($sql);

if(!$result)

{

echo "插入失败";

}

else

echo "插入成功";

当代码是上面的执行就成功

但是当代码变成下面的就不能执行了，只是多加了一个$add,

print"$add";这句这行成功

$sql="insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result,add) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result','$add')";

$result=mysql_query($sql);

if(!$result)

{

echo "插入失败";

}

else

echo "插入成功";

而且

在mysql中执行

insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result');是正确的，可以插入

但是执行

insert into test1(num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result,add) values('$str','$name','$sex','$age','$telephone','$hospital','$id','$area','$bed','$sample','$num','$doctor','$data','$dig','$object','$result','$add');错误，不能执行。

table名：test1

表头包括：num1,name,sex,age,telephone,hospital,id,arear,bed,sample,num,doctor,data,dis,subobject,result,add

执行mysql语句时values中已经换成对应的内容了。

展开