mysqli_stmt_error_list(3) [php man page]
MYSQLI_STMT_ERROR_LIST(3) 1 MYSQLI_STMT_ERROR_LIST(3) mysqli_stmt::$error_list - Returns a list of errors from the last statement executed Object oriented style SYNOPSIS
array$mysqli_stmt->error_list () DESCRIPTION
Procedural style array mysqli_stmt_error_list (mysqli_stmt $stmt) Returns an array of errors for the most recently invoked statement function that can succeed or fail. PARAMETERS
o $ stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3). 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 ", mysqli_connect_error()); exit(); } $mysqli->query("CREATE TABLE myCountry LIKE Country"); $mysqli->query("INSERT INTO myCountry SELECT * FROM Country"); $query = "SELECT Name, Code FROM myCountry ORDER BY Name"; if ($stmt = $mysqli->prepare($query)) { /* drop table */ $mysqli->query("DROP TABLE myCountry"); /* execute query */ $stmt->execute(); echo "Error: "; 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 ", 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: "; 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 ) ) SEE ALSO
mysqli_stmt_error(3), mysqli_stmt_errno(3), mysqli_stmt_sqlstate(3). PHP Documentation Group MYSQLI_STMT_ERROR_LIST(3)
Check Out this Related Man Page
MYSQLI_STMT_DATA_SEEK(3) 1 MYSQLI_STMT_DATA_SEEK(3) mysqli_stmt::data_seek - Seeks to an arbitrary row in statement result set Object oriented style SYNOPSIS
void mysqli_stmt::data_seek (int $offset) DESCRIPTION
Procedural style void mysqli_stmt_data_seek (mysqli_stmt $stmt, int $offset) Seeks to an arbitrary result pointer in the statement result set. mysqli_stmt_store_result(3) must be called prior to mysqli_stmt_data_seek(3). PARAMETERS
o $ stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3). o $offset - Must be between zero and the total number of rows minus one (0.. mysqli_stmt_num_rows(3) - 1). RETURN VALUES
No value is returned. 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 ", mysqli_connect_error()); exit(); } $query = "SELECT Name, CountryCode FROM City ORDER BY Name"; if ($stmt = $mysqli->prepare($query)) { /* execute query */ $stmt->execute(); /* bind result variables */ $stmt->bind_result($name, $code); /* store result */ $stmt->store_result(); /* seek to row no. 400 */ $stmt->data_seek(399); /* fetch values */ $stmt->fetch(); printf ("City: %s Countrycode: %s ", $name, $code); /* 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 ", mysqli_connect_error()); exit(); } $query = "SELECT Name, CountryCode FROM City ORDER BY Name"; if ($stmt = mysqli_prepare($link, $query)) { /* execute query */ mysqli_stmt_execute($stmt); /* bind result variables */ mysqli_stmt_bind_result($stmt, $name, $code); /* store result */ mysqli_stmt_store_result($stmt); /* seek to row no. 400 */ mysqli_stmt_data_seek($stmt, 399); /* fetch values */ mysqli_stmt_fetch($stmt); printf ("City: %s Countrycode: %s ", $name, $code); /* close statement */ mysqli_stmt_close($stmt); } /* close connection */ mysqli_close($link); ?> The above examples will output: City: Benin City Countrycode: NGA SEE ALSO
mysqli_prepare(3). PHP Documentation Group MYSQLI_STMT_DATA_SEEK(3)