首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >PHP复选框问题(未删除行)

PHP复选框问题(未删除行)
EN

Stack Overflow用户
提问于 2019-07-17 03:19:57
回答 1查看 37关注 0票数 -1

我做了一个简单的HTML网页,上面有员工列表(只有两台自动取款机)。

代码语言:javascript
复制
    <form method="post" action = "del.php">
    <table border = "1">
        <tr>
            <th>Employee Name</th>
        </tr>
        <?php
            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "lavoratori";

            // Create connection
            $conn = new mysqli($servername, $username, $password, $dbname);

            // Check connection
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            } 

            $sql = "SELECT nome, id FROM operai";

            $result = $conn->query($sql);

            if ($result->num_rows > 0) {
                // output data of each row
                while($row = $result->fetch_assoc()) {

                    echo"<tr>";
                    echo'<td><input type = "checkbox" name = checkbox[]" value = '.$row['id']."<td>".$row['nome']."</td>";
                    echo"</tr>";  

                }
                echo"</table>";
            }
            $conn->close();
        ?>
        <input type = "submit" name = "delete" id = "delete" value = "Delete Records">
    </form>

这是del.php

代码语言:javascript
复制
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "lavoratori";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
             die("Connection failed: " . $conn->connect_error);
} 

if(isset($_POST['delete'])){
    $chkarr = $_POST['checkbox'];
    foreach($chkarr as $id){
        $sql = "DELETE FROM operai WHERE id = .$id.";
        $result = $conn->query($sql);
    }
    header("Location: /test_purpose/home.php");
}
$conn->close();

?>

你们能告诉我发生了什么吗?我是PHP新手。我想要做的是从使用复选框选择中删除特定的一行。而且它不起作用,它会将我重定向回主页,而不会删除任何明显的内容。

EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/57064105

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档