<?php
error_reporting(E_ALL);
$con = mysqli_connect("10.100.51.10","root","sdmDB123","sdms");
if (mysqli_connect_errno())
{
echo "Could not connect: " . mysqli_connect_error();
}
$group_date="1";
$sql1 = "INSERT INTO employment_record (Group_date,CAE_date,Group_Joinleave,CAE_JoinLeave,Fromwhere,Towhere,MR_issued_date,Staff_name)
VALUES ('$group_date','$CAE_date','$group_joinleave',$CAE_joinleave','$fromwhere[$i]','$towhere[$i]','$MR_issued_date[$i]','$staff_name')";
echo mysqli_query($con,$sql1);
?>
没有任何错误报告,mysqli_query也没有返回值,但是数据库里就是插入不了新的数据
但是下面这句更新的就可以成功更新
$sql = "UPDATE employment_record SET Group_date='$group_date',CAE_date='$CAE_date',Group_Joinleave='$group_joinleave',CAE_JoinLeave='$CAE_joinleave',Fromwhere='$fromwhere[$i]',Towhere='$towhere[$i]',MR_issued_date='$MR_issued_date[$i]'
WHERE Staff_name='$staff_name'AND id='{$row["id"]}' ";
这个是数据库表,实在没发现有什么错误