php - 在php中使用基于复选框的foreach将数据插入到两个表中

Question

需要帮助

任何人都可以根据我选中的复选框更正我使用 foreach 将数据插入两个表的代码

<?php


$con = mysqli_connect('localhost', 'root', '', 'a.karat');
if(isset($_POST['simpan']))
{

$poNo           = $_POST['poNo'];   
$prNo           = $_POST['prNo'];   
$cabang         = $_POST['cabang'];
$supplier       = $_POST['supplier'];   
$tanggal_po     = $_POST['tanggal_po'];
$tanggal_kirim  = $_POST['tanggal_kirim'];
$note           = $_POST['note'];
$ppn            = $_POST['ppn'];
$grandtotal     = $_POST['grandtotal'];

$query = mysqli_query($con,"INSERT INTO po (poNo,prNo,cabang,supplier,tanggal_po,tanggal_kirim,note,ppn,grandtotal)VALUES('$poNo', '$prNo','$cabang', '$supplier', '$tanggal_po',  '$tanggal_kirim', '$note', '$ppn','$grandtotal') mysqli_connect_error()");

$check=$_POST['check'];
foreach($check as $i)
{
    $prcode=$_POST['productCode'.$i];
    $prname=$_POST['productName'.$i];
    $qty=$_POST['qty'.$i];
    $harga=$_POST['harga'.$i];
    $diskon=$_POST['diskon'.$i];
    $total=$_POST['total'.$i];
    $query = mysqli_query($con,"insert into detail_po (poNo,productCode,productName,qty,harga,diskon,total) value ('$poNo', '$prcode', '$prname', '$qty', '$harga','$diskon','$total',)mysqli_connect_error()");
}
if($query)
{
?>
<script>
alert("success");
</script>
<?php
}
}

?>

我缺少什么，没有错误消息

提前致谢

Answer 1

从查询中删除mysqli_connect_error()。这导致查询失败。另外你的插入语句也不正确。将 value 替换为 values。您的第二个查询中有多余的逗号。

检查查询中是否有错误的正确方法是

$query = mysqli_query($con,"insert into detail_po
(poNo,productCode,productName,qty,harga,diskon,total)
values ('$poNo', '$prcode', '$prname', '$qty', '$harga','$diskon','$total')") or die(mysqli_error($con));