将复选框中的多个值传递到要删除的另一页 - Pass multiple values selectedincheckboxto anotherpage to Delete

Pass multiple values selectedincheckboxto anotherpage to Delete

本文关键字：删除一页值传复选框 | 更新日期: 2023-09-27

我想将复选框中选择的多个值从一个页面存储到另一个页面，另一个页面将在其中执行删除操作。我想传递值并在另一个页面中接收值。这是我的代码：

<?php include 'menu.php';?>
<?php include 'menu_admin.php';?>
<link rel = "stylesheet" type="text/css" href="Form.css">
<?php include 'connect.php';?>
<?php
  $sql = "SELECT * FROM ads";
$result = $db->query($sql);
//the function num_rows() checks if there are more than zero rows returned
if ($result->num_rows > 0) {
   echo "<table><tr><th>SELECT</th><th>ADID</th><th>ADName</th><th>ADCATEGORY</th><th>CONTACTNUMBER</th><th>EXPIRATIONDATE</th></tr>";
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<tr>";
echo "<td> 
        <input type='checkbox' id = 'checkbox' name='checkbox[]' value=".$row['ADID']." > ".$row['ADID']."
    </td>";
echo "<td>" .$row["ADID"]. "</td>";
echo "<td><a href=#>" .$row["ADNAME"]. "</a></td>";
echo "<td>" .$row["ADCATEGORY"]. "</td>";
echo "<td>" .$row["CONTACTNUMBER"]. "</td>";
echo "<td>" .$row["EXPIRATIONDATE"]. "</td>";

echo "</tr>";
    }
    echo "</table>";
} else {
    echo "0 results";
}


        $result->free();
?>
<?php 

 $myCheckVar = $_POST['checkbox'];
?>

      <input type="submit" value='Delete' name="Delete" onClick="window.location='deletead.php?myvalue=$myCheckVar';"/>

    <input type="submit" value='Update' name="update"/>
    <input type="submit" value="New" name="new" onClick="window.location='post_ad.php?user=$username';"/>

请帮忙

将

表封装在表单标记中，并将操作设置为控件文件。您可以将 POST 变量作为数组访问。

尝试下面的代码。待办事项：将YOUR_URL_TO_CATCH_THE_FORM更改为需要捕获表单的 URL。

<?php include 'menu.php';?>
<?php include 'menu_admin.php';?>
<link rel = "stylesheet" type="text/css" href="Form.css">
<?php include 'connect.php';?>
<?php
  $sql = "SELECT * FROM ads";
$result = $db->query($sql);
//the function num_rows() checks if there are more than zero rows returned
if ($result->num_rows > 0) {
   echo "<form action='"YOUR_URL_TO_CATCH_THE_FORM'" method='"POST'">";
   echo "<table><tr><th>SELECT</th><th>ADID</th><th>ADName</th><th>ADCATEGORY</th><th>CONTACTNUMBER</th><th>EXPIRATIONDATE</th></tr>";
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<tr>";
echo "<td> 
        <input type='checkbox' id = 'checkbox' name='checkbox[]' value=".$row['ADID']." > ".$row['ADID']."
    </td>";
echo "<td>" .$row["ADID"]. "</td>";
echo "<td><a href=#>" .$row["ADNAME"]. "</a></td>";
echo "<td>" .$row["ADCATEGORY"]. "</td>";
echo "<td>" .$row["CONTACTNUMBER"]. "</td>";
echo "<td>" .$row["EXPIRATIONDATE"]. "</td>";

echo "</tr>";
    }
    echo "</table>";
    echo "</form>";
} else {
    echo "0 results";
}

然后在你的"YOUR_URL_TO_CATCH_THE_FORM"php中捕获POST表单，如下所示：

if(isset($_POST) && !empty($_POST))
{
    if(isset($_POST['checkbox']) &&  !empty($_POST['checkbox']))
    {
        foreach($_POST['checkbox'] as $key => $value)
        {
            echo 'This is checkbox value '.$key.': '.$value;
        }
    }
}