[PHP] Oracle Interface

2005-06-10 Thread Shane Presley
Where can I find some info on integrating Oracle and PHP? I had some PHP front ends to a MySQL database, worked great. Our DBAs want to change the back end from MySQL to Oracle 10g. How hard would it be to convert my PHP scripts, and where would I go to read up on Oracle -- PHP? Thanks Shane

Re: [PHP] Oracle Interface

2005-06-13 Thread Shane Presley
On 6/10/05, Richard Lynch [EMAIL PROTECTED] wrote: On Fri, June 10, 2005 8:48 am, Shane Presley said: Where can I find some info on integrating Oracle and PHP? http://php.net/oracle pretty much covers it. Thanks! You're right, that looks pretty straight forward. Although I do have two

Re: [PHP] Oracle Interface

2005-06-13 Thread Shane Presley
On 6/13/05, Jay Blanchard [EMAIL PROTECTED] wrote: To find out how your PHP was compiled create a test page with this only... ?php phpinfo(); ? And then load the page from your web server. It will return a wealth of information to you. As far as Oracle compatability it would be hard

[PHP] Compiling problem (apxs)

2005-06-15 Thread Shane Presley
Hello, I have a RedHat system running Apache and PHP Version 4.3.2. These were pre-installed Red Hat packages. Things worked nicely. But I needed to recompile PHP, because I need Oracle support, and this package wasn't compiled with --with-oracle=/path/to/oracle/home/dir

[PHP] Apache fails to start (oracle path problem?)

2005-06-15 Thread Shane Presley
Hello, I'm having trouble compiling and running PHP with oracle support. I was able to compile with the appropriate configure script, but only after I set my Oracle environment variables in my shell. That was no problem. The problem is, when Apache goes to load the php module, it fails,

Re: [PHP] Apache fails to start (oracle path problem?)

2005-06-15 Thread Shane Presley
it by setting the environment variables in the httpd startup script. Not much help, I know, but a suggestion. ;) good luck kgt Shane Presley wrote: Hello, I'm having trouble compiling and running PHP with oracle support. I was able to compile with the appropriate configure

[PHP] Showing tables (converting from MySQL to Oracle)

2005-06-23 Thread Shane Presley
Hello, I've recompiled PHP to use Oracle, and been able to run a quick test script that looks like... ?php if ($c=OCILogon(user, pw, server)) { echo Successfully connected to Oracle.\n; OCILogoff($c); } else { $err = OCIError(); echo Oracle Connect Error . $err[text]; } ? So now I'm