从php表单添加新记录时出现SQL语法错误[重复]

Question

This question already has an answer here:

• Reference - What does this error mean in PHP? 34 answers

I have to following error "Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2"

Here is the script where I am inserting the form data to the table.

<?php
      include("config.php");
      $dbcon = new mysqli($host, $username, $pass, $database);

    // Check connection
    if (mysqli_connect_errno()) {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
      $inputCode=mysqli_real_escape_string($dbcon, $_POST['inputCode']);
      $inputType=mysqli_real_escape_string($dbcon, $_POST['inputType']);
      $inputRoom=mysqli_real_escape_string($dbcon, $_POST['inputRoom']);
      $inputStartTime=mysqli_real_escape_string($dbcon, $_POST['inputStartTime']);
      $inputEndTime=mysqli_real_escape_string($dbcon, $_POST['inputEndTime']);
      $inputDow=mysqli_real_escape_string($dbcon, $_POST['inputDow']);
      $inputStartDate=mysqli_real_escape_string($dbcon, $_POST['inputStartDate']);
      $inputEndDate=mysqli_real_escape_string($dbcon, $_POST['inputEndDate']);
      $sql="INSERT INTO class(ModuleCode,Type,Room,StartTime,EndTime,DayOfWeek,StartDate,EndDate)VALUES
                                          ('$inputCode','$inputType','$inputRoom','$inputStartTime','$inputEndTime','$inputDow','$inputStartDate','$inputEndDate'";


      if (!mysqli_query($dbcon,$sql)) {
      die('Error: ' . mysqli_error($dbcon));
    }
    echo "1 record added";

    mysqli_close($con);
    ?> 

</div>

Answer 1

Your missing a ) Change

$sql="INSERT INTO class(ModuleCode,Type,Room,StartTime,EndTime,DayOfWeek,StartDate,EndDate)VALUES
                                      ('$inputCode','$inputType','$inputRoom','$inputStartTime','$inputEndTime','$inputDow','$inputStartDate','$inputEndDate'";

to

$sql="INSERT INTO class(ModuleCode,Type,Room,StartTime,EndTime,DayOfWeek,StartDate,EndDate)VALUES
                                      ('$inputCode','$inputType','$inputRoom','$inputStartTime','$inputEndTime','$inputDow','$inputStartDate','$inputEndDate')";