Home > Archive > PHP DB > March 2006 > Re: [PHP-DB] Proper procedure to close mysql queries!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] Proper procedure to close mysql queries!
|
|
|
| JeRRy wrote:
> Hi,
>
> Just need some mailing list input here, what is the proper way to close a mysql query using PHP.
>
> - What is the proper way to close a php query to mysql if one query is in the file?
> - What is the proper way to close a php query to mysql if 2 or more queries is in the file and where do you close it off?
>
> So if I use <? code here ?> or <?php code here ?> is that a safe way to do it and does this close the mysql session off or does it timeout after a set period of time?
>
> Or is a better way mysql_close()? Or do both work the same?
mysql_close closes a database connection.
What do you mean by a php query to mysql ?
If you want to free memory from a mysql query result, mysql_free_result
does that.
--
Postgresql & php tutorials
http://www.designmagick.com/
| |
|
| Hi Chris,
Thanks for that, always wondered. So what does just using '?>' do than?
Must close eventually but I am guessing by using that as a close the connection times out after a set period of time and the 'pid' is killed, correct?
J
---chris said---
mysql_close closes a database connection.
What do you mean by a php query to mysql ?
If you want to free memory from a mysql query result, mysql_free_result
does that.
--
Postgresql & php tutorials
http://www.designmagick.com/
| |
|
| JeRRy wrote:
> Hi Chris,
>
> Thanks for that, always wondered. So what does just using '?>' do than?
>
> Must close eventually but I am guessing by using that as a close the
> connection times out after a set period of time and the 'pid' is killed,
> correct?
If you're using mysql_connect php will close the connection when the
script itself stops (through an exit(), die() or it just completes
normally) as part of it's shutdown procedures (memory cleanups, garbage
collection etc etc).
If you're using persistent connections (mysql_pconnect) it leaves the
connection open for the next process to use, so it lowers the connection
overhead. However it can have other side-effects (see
http://www.php.net/mysql_pconnect for further info).
--
Postgresql & php tutorials
http://www.designmagick.com/
| |
|
| Thanks :)
Chris <dmagick@gmail.com> wrote: JeRRy wrote:
> Hi Chris,
>
> Thanks for that, always wondered. So what does just using '?>' do than?
>
> Must close eventually but I am guessing by using that as a close the
> connection times out after a set period of time and the 'pid' is killed,
> correct?
If you're using mysql_connect php will close the connection when the
script itself stops (through an exit(), die() or it just completes
normally) as part of it's shutdown procedures (memory cleanups, garbage
collection etc etc).
If you're using persistent connections (mysql_pconnect) it leaves the
connection open for the next process to use, so it lowers the connection
overhead. However it can have other side-effects (see
http://www.php.net/mysql_pconnect for further info).
--
Postgresql & php tutorials
http://www.designmagick.com/
|
|
|
|
|