Php/docs/mysqli.connect-error
mysqli::$connect_error
mysqli_connect_error
(PHP 5, PHP 7)
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
mysqli_connect_error ( ) : string
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() - Alias of mysqli::__construct
- mysqli_connect_errno() - Returns the error code from last connect call
- mysqli_errno() - Returns the error code for the most recent function call
- mysqli_error() - Returns a string description of the last error
- mysqli_sqlstate() - Returns the SQLSTATE error from previous MySQL operation
