如何检查我的SQL更新是否已通过？ [重复]

Question

This question already has an answer here:

• Can PHP PDO Statements accept the table or column name as parameter? 7 answers

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?

</div>

Answer 1

Try this

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