How can I check if my SQL update has gone through?

Question

Here is my prepared statement

 $stmt = $db->prepare("UPDATE user SET :property=:value WHERE `id`=:id");
 $stmt->execute([':property' => $property, ':value' => $value]);
 $row = $stmt->fetchAll(PDO::FETCH_ASSOC);

How can I quickly verify that the query has gone through successfully?

I was thinking maybe an if() around the execute part?

you can try `$stmt->rowCount` to check the amount of updated rows after the execute. — Phiter, Jan 13 '17 at 00:30

score 1 · Accepted Answer · answered Jan 13 '17 at 00:31

1

Try this

if($stmt->rowCount() > 0){
   echo 'SUCCESS';
}else{
   echo 'ERROR';
}

answered Jan 13 '17 at 00:31

Abdalla Arbab

1,360
3
23
29

score 0 · Answer 2 · edited Jun 20 '20 at 09:12

0

All you need to do is test the returned $stmt like this.

Remember both the prepare and the execute can fail and should be checked

$stmt = $db->prepare("UPDATE user SET :property=:value WHERE `id`=:id");
if ( $stmt == false ) {
    print_r($db->errorInfo());
    exit;
}
$stmt->execute([':property' => $property, ':value' => $value]);
if ( $stmt == false ) {
    print_r($db->errorInfo());
    exit;
}

This query will definitely fail

Now I look closer, you have a huge syntax error in the query. You cannot parameterise column or table names.

You also pave 3 parameters and only 2 values

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 13 '17 at 00:31

RiggsFolly

93,638
21
103
149

I realized that, I can't parameterise any column names, so big switch statement it is xD, thanks – Heraclitus Jan 13 '17 at 14:15

How can I check if my SQL update has gone through?

2 Answers2