PHP and MySQLi close()

Question

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?

Is it necessary?
What exactly does it do?
I heard that after PHP runs its script that it closes the connection, is that true?
Lastly, is there a security issue when not closing your connection to the database?

score 57 · Accepted Answer · edited May 21 '13 at 16:49

57

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.

edited May 21 '13 at 16:49

George Cummins

28,485
8
71
90

answered May 20 '10 at 17:49

Amy B

17,874
12
64
83

So what's the usual kind of handling we do when close() returns false? – Pacerier Oct 10 '12 at 14:18
@Pancerier - You don't need to do anything. The connection will be closed by force when PHP execution ends. – Amy B Oct 10 '12 at 15:54

score 0 · Answer 2 · answered May 28 '15 at 10:42

0

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

answered May 28 '15 at 10:42

Nijboer IT

1,178
1
13
18

PHP and MySQLi close()

2 Answers2

Linked