- PHP Basics
- PHP Home
- PHP Environment Setup
- PHP Getting Started
- PHP Basic Syntax
- PHP echo
- PHP print
- PHP echo Vs print
- PHP Comments
- PHP Data Types
- PHP Variables
- PHP Variable Scope
- PHP gettype()
- PHP Constants
- PHP Operators
- PHP Program Control
- PHP Decision Making
- PHP if-elseif-else
- PHP switch
- PHP Loops
- PHP for Loop
- PHP while Loop
- PHP do-while Loop
- PHP foreach Loop
- PHP break & continue
- PHP Popular Topics
- PHP Arrays
- PHP print_r()
- PHP Strings
- PHP Functions
- PHP References
- PHP Object Oriented
- PHP Object Oriented
- PHP Classes & Objects
- PHP Member Variable
- PHP Member Function
- PHP Encapsulation
- PHP Data Abstraction
- PHP Inheritance
- PHP Constructor Destructor
- PHP Polymorphism
- PHP Web Developments
- PHP Web Developments
- PHP GET & POST
- PHP Read Requested Data
- PHP File Handling (I/O)
- PHP File Handling (I/O)
- PHP fopen() | Open File
- PHP Create a File
- PHP fwrite() | Write to File
- PHP fread() | Read File
- PHP feof()
- PHP fgetc()
- PHP fgets()
- PHP fclose() | Close File
- PHP unlink() | Delete File
- PHP Append to File
- PHP copy() | Copy File
- PHP file_get_contents()
- PHP file_put_contents()
- PHP file_exists()
- PHP filesize()
- PHP rename() | Rename File
- PHP fseek()
- PHP ftell()
- PHP rewind()
- PHP disk_free_space()
- PHP disk_total_space()
- PHP mkdir() | Create Directory
- PHP rmdir() | Remove Directory
- PHP glob() | Get Files/Directories
- PHP basename() | Get filename
- PHP dirname() | Get Path
- PHP filemtime()
- PHP file()
- PHP Advanced
- PHP Cookies
- PHP Sessions
- PHP Send Emails
- PHP Serialization
- PHP Namespaces
- PHP File Upload
- PHP Date and Time
- PHP Image Processing
- PHP Regular Expression
- PHP Predefined Variables
- PHP Error Handling
- PHP Debugging
- PHP and MySQLi Tutorial
- PHP and MySQLi Home
- PHP MySQLi Setup
- PHP MySQLi Create DB
- PHP MySQLi Create Table
- PHP MySQLi Connect to DB
- PHP MySQLi Insert Record
- PHP MySQLi Fetch Record
- PHP MySQLi Update Record
- PHP MySQLi Delete Record
- PHP MySQLi SignUp Page
- PHP MySQLi LogIn Page
- PHP MySQLi Store User Data
- PHP MySQLi Close Connection
- PHP connect_errno
- PHP connect_error
- PHP query()
- PHP fetch_row()
- PHP fetch_assoc()
- PHP fetch_array()
- PHP free_result()
- PHP error
- PHP prepare()
- PHP bind_param()
- PHP execute()
- PHP fetch()
- PHP store_result()
- PHP num_rows
- PHP bind_result()
- PHP get_result()
- PHP mysqli_result Class
- PHP Error Constants
- PHP mysqli_driver()
- PHP Misc
- PHP error_reporting()
- PHP Escape Special Characters
- PHP htmlspecialchars()
- PHP new
- PHP header()
- PHP getallheaders()
- PHP empty()
- PHP isset()
- PHP unset()
- PHP exit()
- PHP exit Vs break
- PHP include()
- PHP require()
- PHP include() Vs require()
- PHP AJAX & XML
- PHP AJAX
- PHP XML
- PHP File Handling Functions
- PHP abs()
- PHP Test
- PHP Online Test
- Give Online Test
- All Test List
PHP connect_errno and mysqli_connect_errno()
This article is created to cover the two topics of PHP, that are:
- connect_errno
- mysqli_connect_errno()
Both returns the error code (if any) from last connect call. The only difference is, the connect_errno uses with PHP MySQLi object-oriented script, whereas the mysqli_connect_errno() uses with PHP MySQLi procedural script.
PHP connect_errno
The PHP connect_errno is used when we need to get the error code (if any) from the last connect call. Most of the time, the connect_errno is used to check whether the connection established successfully or some error occurred, before process further. For example:
<?php $servername = "localhost"; $username = "root"; $password = ""; $databasename = "xyz"; $conn = new mysqli($servername, $username, $password, $databasename); if($conn -> connect_errno) { echo "Failed to establish the connection to the database."; exit(); } else { echo "Connection established successfully!"; // block of code, to process further } $conn -> close(); ?>
Since the database provided in above example named xyz is not available in my MySQL database server. Therefore, the output produced by above example is:
I think, you are getting confuse with above output. That is, you expect to see the following output:
Failed to establish the connection to the database.
But, you are seeing some different output, saying that the database named xyz is not found. This message raised by default. To hide it, we need to turn off the report mode using MYSQLI_REPORT_OFF, before executing or opening a database connection. That is, put the following statements:
$driver = new mysqli_driver(); $driver -> report_mode = MYSQLI_REPORT_OFF;
at start of the above example. Then the output changed to:
Now to suppress the Warning message, use/put ©right; before new mysqli(. Here is the modified version of above example:
<?php $driver = new mysqli_driver(); $driver -> report_mode = MYSQLI_REPORT_OFF; $servername = "localhost"; $username = "root"; $password = ""; $databasename = "xyz"; $conn = @new mysqli($servername, $username, $password, $databasename); if($conn -> connect_errno) { echo "Failed to establish the connection to the database."; echo "<BR>"; echo "Error Code: ", $conn -> connect_errno; exit(); } else { echo "Connection established successfully!"; // block of code, to process further } ?>
Now the output is:
Note - The mysqli() is used to open a connection to the MySQL database server, in object-oriented style.
Note - The new keyword is used to create a new object.
Note - The exit() function terminates the execution of the current PHP script.
Note - The mysqli_driver() is used to modify the error reporting mode, in object-oriented style.
Note - The close() is used to close an opened connection, in object-oriented style.
PHP mysqli_connect_errno()
The PHP mysqli_connect_errno() is used when we need to get the error code (if any) from the last connect call, in PHP MySQLi procedural style. Most of the time, the mysqli_connect_errno() is used to check whether the connection established successfully or some error occurred, before processing further. For example:
<?php mysqli_report(MYSQLI_REPORT_OFF); $servername = "localhost"; $username = "root"; $password = ""; $databasename = "xyz"; $conn = @mysqli_connect($servername, $username, $password, $databasename); if(mysqli_connect_errno()) { echo "Failed to establish the connection to the database."; echo "<BR>"; echo "Error Code: ", mysqli_connect_errno(); exit(); } else { echo "Connection established successfully!"; // block of code, to process further } mysqli_close($conn); ?>
Note - The mysqli_report() is used to modify the error reporting mode, in procedural style.
Note - The mysqli_connect() is used to open a connection to the MySQL database server, in procedural style.
Note - The mysqli_close() is used to close an opened connection to the MySQL database, in procedural style.
« Previous Tutorial Next Tutorial »
Like/Share Us on Facebook 😋