MySQLI Prepared Statements Example

<?php




// prepare the query
$wadb_login_stmt = $con->prepare("UPDATE login SET password=? WHERE email=?");

// check if it succeeded and throw error if not
if ($wadb_login_stmt === false) {
    trigger_error($con->error, E_USER_ERROR);
}

// bind the params
$wadb_login_stmt->bind_param("ss", $pass, $email);

// execute the query
$wadb_login_stmt->execute();

// see if it succeeded and throw error if not
if ($wadb_login_stmt === false) {
    trigger_error($wadb_login_stmt->error, E_USER_ERROR);
}

// print number of rows affected
printf("%d Rows affected.\n", $wadb_login_stmt->affected_rows);