使用 php pdo 删除我的数据库中的行 [英] delete row in my database using php pdo

问题描述

我试图删除我数据库中的一行，同时从 url 获取它的 id例如 exmaple.com/deleteTeam.php?Id=?<<this is the selected id from radio button option and it will be equal to number when selected like Id=1.

i am trying to delete a row in my database while getting it's id from the url for exmaple exmaple.com /deleteTeam.php?Id=? << this is the selected id from radio button option and it will be equal to number when selected like Id=1.

include ('connnect.php'); 
// this connect my database and working
$command = "DELETE * FROM SoccerPoll WHERE Id=?";
$stmt = $dbh ->prepare($command);
$stmt->execute($_GET['Id']);

推荐答案

您可以在尝试执行查询之前使用 bindParam 或 bindValue.

You can use bindParam or bindValue before trying to execute que query.

$command = " DELETE FROM SoccerPoll WHERE Id=:id LIMIT 1";
$stmt = $dbh ->prepare($command);
$stmt->bindParam(':id', $_GET['Id'], PDO::PARAM_INT);
$stmt->execute();

这篇关于使用 php pdo 删除我的数据库中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！