How does PHP interacts with MySQL

Question

Can someone explain me how does PHP interacts with MySQL. I want to know when I make queries using mysql_query when the connection is closed. Or should I use mysql_close()...

I thought that the connection is open while the page is being interpret and closes when it's done with interpreting.

... closing it manually seems to be a good practice to follow: [enter link description here][1] [1]: http://stackoverflow.com/questions/880885/close-mysql-connection-important — vector, Feb 28 '12 at 19:10

score 3 · Accepted Answer · answered Feb 28 '12 at 18:39

3

The connection remains open from the mysql_connect call until either:

mysql_close is called
the reference to the connection ($db = mysql_connect...) is unset (with unset, or falls out of scope)
the script finishes executing

answered Feb 28 '12 at 18:39

Joe

15,669
4
48
83

score 2 · Answer 2 · answered Feb 28 '12 at 18:41

2

http://php.net/manual/en/function.mysql-close.php

You don't need to close explicitly.

answered Feb 28 '12 at 18:41

rob

266
3
3

score 0 · Answer 3 · edited Feb 29 '12 at 18:43

0

Use mysql_close() only if you are concerned about size of the transfer. If it is not huge, you are OK without it.

edited Feb 29 '12 at 18:43

Mark Ursino

31,209
11
51
83

answered Feb 28 '12 at 18:39

Whitewall

597
1
7
18

How does PHP interacts with MySQL

3 Answers3