mysqli::$connect_error

mysqli_connect_error

(PHP 5, PHP 7)

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

说明

面向对象风格

string $mysqli->connect_error;

过程化风格

mysqli_connect_error ( void ) : string

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.

参见

User Contributed Notes

gejez at polyswarms dot com 05-Oct-2018 10:38
<?php

    class bDBresult {
        private $result;
       
        public function __construct($res) {
            $this->result = $res;
        }

        public function num_rows() {
            return $this->result->num_rows;
        }

        public function next_row() {
            return $this->result->fetch_assoc();
        }
       
    }

    class bDB {
        private static $conf;
        private $conn;

        public static function set_conf_file($dbconf_path) {
            self::$conf = parse_ini_file($dbconf_path); 
        }

        public function __construct() {
            $this->conn = new mysqli(
                self::$conf['db.host.address'],
                self::$conf['db.user.admin.name'],
                self::$conf['db.user.admin.password'],
                self::$conf['db.bibliotecando.name']
            );
        }

        public function send_query($coms) {
            return new bDBresult($this->conn->query($coms));
        }

    }

?>