php - 我在 php 中收到此( T_CONSTANT_ENCAPSED_STRING )语法错误

Question

这个问题已经有答案了:

Reference - What does this error mean in PHP? (38 个回答)

已关闭 5 年前。

我收到此错误

(syntax error, unexpected '","' (T_CONSTANT_ENCAPSED_STRING), expecting ',' or ')' in C:\xampp\htdocs\offline Storage\online form.php on line 14)

我的代码是...

<?php

if(isset($_POST['first'],$_POST['last'],$_POST['email'],$_POST['fdback']))
{
    $conn=mysql_connect("localhost","root","root@localhost");

    mysql_select_db("feedback");
    $fname=$_POST['first'];
    $lname=$_POST['last'];
    $eml=$_POST['email'];
    $fdb=$_POST['fdback'];

    $result=mysql_query("insert into data values(".$fname",".$lname",".$eml",".$fdb")");

    if($result)
    {
        echo "Data Inserted";
    }
    else
    {
        echo "Error"
    }
};

?>

Answer 1

您错过了 concat 变量后面的点

$result=mysql_query("insert into data values(".$fname. ",".$lname. ",".$eml. ",".$fdb. ")");

但是你不应该在sql代码中使用php var..你有sqlinjection的风险..你应该看看你的mysql驱动程序以绑定(bind)参数