Copyright 1997-2012 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.38. $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
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
Add your own comment.