[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... So now I'm going through and converting my MySQL code to Oracle. I've finished the connect functions, but getting hung up on how to do queries. For example the first query wants to SHOW TABL

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

2005-06-15 Thread Shane Presley
I managed to solve 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

[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, because

[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 --with-oci8=/path/

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... > > > 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

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

[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