大家好，我是新来的！我想知道如何在勾选特定复选框时插入打印行的值。
这是我的代码：
<?php
$query = "SELECT * FROM phpmyreservation_forvalidation";
$result = mysql_query($query);
?>
<form action='insertrecords.php' method='post'>
<?php
echo "<table cellpadding='0' cellspacing='0' border='1'>";
echo "<tr> <th>reservation_id</th> <th>reservation_user_name</th> <th>reservation_day</th> <th>reservation_week</th>
<th> # </th></tr>";
while($row = mysql_fetch_array( $result )) {
echo "<tr><td>";
echo $row['reservation_id'];
echo "</td><td>";
echo $row['reservation_user_name'];
echo "</td><td>";
echo $row['reservation_day'];
echo "</td><td>";
echo $row['reservation_week'];
echo "</td><td align='center'>";
echo "</td>";
?>
<td><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?= $row['id'] ?>" ></td>
<?php
}
echo "</table>";
?>
<input type='submit' value='Submit' />
</form>
不确定我所做的是否正确，我也没有插入记录.php但我试图制作一个但没有用，现在我真的很困惑。有谁知道我该怎么做？谢谢！
附加说明：我正在做的是一个验证系统，尚未验证的计划位于单独的表上，当管理员验证它们时，它将入到phpmyreservation_reservations表中。
谢谢！
将
"phpmyreservation_forvalidation"结果提取到变量中，并在提交表单时将其插入"phpmyreservation_reservations"表中。
如果我是你，我会使用 AJAX 调用从你的数据库中获取所需的所有数据，并将数据插入到新表中。在下面的示例中，我使用 jQuery 进行 ajax 调用。
我的示例网页代码：
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width" />
<title>Title of the page</title>
<script src="jquery-1.10.2.min.js"></script>
<script>
// Function beeing called when a checkbox is changed
function MyCheckboxChanged(sender)
{
// Send the data to be processed to the server if the checkbox is checked
if (sender.checked)
{
var MyObject = {};
MyObject.ValueToInsert = sender.value;
DoAJAXData("insert", MyObject);
}
}
// Function responsible for AJAX calls - requires jQuery
function DoAJAXData(command, MyObject)
{
$.post("phpReceiver.php",
{
command:command,
sendObject:JSON.stringify(MyObject)
})
.success(function(data)
{
// Process the data echoed from php
// In my case, should alert: "successfully inserted data: " + your selected checkbox value
alert(data);
})
.fail(function(error){
//alert("Unable to retrieve data from the server");
});
}
</script>
</head>
<body>
<?php
for ($i=0; $i < 5; $i++)
{
$var = <<<CHB
<input type="checkbox" onchange="MyCheckboxChanged(this);" name="$i" value="Bike number $i">I have a bike number $i</br>
CHB;
echo $var;
}
?>
</body>
</html>
和 phpReceiver .php 代码：
<?php
$command = $_POST['command'];
$object = json_decode($_POST['sendObject'], true);
if ($command == "insert")
{
$valueToInsert = $object['ValueToInsert'];
// Do you insertion to the database here
// Echo any results if wanted
echo "successfully inserted data: $valueToInsert";
}
?>
在记录中.php：
$row_id=$_POST['checkbox'];
foreach ($row_id as $key=>$val)
{
//do insert here with $val
}