Re: [PHP-DB] what the php guys need to do
[email protected] (Christopher Jones)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
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