http://www.howtogeek.com/forum/ How-To Geek Forums Topic: need help from php geeks again (for mysql queries) en Fri, 09 Jan 2009 02:11:24 +0000 http://www.howtogeek.com/forum/topic/need-help-from-php-geeks-again-for-mysql-queries#post-44071 Sun, 24 Aug 2008 06:02:27 +0000 pipo 44071@http://www.howtogeek.com/forum/ <p>would it have a significant impact if i only use the mysql_free_result command and not the mysql_close command? </p> http://www.howtogeek.com/forum/topic/need-help-from-php-geeks-again-for-mysql-queries#post-43779 Thu, 21 Aug 2008 15:31:13 +0000 wallaceb 43779@http://www.howtogeek.com/forum/ <p>i am unsure of any tools off hand, except the ones your web server should already have. if you log into your server's administration panel, there should be a way to look at your bandwidth usage. </p> http://www.howtogeek.com/forum/topic/need-help-from-php-geeks-again-for-mysql-queries#post-43773 Thu, 21 Aug 2008 14:24:50 +0000 pipo 43773@http://www.howtogeek.com/forum/ <p>thanks mr geek and wallaceb (again) for your thoughts. how about a tool or a way to check if what i'm doing is doing anything for the bandwidth of the site, do you guys have any idea how i can do that? </p> http://www.howtogeek.com/forum/topic/need-help-from-php-geeks-again-for-mysql-queries#post-43758 Thu, 21 Aug 2008 12:11:34 +0000 wallaceb 43758@http://www.howtogeek.com/forum/ <p>also, to save in constant coding, i like to have either a class or a include file with all the data base log in, and just either link to the class, or include the file, which saves time on all the remaining pages i code. </p> http://www.howtogeek.com/forum/topic/need-help-from-php-geeks-again-for-mysql-queries#post-43749 Thu, 21 Aug 2008 08:24:48 +0000 The Geek 43749@http://www.howtogeek.com/forum/ <p>you should put the mysql_close commands as close as possible to after you pull the data... so something like:</p> <p>mysql connect<br /> mysql query<br /> mysql free result (look this one up)<br /> mysql close</p> <p>You would want this around every query. The idea is to connect and disconnect from the database as quickly as possible, because database connections are very expensive in processing terms.</p> <p>You should just look into one of the many database libraries out there that handle all of this for you. </p> http://www.howtogeek.com/forum/topic/need-help-from-php-geeks-again-for-mysql-queries#post-43748 Thu, 21 Aug 2008 07:41:39 +0000 pipo 43748@http://www.howtogeek.com/forum/ <p>hi guys,</p> <p>hope someone could point me to the right direction here. i've been doing this project for one of my dad's clients, using php. the web admin said that the queries i placed in the page (i crammed everything into 1 page) said the queries in the page have been clogging up the site because i haven't been closing my sql queries/connections (i just took a crash course in php with a book i bought, so i'm not familiar with good coding practices in PHP).</p> <p>so my questions are:<br /> 1. do i just place my mysql_close commands at the end of my php scripts or do i have to put it after every query?</p> <p>2. is there a way (tool) that i can check/use to see how much clogged the site is and if closing the database connections i'm about to put are working? </p>