Re: [PHP-DB] what the php guys need to do

sorry I forgot last time to cc PHP-DB



> Fred Silsbee wrote:
> > This worked on the command line:
> >> sqlplus hr/hr@LMKIIIGD
>
> > so I tried: (it didn't work)
>
> > if ($conn=oci_connect('hr', 'hr','//localhost/LMKIIIGD'))
>
yes this suggestion is clear and I've tried dozens of combinations
>
> Since you have a different password and SID, your code
> would be:
>
>     $c = oci_connect("hr", "hr", "LMKIIIGD"); tried this too!

tried this too.
>
> This assume Apache (or the PHP command line) has the same
> environment
> as SQL*Plus - your post didn't mention whether it does
> or not.

How do I tell what the Apache environment is? I tried setting environment variables in hrrpd.conf
>
> Also, running
>
how do I run this?
>     <?php
>     phpinfo();
>     ?>

I did do http://localhost:8080/phpinfo.php


I already did this:
> will show you where your php.ini file is.  Edit php.ini and
> set
> display_errors=On for purposes of debugging (don't
> leave it on in
> production applications)


      


--- On Tue, 11/18/08, Christopher Jones <[email protected]> wrote:

> From: Christopher Jones <[email protected]>
> Subject: Re: [PHP-DB] what the php guys need to do
> To: [email protected], "PHP DB" <[email protected]>
> Date: Tuesday, November 18, 2008, 11:46 PM
> I'm CCing php-db again.
> 
> Fred Silsbee wrote:
> > This worked:
> >> sqlplus hr/hr@LMKIIIGD
> 
> > so I tried: (didn't work)
> 
> > if ($conn=oci_connect('hr', 'hr',
> '//localhost/LMKIIIGD'))
> 
> Excuse me repeating the example PHP code I gave earlier for
> this
> SQL*Plus case:
> 
>     Or if you connect like:
> 	sqlplus hr/hrpwd@LMKIIIGDNSID
>     then use
> 	$c = oci_connect("hr", "hrpwd",
> "LMKIIIGDNSID");
> 
> Since you have a different password and SID, your code
> would be:
> 
>     $c = oci_connect("hr", "hr",
> "LMKIIIGD");
> 
> This assume Apache (or the PHP command line) has the same
> environment
> as SQL*Plus - your post didn't mention whether it does
> or not.
> 
> Also, running
> 
>     <?php
>     phpinfo();
>     ?>
> 
> will show you where your php.ini file is.  Edit php.ini and
> set
> display_errors=On for purposes of debugging (don't
> leave it on in
> production applications)
> 
> Chris
> 
> -- Email: [email protected]  Tel: +1 650 506
> 8630
> Twitter:  http://twitter.com/ghrd    Free PHP Book:
> http://tinyurl.com/f8jad