我试图删除数据库中的一行,同时从url中获取该行的id对于exmaple exmaple.com/deleteTeam.php?Id=<lt;这是从单选按钮选项中选择的id,当选择时,它将等于数字,如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。
$command = " DELETE FROM SoccerPoll WHERE Id=:id LIMIT 1";
$stmt = $dbh ->prepare($command);
$stmt->bindParam(':id', $_GET['Id'], PDO::PARAM_INT);
$stmt->execute();
删除将以以下方式执行
$sql = "DELETE FROM movies WHERE filmID = :filmID";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':filmID', $_GET['filmID'], PDO::PARAM_INT);
$stmt->execute();