我创建了一个复选框数据列表,其中填充了mysql数据库中的值。现在,当单击提交时,我想将选中的复选框数据提取到另一个页面"functions_two.php"中。由于复选框数据是从数据库中提取的,我似乎想不出这样做的方法。
下面是我更新的代码:
<?PHP
$hostname = "localhost";
$username = "root";
$password = "root";
$databaseName = "my computer";
$connect = mysqli_connect($hostname, $username, $password, $databaseName);
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
<html>
<body>
<form name="aform" action="functions_two.php" method="POST">
<div id="collegelane">College Lane campus:</div>
<?php
$q = mysqli_query($connect, "SELECT * FROM `campus`");
while ($line = mysqli_fetch_assoc($q)) {
echo '<input type="checkbox" name="car"
value="'.$line['room'].'">'.$line['room'].'</br>';
}
?>
</div>
</br>
</br>
<div id="dehav">De Havilland campus:</div>
<?php
$q = mysqli_query($connect, "SELECT * FROM `campus_two`");
while ($line = mysqli_fetch_assoc($q)) {
echo '<input type="checkbox" name="car"
value="'.$line['room'].'">'.$line['room'].'</br>';
}
?>
</br>
</br>
<div id="next"><input type="submit" name="next" Value="next"/></div>
</form>
</body>
</html>
functions_two.php页面代码如下:
<html>
<body>
<?php
$carchecked = $_POST['car'];
foreach ($carchecked as $cars){
echo $cars."<br />";
}
?>
</body>
</html>
试试这个:
$a.= '<input type="checkbox" name="car[]"
value="'.$line['room'].'">'.$line['room'].'</br>';
因此,您可以在functions_two.php 中获取数据
$carchecked = $_POST['car'];
foreach ($carchecked as $cars){
echo $cars."<br />";
}
由于您使用的是mysqli_connect,即连接mysql数据库的过程方式,因此您的查询必须如下所示:
$q = mysqli_query($connect, "SELECT * FROM `campus`");
while ($line = mysqli_fetch_assoc($q)) {
echo '<input type="checkbox" name="car[]"
value="'.$line['room'].'">'.$line['room'].'</br>';
}
你根本不需要这样的东西:$s=''$j=0$a="$b=0;。