Re: php/mysql web question
| From: | Mikey | Date: | Tue, 06 Sep 2005 12:40:46 +0000 |
| Subject: | Re: php/mysql web question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-221896@lists.php.net to get a copy of this message | ||
bruce wrote:
hi... if an app has a webpage that has to interface/display data from a mysql db, does the app have to essentially do a new db_connection for each time that a user accesses the page during the session. as far as i can tell, it does. in other words, the page would need to look something like: <? start the page do the db_connect do the db_query process the information from the db/tbl close the db_connection ?> the only reason i ask is that it would be nice/good if there was some way of opening a connetion once for a given session (save bandwidth) as well as somehow saving data from the db/tbl (short of using session vars) thanks -bruce bedouglas@earthlink.net What you should use is a persistent connection - mysql_pconnect() - IIRCHTH, Mikey