Re: losing MySQL resource

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

 



How do I make an Object persistant for the duration of a Session?
Thanks,
"Chris" <dmagick@xxxxxxxxx> wrote in message news:4AB6B16C.8@xxxxxxxxxxxx
> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux