PHP管理mysql数据库中的数据这条语句为什么总出现语法错误，我并没有看到这行出了什么错误

Question

<?php header("content-type:text/html;charset=utf-8"); include_once("conn.php"); if(!($_POST['bookname']and $_POST['price'] and $_POST['f_time'] and $_POST['type'])){ echo "输入不允许为空。单击<a href='javascript:onclick=history.go(-1)'>这里</a> 返回"; }else{ $result = mysqli_query($conn,$sqlstr1); if($result){ $sqlstr1 ="insert into tb_demo02 values(","'.$_POST['bookname'].'","'.$_POST['bookname'].' ","'.$_POST['bookname'].'","'.$_POST['bookname'].'")"; echo "添加成功,点击<a href='select.php'>这里</a>查看"; }else{ echo "<script>alert('添加失败');history.go(-1);</script>"; } }?>Parse error: syntax error, unexpected ',' in C:\xampp\htdocs\11.php on line 9

Answer 1

看错误提示是第9行，我尝试看了下，应该改为

$sqlstr1 ='insert into tb_demo02 values("'.$_POST['bookname'].'","'.$_POST['bookname'].'

","'.$_POST['bookname'].'","'.$_POST['bookname'].'")";

第一个字符串前面是双引号，你后面又用了单引号，sql语句还多可个逗号

望采纳