Re: losing MySQL resource

I got as far as creating a class to be the wrapper ... instantiating an object of that class ... saving the reference in a $_SESSION variable ... but my object reference seems to be invalid upon the next request (in the same session) from the client browser. What have I missed? Thanks, Stan ""Andy Shellam (Mailing Lists)"" <andy-lists@networkmail.eu> wrote in message news:FD8200B0-E18A-4AFD-8FFC-F51080621BB4@networkmail.eu... > Hi, > > I got around this by creating a database wrapper class which gets > passed the credentials from the app's config file. An instance of the > class is created and saved in the session, and every query to the > database runs through the class's Query() wrapper method which checks > if the connection is alive and valid - if it isn't, it reconnects it > before running the query. > > Andy > > On 9 November2009, at 16:46, Stan wrote: > > > How do I make an Object persistant for the duration of a Session? > > Thanks, > > "Chris" <dmagick@gmail.com> wrote in message > > news:4AB6B16C. > > 8@gmail.com... > >> Niel Archer wrote: > >>>> I'm maintaining a session. I successfully connect to a database > > ($DBConnect > >>>> = mysql_connect()). I save the connection resource in a session > > variable > >>>> ($_SESSION['connection'] = $DBConnect) ... to use in subsequent > > queries. It > >>>> remains valid while the user is on the current page. > >>>> print_r($_SESSION['connection']) yields 'Resource id #3', > >>>> for > >>>> instance. > >>>> > >>>> User browses to a new page ... in the same session. > > $_SESSION['$DBConnect'] > >>>> no longer references a valid mysql resource. > >>>> print_r($_SESSION['connection']) yields '0'. > >>>> > >>>> Other "ordinary" values saved in $_SESSION variables remain valid. > >>>> > >>>> Is there something special about a mysql resource? > >>> > >>> Not about the resource itself, no. PHP closes connections to a Db > >>> when a > >>> script ends, unless the connection is persistent, so while the > >>> resource > >>> IS saved, the connection to which it refers no longer exists. > >> > >> No resources (whether they are persistent or not) can be stored in > >> the > >> session. > >> > >> http://www.php.net/manual/en/intro.session.php > >> > >> The big pink box has more info. > >> > >> -- > >> Postgresql & php tutorials > >> http://www.designmagick.com/ > >> > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > >