Collections:
Close MySQL Connection Objects in MySQL
How To Close MySQL Connection Objects in MySQL?
✍: FYIcenter.com
MySQL connection objects created with mysql_connect() calls should be closed as soon as you have finished all of your database access needs by calling mysql_close($con) function. This will reduce the consumption of connection resources on your MySQL server.
If you forget to call mysql_close(), PHP engine will automatically close your connection objects, when your PHP script reaches the end. The following PHP script shows a good example of mysql_close():
<?php
$con = mysql_connect('localhost:8888', 'dev', 'iyf');
if (!$con) {
print("There is a problem with MySQL connection.\n");
} else {
print("The MySQL connection object is ready.\n");
mysql_close($con);
}
?>
⇒ List All Existing Databases in MySQL
⇐ Retrieving MySQL Server information in MySQL
2017-11-11, 2338🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAG...