I am new to MySQL and PHP and am attempting to make my own CMS to help make managing my websites easier. Can someone explain mysqli's close()
function?
The close() / mysqli_close() function closes a previously opened database connection.
To close the connection in mysql database we use php function conn->close() which disconnect from database. Syntax: conn->close();
Explicitly closing open connections and freeing result sets is optional. However, it's a good idea to close the connection as soon as the script finishes performing all of its database operations, if it still has a lot of processing to do after getting the results.
PHP PHP MySQLi Close connection Use Case: If our script has a fair amount of processing to perform after fetching the result and has retrieved the full result set, we definitely should close the connection.
Is it necessary?
No, PHP will end your connection after it finishes running.
What exactly does it do?
The reverse of mysqli_connect()
-- it closes the active DB connection.
I heard that after PHP runs its script that it closes the connection, is that true?
Yes, see the answer to "Is it necessary?"
Lastly, is there a security issue when not closing your connection to the database?
Nope, no security issue. The connection can't be hijacked by an outsider or anything like that.
However, since the number of total connections available is limited, freeing the resource the second you're done with it is considered polite to close it when you're done. This is likely why you've been told to close it when you're done.
You need to close the Mysql session when you manual set variables @@session or non-defined (set to @@session).
for example
$mysqli->query("SET @uuid=UUID()");
https://dev.mysql.com/doc/refman/5.1/en/set-statement.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With