Clash Royale CLAN TAG

Delete row from table where A=x AND B=y using PHP pdo

I'm trying to delete from a database table where two fields match a value.
on the page javascript makes an ajax call to the php file below passing the relevant values, in the response however it returns "[object object]" rather than "deleted" and the record is still in the table.

Here's my code in PHP

if(isset($_POST['booking'])==true){
$booking = $_POST['booking'];
$vec_id= $_POST['id'];

$stmt = $pdo->prepare("DELETE FROM booked_vec WHERE booking_id = ? AND vec_id = ?");
$stmt->execute(array($booking,$vec_id));
$stmt = null;
}


It gets inside the if without problems. $booking and $vec_id both contain the correct values.

$pdo is a working connection to the database that works with other statements. I assume something wrong with either the statement or itself or the way I'm passing variables into the statement. I'm unable to find an example online of an AND being used in the context of a DELETE statement with pdo.

Could someone please advise where I'm going wrong?

if(isset($_POST['booking'])==true)

1 Answer
1

Do it like this using bindParam() so it will bind $booking to the first placeholder and $vec_id to the second placeholder

$stmt = $pdo->prepare("DELETE FROM booked_vec WHERE booking_id = ? AND vec_id = ?");
$stmt->bindParam(1, $booking);
$stmt->bindParam(2, $vec_id);
$stmt->execute();


And also note that some drivers required to use closeCursor before executes another statement

PDOStatement::closeCursor() frees up the connection to the server so that other SQL statements may be issued, but leaves the statement in a state that enables it to be executed again

?

The SQL statement can contain zero or more named (:name) or question mark (?) parameter markers for which real values will be substituted when the statement is executed.

bindparam

execute

execute(array($booking,$vec_id))

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.