Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysqli_error(3) [php man page]

MYSQLI_ERROR(3) 							 1							   MYSQLI_ERROR(3)

mysqli::$error - Returns a string description of the last error

       Object oriented style

SYNOPSIS
string$mysqli->error () DESCRIPTION
Procedural style string mysqli_error (mysqli $link) Returns the last error message for the most recent MySQLi function call that can succeed or fail. PARAMETERS
o $ link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3) RETURN VALUES
A string that describes the error. An empty string if no error occurred. EXAMPLES
Example #1 $mysqli->error example Object oriented style <?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world"); /* check connection */ if ($mysqli->connect_errno) { printf("Connect failed: %s ", $mysqli->connect_error); exit(); } if (!$mysqli->query("SET a=1")) { printf("Errormessage: %s ", $mysqli->error); } /* 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 ", mysqli_connect_error()); exit(); } if (!mysqli_query($link, "SET a=1")) { printf("Errormessage: %s ", mysqli_error($link)); } /* close connection */ mysqli_close($link); ?> The above examples will output: Errormessage: Unknown system variable 'a' SEE ALSO
mysqli_connect_errno(3), mysqli_connect_error(3), mysqli_errno(3), mysqli_sqlstate(3). PHP Documentation Group MYSQLI_ERROR(3)

Check Out this Related Man Page

MYSQLI_GET_SERVER_VERSION(3)						 1					      MYSQLI_GET_SERVER_VERSION(3)

mysqli::$server_version - Returns the version of the MySQL server as an integer

       Object oriented style

SYNOPSIS
int$mysqli->server_version () DESCRIPTION
Procedural style int mysqli_get_server_version (mysqli $link) The mysqli_get_server_version(3) function returns the version of the server connected to (represented by the $link parameter) as an inte- ger. PARAMETERS
o $ link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3) RETURN VALUES
An integer representing the server version. The form of this version number is main_version * 10000 + minor_version * 100 + sub_version (i.e. version 4.1.0 is 40100). EXAMPLES
Example #1 $mysqli->server_version example Object oriented style <?php $mysqli = new mysqli("localhost", "my_user", "my_password"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s ", mysqli_connect_error()); exit(); } /* print server version */ printf("Server version: %d ", $mysqli->server_version); /* close connection */ $mysqli->close(); ?> Procedural style <?php $link = mysqli_connect("localhost", "my_user", "my_password"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s ", mysqli_connect_error()); exit(); } /* print server version */ printf("Server version: %d ", mysqli_get_server_version($link)); /* close connection */ mysqli_close($link); ?> The above examples will output: Server version: 40102 SEE ALSO
mysqli_get_client_info(3), mysqli_get_client_version(3), mysqli_get_server_info(3). PHP Documentation Group MYSQLI_GET_SERVER_VERSION(3)
Man Page