- PHP Basics
- Learn PHP
- PHP Comments
- PHP Data Types
- PHP Variables
- PHP Operators
- PHP echo
- PHP print
- PHP echo vs. print
- PHP if else
- PHP switch
- PHP for Loop
- PHP while Loop
- PHP do...while Loop
- PHP foreach Loop
- PHP break and continue
- PHP Arrays
- PHP print_r()
- PHP unset()
- PHP Strings
- PHP Functions
- PHP File Handling
- PHP File Handling
- PHP Open File
- PHP Create a File
- PHP Write to File
- PHP Read File
- PHP feof()
- PHP fgetc()
- PHP fgets()
- PHP Close File
- PHP Delete File
- PHP Append to File
- PHP Copy File
- PHP file_get_contents()
- PHP file_put_contents()
- PHP file_exists()
- PHP filesize()
- PHP Rename File
- PHP fseek()
- PHP ftell()
- PHP rewind()
- PHP disk_free_space()
- PHP disk_total_space()
- PHP Create Directory
- PHP Remove Directory
- PHP Get Files/Directories
- PHP Get filename
- PHP Get Path
- PHP filemtime()
- PHP file()
- PHP include()
- PHP require()
- PHP include() vs. require()
- PHP and MySQLi
- PHP and MySQLi
- PHP MySQLi Setup
- PHP MySQLi Create DB
- PHP MySQLi Create Table
- PHP MySQLi Connect to DB
- PHP MySQLi Insert Record
- PHP MySQLi Update Record
- PHP MySQLi Fetch Record
- PHP MySQLi Delete Record
- PHP MySQLi SignUp Page
- PHP MySQLi LogIn Page
- PHP MySQLi Store User Data
- PHP MySQLi Close Connection
- PHP Misc Topics
- PHP Object Oriented
- PHP new Keyword
- PHP Cookies
- PHP Sessions
- PHP Date and Time
- PHP GET vs. POST
- PHP File Upload
- PHP Image Processing
PHP close() and mysqli_close() | Close Database Connection
This article is created to cover the two functions of PHP, that are:
- close()
- mysqli_close()
Both the functions are used to close a previously opened connection to the database. The only difference is, the close() works with PHP MySQLi object-oriented script, whereas the mysqli_close() works with PHP MySQLi procedural script.
PHP close()
The PHP close() function is used to close a previously opened database connection in PHP MySQLi object-oriented style. For example:
<?php $server = "localhost"; $user = "root"; $pass = ""; $db = "fresherearth"; $conn = new mysqli($server, $user, $pass, $db); if($conn -> connect_errno) { echo "Connection to the database failed!<BR>"; echo "Reason: ", $conn -> connect_error; exit(); } else { echo "Connection to the database, established."; // block of code, to process further... } $conn -> close(); ?>
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 connect_errno is used to get/return the error code (if any) from last connect call, in object-oriented style.
Note: The connect_error is used to get the error description (if any) from last connection, in object-oriented style.
Note: The exit() is used to terminate the execution of the current PHP script.
PHP close() Syntax
The syntax of close() function in PHP, is:
connectionVariable -> close();
PHP mysqli_close()
The PHP mysqli_close() function is used to close a previously opened database connection in PHP MySQLi procedural style. For example:
<?php
$server = "localhost";
$user = "root";
$pass = "";
$db = "fresherearth";
$conn = mysqli_connect($server, $user, $pass, $db);
if(mysqli_connect_errno())
{
echo "Connection to the database failed!<BR>";
echo "Reason: ", mysqli_connect_error();
exit();
}
else
{
echo "Connection to the database, established.";
// block of code, to process further...
}
mysqli_close($conn);
?>
Note: The mysqli_connect() is used to open a connection to the MySQL database server, in procedural style.
Note: The mysqli_connect_errno() is used to get/return the error code (if any) from last connect call, in procedural style.
Note: The mysqli_connect_error() is used to return the error description (if any) from the last connection, in procedural style.
PHP mysqli_close() Syntax
The syntax of mysqli_close() function in PHP, is:
mysqli_close(connectionVariable);
« Previous Tutorial Next Tutorial »