代码如下
<?php
$zt=$_POST['zhuti'];
$rq=$_POST['riqi'];
$nr=$_POST['neirong'];
$bm=$_POST['bumen'];
$dbc=mysqli_connect('localhost','root','123456','cz1') or die('error connection');
$query="INSERT INTO `taizhang` (`zhuti`,`bumen`,`riqi`,`neirong`) VALUES ('$zt','$bm','$rq','$nr')";
$result = mysqli_query($dbc,$query) or die ('error result');
mysqli_close($dbc) or die('error close');
?>
按照正常格式写之后依旧查询失败
<?php
$zt=$_POST['zhuti'];
$rq=$_POST['riqi'];
$nr=$_POST['neirong'];
$bm=$_POST['bumen'];
$dbc=mysqli_connect('localhost','root','123456','cz1') or die('error connection');
$query="INSERT INTO taizhang(zhuti,bumen,riqi,neirong) VALUES ('$zt','$bm','$rq','$nr')";
$result = mysqli_query($dbc,$query) or die ('error result');
mysqli_close($dbc) or die('error close');
?>
SELECT * FROM 'taizhang
口显示全部行数 25 过滤行: 在表中搜索
+选项
## zhuti Id BUMEN rigi neirong
D #编辑复制 删除
全选 选中项: #编辑 柔复制 删除
O显示全部行数: 25 过滤行: 在表中搜索
$query="INSERT INTO `taizhang` (`zhuti`,`bumen`,`riqi`,`neirong`) VALUES ('$zt','$bm','$rq','$nr')";
die($query);//输出sql语句看具体内容是什么,组合sql语句,看代码如果输入单引号sql语句就会出错。字符串不闭合了,需要注意替换掉单引号防止sql注入之类的