Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.8Mb
PDF (A4) - 2.8Mb
EPUB - 457.0Kb
HTML Download (TGZ) - 396.3Kb
HTML Download (Zip) - 410.1Kb


MySQL PHP API  /  ...  /  mysqli::$connect_error, mysqli_connect_error

3.9.11 mysqli::$connect_error, mysqli_connect_error

Copyright 1997-2014 the PHP Documentation Group.

  • 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

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.40 $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
mysqli_connect_errno
mysqli_errno
mysqli_error
mysqli_sqlstate


User Comments
Sign Up Login You must be logged in to post a comment.