Php mysql查询语法错误(未知字段) - Php mysql query syntax error (Unknown field)

Php mysql query syntax error (Unknown field)

include("db_connector.php");
    $soru = "asdasds";
    $tip = 1;
    $soruId = 0;
        $sql = "insert into sor (anketId,soruMetni,tip) values (".$_SESSION['anket'].",".$soru.",".$tip.")";
        $islem = mysql_query($sql)or die(mysql_error());;
        if(isset($islem))
        {
            $soruId = mysql_insert_id();
        }else
        {
            header("refresh:2;sorular.php");
        }

此代码给出如下错误:Unknown列'asdasds'在'字段列表'

您需要更改下面的SQL语句:

$sql = "INSERT INTO `sor` (anketId,soruMetni,tip) 
        VALUES ('".$_SESSION['anket']."','".$soru."',".$tip.")";

字符串需要用单引号封装。:)

我只是在查询中的每个变量之前和之后添加'。如果不添加单引号'，就不能将string传递给query。

改变:

$sql = "insert into sor (anketId,soruMetni,tip) values (".$_SESSION['anket'].",".$soru.",".$tip.")";

to:

$sql = "INSERT INTO `sor` (anketId,soruMetni,tip) 
        VALUES ('".$_SESSION['anket']."', '".$soru."', '".$tip."')";