Returns a list of errors from the last statement executed (original) (raw)

mysqli_stmt::$error_list

mysqli_stmt_error_list

(PHP 5 >= 5.4.0, PHP 7)

mysqli_stmt::$error_list -- mysqli_stmt_error_list — Returns a list of errors from the last statement executed

Description

Object oriented style

arraymysqli_stmt->error_list;

Procedural style

mysqli_stmt_error_list ( mysqli_stmt $stmt ) : array

Parameters

stmt

Procedural style only: A statement identifier returned by mysqli_stmt_init().

Return Values

A list of errors, each as an associative array containing the errno, error, and sqlstate.

Examples

Example #1 Object oriented style

`<?php
/* Open a connection /
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}$mysqli->query("CREATE TABLE myCountry LIKE Country"); mysqli−>query("INSERTINTOmyCountrySELECT∗FROMCountry");mysqli->query("INSERT INTO myCountry SELECT * FROM Country");mysqli−>query("INSERTINTOmyCountrySELECT∗FROMCountry");query = "SELECT Name, Code FROM myCountry ORDER BY Name";
if ($stmt = mysqli−>prepare(mysqli->prepare(mysqli−>prepare(query)) {/ drop table /
$mysqli->query("DROP TABLE myCountry");/ execute query */
$stmt->execute();

echo

"Error:\n";
print_r($stmt->error_list);/* close statement /
$stmt->close();
}/ close connection */
$mysqli->close();
?> `

Example #2 Procedural style

`<?php
/* Open a connection /
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/ check connection /
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}mysqli_query($link, "CREATE TABLE myCountry LIKE Country");
mysqli_query($link, "INSERT INTO myCountry SELECT * FROM Country");$query = "SELECT Name, Code FROM myCountry ORDER BY Name";
if ($stmt = mysqli_prepare($link, $query)) {/ drop table /
mysqli_query($link, "DROP TABLE myCountry");/ execute query */
mysqli_stmt_execute($stmt);

echo

"Error:\n";
print_r(mysql_stmt_error_list($stmt));/* close statement /
mysqli_stmt_close($stmt);
}/ close connection */
mysqli_close($link);
?> `

The above examples will output:

Array ( [0] => Array ( [errno] => 1146 [sqlstate] => 42S02 [error] => Table 'world.myCountry' doesn't exist )

)