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, 2379🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Revise and Re-Run the Last SQL Command in Oracle? If executed a long SQL statement, found a m...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...