我不能插入多个插入记录

Question

嗨，我想把这个信息从select插入多条记录

<?php
include_once("connect.inc.php");    

if (isset($_POST['submit'])) {
$province_id = $_POST['province_id'][$i];
$province_id = $_POST['travel_id'][$i];

$i = 0;
foreach ( $_POST as $val) {


mysql_query("INSERT INTO travel_list (province_id, travel_id) VALUES ('$province_id', '$travel_id')");
$i++;
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/bootstrap.min.css" rel="stylesheet" media="screen">
<script src="js/bootstrap.min.js"></script>
<title>Untitled Document</title>
</head>

<body>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
<script src="respond.js"></script>
<form action="index.php" method="post"> <!--ส่งค่า post ไปหน้าเดิม -->
<table width="896" border="1">
    <thead>
    <tr>
    <th width="239">จังหวัด</th>
<th width="552">สถานที่ท่องเที่ยว</th>
<th width="83"><input type="hidden" id="txtNum" value="1" size="2" /></th>
</tr>
<tr>
    <th width="239">
    <select id="selProvince" name="province_id[]"> <!--Default จังหวััด-->
        <option value="">กรุณาเลือกจังหวัด</option>
                <?PHP
                    $SelectPr="SELECT * FROM province";
                    $QueryPro=mysql_query($SelectPr);
                    while($Pro=mysql_fetch_array($QueryPro)){
                ?>
    <option value="<?=$Pro['province_id']?>"><?=$Pro['province_name']?></option>
<?PHP } ?>
</select>
</th>
<th width="552"><select name ="travel_id[]" id="selTravel"><option value="">กรุณาเลือกจังหวัด</option></select></th>
<th width="83"><button type="button" id="btnP">เพิ่มรายการ</button></th>
</tr>
<tr><td colspan="3"><center>รายการที่เพิ่ม</center></td></tr>
</thead>

<tbody>

</tbody>

</table>
<input name="submit" type="submit" value="add">

</form>




</body>
</html>

我插入了一条记录，但我只选择了一条，但更多的数据被导入到第五个数据中。

​

​

​

​

请帮帮我，我解决了这三天内不会来的问题。请帮我留出1天的项目BA时间

Answer 1

您在循环中递增计数器，但只获取第一个值-在循环之外

修复vars中的错误

$province_id = $_POST['province_id'][$i];
$travel_id = $_POST['travel_id'][$i];

删除循环和引号

mysql_query("INSERT INTO travel_list (province_id, travel_id) VALUES ($province_id, $travel_id)");

EDIT - IT应如下所示

<?php
include_once("connect.inc.php");    

if (isset($_POST['submit'])) {
    $province_id = $_POST['province_id'];
    $travel_id = $_POST['travel_id'];

    mysql_query("INSERT INTO travel_list (province_id, travel_id) VALUES    ($province_id, $travel_id)");
}
?>

Answer 2

我用的是插入3条记录

​

​

但是插入1条记录只是将数据插入到剩余的0 0 0数据中。

​

​

Answer 3

尝试仅迭代$_POST‘POST’，否则将循环遍历整个$_POST数据，其中还包括隐藏字段、提交按钮等……

foreach ( $_POST['province_id'] as $province_id) {

$travel_id= $_POST['travel_id'][$i];

mysql_query("INSERT INTO travel_list (province_id, travel_id) VALUES ('$province_id', '$travel_id')");
$i++;
}