php - 数据未插入我正在使用 php mysql

Question

这个问题已经有答案了:

Syntax error due to using a reserved word as a table or column name in MySQL (1 个回答)

已关闭 8 年前。

   <?php
    error_reporting(0);
    //connection
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "visionci";

    // Create connection
    $conn = new mysqli($servername, $username, $password,$dbname);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 

    //file properties
    //if (isset($_POST['image']))  

     $file = $_FILES["image"]["tmp_name"];


    if (!isset($file))
         {//echo "Please Select an Image";
         }

    else
        {   $name = $_POST["name"];
            $rollno = $_POST["rollno"];
            $address = $_POST["address"];
            $duration = $_POST["duration"];
            $course=$_POST["course"];
            $fname = $_POST["fname"];
            $mname = $_POST["mname"];
            $image=addslashes(file_get_contents($_FILES["image"]["tmp_name"]));
            $image_name= addslashes($_FILES["image"]["name"]);
            $image_size=  getimagesize($_FILES["image"]["tmp_name"]);

            if($image_size==FALSE)
                {echo "That's not an Image";}
            else
            {
                $sql = "INSERT INTO insert (rollno,name,image,address,duration,fname,mname,course)VALUES('$rollno','$name','$image','$address','$duration','$fname','$mname','$course')";

                if ($conn->query($sql) === TRUE) 
                {
                    //$lastid= mysqli_insert_id($conn);
                    echo "Record Inserted Successfully!";
                } 
                else 
                {
                    echo "Error: " . $sql . "<br>" . $conn->error;
                }


            }
        }

上面是我的代码。我收到一些垃圾值，然后出现错误 [您的 SQL 语法中有错误；检查与您的 MySQL 服务器版本相对应的手册，了解在第 1 行的 'insert (rollno,name,image,address,duration,fname,mname,course)VALUES('','','ÿØ' 附近使用的正确语法]

让我知道我在哪里遇到了问题，我被卡住了。

Answer 1

从 insert 更改表名称。这无法与命令 insert 区分开来，并且您无法在不转义的情况下从名为 insert 的表中进行选择

INSERT INTO something_else

或

INSERT INTO `insert`