MySQL and PHP

3.8.9 mysqli::$connect_error, mysqli_connect_error

Copyright 1997-2021 the PHP Documentation Group.

Description

Object oriented style

string mysqli->connect_error ;

Procedural style

string mysqli_connect_error();

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 3.36 $mysqli->connect_error example

Object oriented style

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

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)

   

See Also

mysqli_connect
mysqli_connect_errno
mysqli_errno
mysqli_error
mysqli_sqlstate