php - 无法插入到 mySQL 中。报名表格

Question

我有一个有效的注册表，但我不知何故搞砸了。我在移动上传行中遇到此错误，我真的不知道如何修复它，因为它正在工作，而且我没有特别更改该行。

Parse error : syntax error, unexpected '"', expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in /home/nel/public_html/test/process.php on line 18

    <?php
    include "config.php";

$name = $_POST['name'];
$school= $_POST['school'];
$email = $_POST['email'];
$grad_year = $_POST['gradYear'];
$hardware = $_POST['hardware'];
$type = $_FILES["file"]["type"];

if(empty($name) || empty($school) || empty($email) || empty($grad_year) || !filter_var($email, FILTER_VALIDATE_EMAIL))
{
   echo "You did not fill out the required fields correctly. Please try again!";
}
else{
$insert = "INSERT INTO hackers VALUES('$name','$email','$school','$grad_year’,’$hardware’)”;

move_uploaded_file($_FILES["file"]["tmp_name"], "/home/nel/resumes/" . $_FILES["file"]["name"]); 

echo "Thank you for registering!”;

echo $name= $_Files['file']['name'];

    $conn->query($insert);
}

    ?>

Answer 1

这里使用勾号代替单引号'$grad_year','$hardware'。更改它，您的错误就会消失。

您还应该使用准备好的语句。它更加安全和可读。