7.3.8.9 mysqli::$connect_error, mysqli_connect_error

Copyright 1997-2022 the PHP Documentation Group.

• mysqli::$connect_error

  mysqli_connect_error

  Returns a description of the last connection error

Description

Object-oriented style

string|null mysqli->connect_error ;

Procedural style

string|null mysqli_connect_error();

Returns the error message from the last connection attempt.

Parameters

This function has no parameters.

Return Values

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

Examples

Example 7.43 $mysqli->connect_error example

Object-oriented style

<?php
mysqli_report(MYSQLI_REPORT_OFF);
/* @ is used to suppress warnings */
$mysqli = @new mysqli('localhost', 'fake_user', 'wrong_password', 'does_not_exist');
if ($mysqli->connect_error) {
    /* Use your preferred error logging method here */
    error_log('Connection error: ' . $mysqli->connect_error);
}

Procedural style

<?php
mysqli_report(MYSQLI_REPORT_OFF);
/* @ is used to suppress warnings */
$link = @mysqli_connect('localhost', 'fake_user', 'wrong_password', 'does_not_exist');
if (!$link) {
    /* Use your preferred error logging method here */
    error_log('Connection error: ' . mysqli_connect_error());
}

See Also

mysqli_connect

mysqli_connect_errno

mysqli_errno

mysqli_error

mysqli_sqlstate