newbie question

kilroy

I\'m a newbie I have done Active Server Page stuff using VB Script and ADO ODBC type stuff.

My question is I am used to using a Connection and recordset object and when Im done with it I have to close & clean up.
//objRec.Close
//set objRec = nothing
//dbData.Close
//set dbData = nothing

Do I need to do the same sort of thing when using PHP with mysql?

If I have posted this in the wrong place, try to forgive me ... if you cannot forgive me, email me at slapKilroy@upsideTheHead.com

crusty_php

When the script ends so does the db connection and local variables.
If you feel the need you can use:
mysql_close(link);

kilroy

So it takes care of itself then. Thanks

Anon

i was gonna congratulate you on having such a cool domain ... upsideTheHead.com ... then i realized it's a dummy address. why?

Anon

It's good practice to close your DB connections manually.

adamd1

Actually it's a good idea - just good coding practice in general - to both "free up" the Query ram and close the specific db connection.

So if I start a new connection and query:

mysql_connect("hostname","username","password")
mysql_select_db("dbname",$db);
$member_result = mysql_query("SELECT first_name FROM site_members WHERE...",$db);

Then when you're done you'll wanna go:

mysql_free_result($member_result);
mysql_close($db);

The reason for this is: over time - particularly as your site gains in popularity - your server may not close of those threads. It's a small thing, eats up very little CPU. But like I say: just overall good practice. Your server will thank you later.

Ta da.