本文介绍了使用php pdo删除数据库中的行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在尝试从url中获取ID的同时删除数据库中的一行例如exmaple.com/deleteTeam.php?Id=? <<这是从单选按钮选项选择的ID和当选择似ID = 1这将是等于数.
i am trying to delete a row in my database while getting it's id from the urlfor 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']);
推荐答案
您可以在尝试执行que查询之前使用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删除数据库中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！