Update a row with prepared statements OOP with PHP + Mysqli

Asked Apr 12 '14 at 13:45

Active Apr 12 '14 at 14:00

Viewed 113 times

I'm trying to a row in my 'users' table to activate their account.

if ( $stmt = $mysqli -> prepare(" users SET activated='1' WHERE activationCode=?") )      
{

    $stmt -> bind_param("s",$actvt );

    $stmt -> execute();

} else {

      echo $mysqli->error;

}

This doesn't seem to work, I just can't figure out how to do the ` statement, becauseSELECT` works everytime.

EDIT: I now refer to $mysqli->error; in the else statement, however, I mave no response whatsoever.

EDIT2: Read a comment, added mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); Now the error message states:

Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'Commands out of sync; you can't run this command now' in C:\xampp\htdocs\shop-homepage\activate.php:26 Stack trace: #0 C:\xampp\htdocs\shop-homepage\activate.php(26): mysqli->prepare('UPDATE users SE...') #1 {main} thrown in C:\xampp\htdocs\shop-homepage\activate.php on line 26

Line 26 is line 1 in my example

edited Apr 12 '14 at 14:00

asked Apr 12 '14 at 13:45

Rene

First of all http://stackoverflow.com/a/22662582/285587 – Your Common Sense Apr 12 '14 at 13:48
Refer to `$mysqli->error`. – MrCode Apr 12 '14 at 13:53
You're assuming that `$mysqli->prepare` fails, but it may be the call to `$stmt->execute`, that fails. Output `$mysqli->error` after that. – Callidior Apr 12 '14 at 14:03
@Callidior Get rid of the if statment? – Rene Apr 12 '14 at 14:06

Update a row with prepared statements OOP with PHP + Mysqli

0 Answers0