我已经创建了一个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数组?那么,当我点击按钮时,如何删除一个特定的行呢?
1条答案
按热度按时间yvgpqqbh1#
必须指定数组中哪个元素包含id值。
尝试: