$stmt->execute() : How to know if db insert was successful?

Question

With the following piece of code, how do i know that anything was inserted in to the db?

if ($stmt = $connection->prepare("insert into table (blah) values (?)")) { $stmt->bind_param("s", $blah);   $stmt->execute();            $stmt->close();                                  } 

I had thought adding the following line would have worked but apparently not.

if($stmt->affected_rows==-1){$updateAdded="N"; echo "failed";}   

And then use the $updatedAdded="N" to then skip other pieces of code further down the page that are dependent on the above insert being successful.

Any ideas?

Answer 1

The execute() method returns a boolean ... so just do this :

if ($stmt->execute()) {     // it worked } else {    // it didn't } 

Answer 2

Check the return value of $stmt->execute()

if(!$stmt->execute()) echo $stmt->error; 

Note that line of code does perform the execute() command so use it in place of your current $stmt->execute() not after it.