从php表单添加新记录时出现SQL语法错误[重复]
问题描述:
This question already has an answer here:
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>
此问题已经存在 这里有一个答案: p>
-
参考 - 这个错误在PHP中意味着什么?
34答案
\ n span>
li>
ul>
div>
我必须遵循以下错误 “错误:您有错误 在您的SQL语法中;查看与您的MariaDB服务器版本对应的手册,以便在第2行''附近使用正确的语法 p>
这是我插入表单数据的脚本 到桌子。 p>
&lt;?php include(“config.php”); $ dbcon = new mysqli($ host,$ username,$ pass,$ database); //检查连接 if(mysqli_connect_errno()){ echo“无法连接到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类(ModuleCode,Type,Room,StartTime,EndTime,DayOfWeek,StartDate,EndDate)VALUES ('$ inputCode','$ inputType',' $ inputRoom','$ inputStartTime','$ inputEndTime','$ inputDow','$ inputStartDate','$ inputEndDate'“; if(!mysqli_query($ dbcon,$ sql)){\ n die('错误:'。mysqli_er ror($ dbcon)); } echo“添加了1条记录”; mysqli_close($ con); ?&gt; code> pre> div>
答
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')";