Re: php/mysql web question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Mikey wrote:

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@xxxxxxxxxxxxx

What you should use is a persistent connection - mysql_pconnect() - IIRC

HTH,

Mikey

Ooops, forgot the second part of your question - if you want to save the data from a query then you will have to use session vars, although only do this with data that you know will not change during the lifetime of a user session.

Mikey

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux