mysqli::$connect_error

mysqli_connect_error

(PHP 5)

mysqli::$connect_error -- mysqli_connect_error — Returns a string description of the last connect error

설명

객체 기반 형식

string $mysqli->connect_error;

절차식 형식

string mysqli_connect_error ( void )

Returns the last error message string from the last call to mysqli_connect().

반환값

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

예제

Example #1 $mysqli->connect_error example

객체 기반 형식


<?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);
}
?>

절차식 형식


<?php
$link = @mysqli_connect('localhost', 'fake_user', 'my_password', 'my_db');

if (!$link) {
    die('Connect Error: ' . mysqli_connect_error());
}
?>

위 예제들의 출력:

Connect Error: Access denied for user 'fake_user'@'localhost' (using password: YES)

주의

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.

참고

mysqli_connect() - 별칭: mysqli::__construct
mysqli_connect_errno() - Returns the error code from last connect call
mysqli_errno() - Returns the error code for the most recent function call
mysqli_error() - Returns a string description of the last error
mysqli_sqlstate() - Returns the SQLSTATE error from previous MySQL operation