Menu
Community /Pin to ProfileBookmark
@NogDogMay 14.2008 — #I would recommend passing parameters to your functions rather than using global variables (which result in tightly coupled code).
Also, depending on what you are doing, you may not want to do the mysql_close() within those functions, as it means that once you call one of those functions, the connection will be closed, so you'll have to do another connect before calling either of them again.
mysql connection close issue
Hello Mates,
I think I am not being able to close mysql connection properly from php. Here is what I am doing:
mysql_connect($connection);
function x()
{
global $connection;
mysql_select_db($db_name,$connection);
…code…code…code…
mysql_close($connection);
}
function y()
{
global $connection;
mysql_select_db($db_name,$connection);
…code…code…code…
mysql_close($connection);
}
Is my approach above ok? Or am I doing crap?
Any suggestion would be great help. Thank you.
Sign in
to post a comment1 Comments(s) ↴
0
@NogDogMay 14.2008 — #I would recommend passing parameters to your functions rather than using global variables (which result in tightly coupled code).[code=php]
function x($connection, $db_name)
{
mysql_select_db($db_name, $connection);
// ...etc....
}
[/code]Also, depending on what you are doing, you may not want to do the mysql_close() within those functions, as it means that once you call one of those functions, the connection will be closed, so you'll have to do another connect before calling either of them again.