当日期需要插入mysql表时,它会提示此错误-
错误:您的SQL语法有错误;查看手册与您的MySQL服务器版本相对应,以便使用正确的语法靠近第2行的","2013-09-11","1",NULL)
这是我的源代码:
if(isset($_POST['submitsub']))
{
$stuid = $_POST['stuid'];
$stuname = $_POST['stuname'];
$stuemail = $_POST['stuemail'];
$stumajor = $_POST['stumajor'];
$appdate = date("Y-m-d");
$appointment = $_POST['date'];
$subno = $_POST['subject'];
$appstatus = 1;
$tri = mysqli_fetch_assoc(mysqli_query($con,"SELECT this_tri FROM trimester"));
$sql = "INSERT INTO application_subject (app_no, tri_id, sub_id, stu_id, stu_name, stu_email, stu_major, app_date, appointment_date, app_status, app_remark)
VALUES (NULL,'$tri[this_tri]','$subno','$stuid','$stuname','$stuemail','$stumajor',$appdate','$appointment','$appstatus', NULL)";
if (!mysqli_query($con,$sql))
{
die('Error: ' . mysqli_error($con));
}
echo'<script>alert("Your application has been submited") </script>';
ob_flush();
}
在我的mysql中,的属性已经设置为date。
查询中$appdate变量之前缺少一个引号。
您在以下内容中缺少一个引号:
'$stumajor',$appdate','$appointment'
应该是
'$stumajor','$appdate','$appointment'
您忘记了$appdate'之前的'
字符
'$stumajor',$appdate'
这应该是
'$stumajor','$appdate'