MYSQL Error Get Prepared Statement

Question

How do I get the prepared statement of the mysqli_stmt-object?

If there is an error while executing the mysql-statement I want to return the statement.

$id = "89c483c8";
$query = "SELECT * FROM database WHERE id = ?";
if (!($stmt = $database->prepare($query) { ... }
else {
    $stmt->bind_param("s", $id);
    if (!$stmt->execute())
         return $stmt->get_statement; //doesn't exist
}

"$stmt->get_statement" of course doesn't work. So how do I get the full query? In this example:

"SELECT * FROM database WHERE id = 89c483c8"

There's no such opportunity. Just use `error` property. Similar: https://stackoverflow.com/questions/2691707/is-there-any-way-to-print-the-actual-query-that-mysqli-execute-makes — u_mulder, Aug 16 '17 at 09:11

score 2 · Answer 1 · answered Aug 16 '17 at 09:34

This is the best way to catch sql errors :

try {
    $res = $mysqli_instance->query($query);
}catch (mysqli_sql_exception $e) {
    print "Error Code <br>".$e->getCode();
    print "Error Message <br>".$e->getMessage();
    print "Strack Trace <br>".nl2br($e->getTraceAsString());
}

Or the simplest way :

echo $stmt->error

http://php.net/manual/en/mysqli.error.php

MYSQL Error Get Prepared Statement

1 Answers1