Re: is there any reasone why the following doesn't work?
| From: | Fred Silsbee | Date: | Fri, 26 Dec 2008 02:45:13 +0000 |
| Subject: | Re: is there any reasone why the following doesn't work? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45833@lists.php.net to get a copy of this message | ||
--- On Fri, 12/26/08, Fred Silsbee <fredsilsbee@yahoo.com> wrote:
> From: Fred Silsbee <fredsilsbee@yahoo.com>
> Subject: Re: is there any reasone why the following doesn't work?
> To: php-db@lists.php.net
> Date: Friday, December 26, 2008, 2:18 AM
> --- On Thu, 12/25/08, Fred Silsbee
> <fredsilsbee@yahoo.com> wrote:
>
> > From: Fred Silsbee <fredsilsbee@yahoo.com>
> > Subject: is there any reasone why the following
> doesn't work?
> > To: php-db@lists.php.net
> > Date: Thursday, December 25, 2008, 11:57 PM
> > $connection=oci_connect('landon',
> > 'xxxxxxx',$db)
> > session_start();
> > $_SESSION['connection'] = $connection;
> > .
> > .
> > .
> >
> > $connection = $_SESSION['connection'] ;
> shows
> > nothing!
> >
> > My program allows many operations on a table
> re-entering at
> > the top
> > and deciding what option to do next.
> >
> > I don't want to keep logging into Oracle but use
> the
> > previous connection
> _____________________________________
> answer? when the php code exits, it must detach the
> connection and even zero the variable $connection in the
> _SESSION.
>
> Problem is that my complete program never exits!
>
> What constitutes an "exit"
>
> Running this over and over the $connection is not
> remembered!
>
> <?php
> session_start();
> $connection = $_SESSION['connection'] ;
> $conn = $_SESSION['conn'] ;
> print($conn);
> $db = "(DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT =
> 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SID = LMKIIIGDNSID)
> )
> )";
> if(!$connection)
> {
> echo "OOOPS! NO connection, better make one
> .................";
> if ($connection=oci_connect('landon',
> 'xxxxx',$db))
> {
> echo "Successfully connected to
> Oracle.\n";
> $_SESSION['connection'] =
> $connection;
> }
> else
> {
> $err = OCIError();
> echo "Oracle Connect Error " .
> $err['message'];
> }
> }
> else
> {
>
> print ("conn0 = ".$connection." ");
> }
>
> print ("conn0 = ".$connection." ");
> $conn = 5.6;
> $_SESSION['conn']= $conn; //this doesn't
> perish
> ?>
answer: http://us.php.net/manual/tr/oci8.connection.php
???