PHP 7.0.33 Released

mysqli::$connect_error

mysqli_connect_error

(PHP 5, PHP 7)

mysqli::$connect_error -- mysqli_connect_errorReturns a string description of the last connect error

Description

Object oriented style

Procedural style

string mysqli_connect_error ( void )

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

add a note add a note

User Contributed Notes 1 note

up
0
gejez at polyswarms dot com
2 months ago
<?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));
        }

    }

?>
To Top