Question

php sql语法出问题了

$sqlstr1="'insert into wiki.wiki_doc (authorid) values('$creatorid')where title='.$newtitle and 'content='.$newcontent";

错误信息：
failYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax

谁能帮忙看看这应该如何编写才正确？

Answer 1

$sqlstr1 = "insert into wiki.wiki_doc (authorid) values('".$creatorid."') where title='".$newtitle."' and content = '". $newcontent."'" ;

php 字符串与变量连接要用 .号
如果是写sql语句的话，
如果变量为字符串，则需要用单引号引住 即: $sql = "select * from aa where id='".$id."'";
数字则不需要 。即: $sql = "select * from aa where id=".$id;

Answer 2

楼上都是错的
正确的：$sqlstr1="insert into wiki.wiki_doc (authorid) values($creatorid) where title=$newtitle and content=$newcontent";

Answer 3

$sqlstr1="insert into wiki.wiki_doc (authorid) values ('$creatorid') where title=“."'$newtitle '"."'and content='"."'$newcontent'";

Answer 4

$sqlstr1="insert into wiki.wiki_doc (authorid) values('$creatorid')where title='.$newtitle' and content='.$newcontent'";