简单删除php pdo查询


Simple DELETE php pdo query

我想删除数据,但有多个条件,所以我这样写:

$STH = $DBH->prepare("DELETE FROM track_aktivnosti WHERE (ID,ajdi), VALUES(:id,:ajdi)");
            $STH->bindParam(':id', $_POST['vrednostid']);
        $STH->bindParam(':ajdi', $_POST['ajdi']);

,但我有错误是声明?我需要改变什么?

您的SQL语法错误。应该是

$STH = $DBH->prepare("DELETE FROM track_aktivnosti WHERE ID=:id AND ajdi=:ajdi");
$STH->bindParam(':id', $_POST['vrednostid']);
$STH->bindParam(':ajdi', $_POST['ajdi']);
$STH->execute();
$stmt = $dbh->prepare("DELETE FROM track_aktivnosti WHERE (ID = ? and ajdi = ?)");
$stmt->execute(array($_POST['vrednostid'],$_POST['ajdi']));