mysqli::$connect_error

mysqli_connect_error

Returns a string description of the last connect error

Description

Object oriented style

string$mysqli->connect_error;

Procedural style

string mysqli_connect_error ( void )

Returns the last error message string from the last call to mysqli_connect.

Return Values

A string that describes the error. NULL is returned if no error occurred.

Examples

Example #1 $mysqli->connect_error example

Object oriented style

<?php
$mysqli 
= @new mysqli('localhost''fake_user''my_password''my_db');

// Works as of PHP 5.2.9 and 5.3.0.
if ($mysqli->connect_error) {
    die(
'Connect Error: ' $mysqli->connect_error);
}
?>

Procedural style

<?php
$link 
= @mysqli_connect('localhost''fake_user''my_password''my_db');

if (!
$link) {
    die(
'Connect Error: ' mysqli_connect_error());
}
?>

The above examples will output:

Connect Error: Access denied for user 'fake_user'@'localhost' (using password: YES)

Notes

Warning

The mysqli->connect_error property only works properly as of PHP versions 5.2.9 and 5.3.0. Use the mysqli_connect_error function if compatibility with earlier PHP versions is required.

See Also

  • mysqli_connect
  • mysqli_connect_errno
  • mysqli_errno
  • mysqli_error
  • mysqli_sqlstate