解析错误：语法错误，意外'；'在C：\xampp\htdocs\webdev\auto-parts-db\submit_processor.php第6行[重复]

Question

我确信这是一个愚蠢的问题，但我对将查询硬编码到php文件有点陌生，我不明白为什么会出现这个错误。

我要做的是将表单中的文本输入添加到数据库表的列中。这是我所拥有的：

form.php

<form action="submit_processor.php" method="post">
<h2>Add Auto Part</h2>
<h3>Part Name:</h3>
<input type="text" name="available_parts">
<h3>SKU:</h3>
<input type="text" name="partSKU">
<h3>Vehicle Make:</h3>
<input type="text" name="vehicle_make">
<h3>Vehicle Model:</h3>
<input type="text" name="vehicle_model">
<h3>Vehicle Year:</h3>
<input type="text" name="vehicle_year">
<br /><br />
<input type="submit">
</form>

提交处理器。php

<?php
//Connecting to sql db.
$connect = mysqli_connect("my host","my user","my password","my db");
//Sending form data to sql db.
mysqli_query($connect,"INSERT INTO auto_parts (available_parts, partSKU,     vehicle_make, vehicle_model, vehicle_year)
VALUES ('$_POST[available_parts]', '$_POST[partSKU]',     '$_POST[vehicle_make]', '$_POST[vehicle_model]', '$_POST[vehicle_year]')";
?>

任何帮助都会很好！

Answer 1

最后失踪了

mysqli_query($connect,"INSERT INTO auto_parts (available_parts, partSKU,     vehicle_make, vehicle_model, vehicle_year)
VALUES ('$_POST[available_parts]', "
    . "'$_POST[partSKU]',"
    . "'$_POST[vehicle_make]', "
    . "'$_POST[vehicle_model]', '$_POST[vehicle_year]')");
                                                        ^//missing )