(PHP 5, PHP 7, PHP 8)
mysqli::$connect_error -- mysqli_connect_error — Returns a description of the last connection error
Object-oriented style
Procedural style
Returns the error message from the last connection attempt.
This function has no parameters.
A string that describes the error. null is returned if no error occurred.
Example #1 $mysqli->connect_error example
Object-oriented style
<?php
/* @ is used to suppress default error messages */
$mysqli = @new mysqli('localhost', 'fake_user', 'my_password', 'my_db');
if ($mysqli->connect_error) {
/* Use your preferred error logging method here */
error_log('Connection error: ' . $mysqli->connect_error);
}
Procedural style
<?php
/* @ is used to suppress default error messages */
$link = @mysqli_connect('localhost', 'fake_user', 'my_password', 'my_db');
if (!$link) {
/* Use your preferred error logging method here */
error_log('Connection error: ' . mysqli_connect_error());
}
The above examples will output:
Connection error: Access denied for user 'fake_user'@'localhost' (using password: YES)