php - 使用 INSERT DATEDIFF 接收语法错误

Question

我收到此错误，并且没有将 DATEDIFF 插入数据库。我似乎找不到问题所在。我试着检查语法。有人可以帮忙吗？

// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$pdate = mysqli_real_escape_string($con, $_POST['pdate']);
$mdate = mysqli_real_escape_string($con, $_POST['mdate']);
$amt = mysqli_real_escape_string($con, $_POST['amt']);
$first = mysqli_real_escape_string($con, $_POST['first']);
$last = mysqli_real_escape_string($con, $_POST['last']);
$pid = mysqli_real_escape_string($con, $_POST['pid']);
$cno = mysqli_real_escape_string($con, $_POST['cno']);
$madd = mysqli_real_escape_string($con, $_POST['madd']);
$bene = mysqli_real_escape_string($con, $_POST['bene']);
$swc = mysqli_real_escape_string($con, $_POST['swc']);
$bacc = mysqli_real_escape_string($con, $_POST['bacc']);
$bank = mysqli_real_escape_string($con, $_POST['bank']);
$badd = mysqli_real_escape_string($con, $_POST['badd']);
$bno = mysqli_real_escape_string($con, $_POST['bno']);      

$sql="INSERT INTO contacts (
      nodays, interest, pdate, mdate, amt, first, last,
      pid, cno, madd, bene, swc, bacc, bank, badd, bno
    ) 
    VALUES (
      DATEDIFF($mdate,$pdate) AS nodays,
      (DATEDIFF($mdate,$pdate) * $amt / 365 * 0.1) AS interest,
      '$pdate','$mdate','$amt','$first','$last',
      '$pid','$cno','$madd','$bene','$swc','$bacc','$bank','$badd','$bno'
    )";



    if (!mysqli_query($con,$sql)) {
      die('Error: ' . mysqli_error($con));
    }
    echo "Client record has been added to the database!";

    mysqli_close($con);

Answer 1

问题是您尝试同时执行 2 个查询 - 仅以逗号分隔。那是行不通的。将它们分开并一个一个地执行。