Re: what the php guys need to do
| From: | Fred Silsbee | Date: | Wed, 19 Nov 2008 00:12:19 +0000 |
| Subject: | Re: what the php guys need to do | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45652@lists.php.net to get a copy of this message | ||
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 <christopher.jones@oracle.com> wrote:
> From: Christopher Jones <christopher.jones@oracle.com>
> Subject: Re: [PHP-DB] what the php guys need to do
> To: fredsilsbee@yahoo.com, "PHP DB" <php-db@lists.php.net>
> 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: christopher.jones@oracle.com Tel: +1 650 506
> 8630
> Twitter: http://twitter.com/ghrd Free PHP Book:
> http://tinyurl.com/f8jad