通过检索id php foreach删除mysql行

q35jwt9p  于 2021-06-23  发布在  Mysql
关注(0)|答案(1)|浏览(310)

我已经创建了一个foreach语句,它呼应了一些关于所有注册用户的信息,如何创建一个按钮来从行中删除该用户?我试过这个:

$query = "
SELECT id
     , name
     , bname
     , email
     , address
     , agent
     , status
     , notes 
  FROM prospects
";

        try {
            $stmt = $db->prepare($query);
            $stmt ->execute();
        }
        catch(PDOException $ex) {
            die("Failed to run query. Tell the website owner!");
        }
        $rows = $stmt->fetchAll();
        foreach($rows as $row) {
            echo "<tbody>
            <th>".$row['name']."</th>";
            echo "BLAH BLAH BLAH!";
            echo "<form method='post'><th><button type='submit' name='delete' class='btn btn-white btn-round btn-just-icon'>
                <i class='material-icons'>remove_circle_outline</i>
                <div class='ripple-container'></div>
            </button></th></tbody></form>";
        } $id = $db->prepare("SELECT id FROM example");
        $id->execute();

        $result = $id->fetch(PDO::FETCH_ASSOC);

        if(isset($_POST['delete'])) {
                try {
                    $sql = "DELETE FROM example WHERE id='".$result."'";
                    $db->exec($sql);
                }
                catch(PDOException $e) {
                    echo $sql . "<br />". $e->getMessage();
                }
            }

它返回以下错误:
注意:数组到字符串的转换。。。。
我知道这是因为我抓取了一个id,然后从数据库中抓取了一个id数组?那么,当我点击按钮时,如何删除一个特定的行呢?

yvgpqqbh

yvgpqqbh1#

必须指定数组中哪个元素包含id值。
尝试:

$sql = "DELETE FROM example WHERE id='".$result['id']."'";

相关问题