Returns the error code for the most recent function call (original) (raw)

mysqli::$errno

mysqli_errno

(PHP 5, PHP 7)

mysqli::$errno -- mysqli_errno — Returns the error code for the most recent function call

Description

Object oriented style

intmysqli->errno;

Procedural style

mysqli_errno ( mysqli $link ) : int

Client error message numbers are listed in the MySQL errmsg.h header file, server error message numbers are listed in mysqld_error.h. In the MySQL source distribution you can find a complete list of error messages and error numbers in the file Docs/mysqld_error.txt.

Return Values

An error code value for the last call, if it failed. zero means no error occurred.

Examples

Example #1 $mysqli->errno example

Object oriented style

`<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}

if (!

$mysqli->query("SET a=1")) {
printf("Errorcode: %d\n", $mysqli->errno);
}/* close connection */
$mysqli->close();
?> `

Procedural style

`<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}