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@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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
