mysqli::$connect_error

mysqli_connect_error

Returns a description of the last connection error

Description

Object-oriented style

stringnull$mysqli->connect_error;

Procedural style

stringnull 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 #1 $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