[PHP-DB] Oracle and PHP
Hello, I was wondering if there are any PHP people out there that are really into using Oracle databases? I've always used mysql but now I find myself in a situation that requires the use of an Oracle database. I've printed out the information posted by Thies C. Arntzen titled Making Efficient use of Oracle8i thru Apache and PHP 4 but I was wondering if I may see some other code examples. Very basic examples dealing with connections, queries and the such. Also, is there an application for Oracle databases that is similar to PHPMyAdmin for mysql databases? Thanks, Roger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Oracle via PHP on OS X
I need to make connections of this sort but cannot find the needed extensions. Could someone point me in the right direction? I'm using 10.1.5. James -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Oracle via php under windows 2k
ok, that was already done, ive an Oracle server with database on a computer and on another i ve apache + php +oci8 and the oracle client installed, what to do now for this work ? Philippe Saladin [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle via php under windows 2k
See http://www.thickbook.com/extra/php_oracle.phtml for a simple tutorial. Note that in my case, I've trouble using OCILogon with its third argument, for example '@mydb'. I have to use the complete syntax you found in the oracle file tnsnames.ora, something like mydb.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = IP address) (Port = port 1) ) (ADDRESS = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = IP address) (Port = port 1) ) ) (CONNECT_DATA = (SID = oracle ID) ) ) Hope this helps. et bon courage ! Philippe Titanesk [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] ok, that was already done, ive an Oracle server with database on a computer and on another i ve apache + php +oci8 and the oracle client installed, what to do now for this work ? Philippe Saladin [EMAIL PROTECTED] a écrit dans le message de news: [EMAIL PROTECTED] If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle via php under windows 2k
Hello These are pretty basic questions, but I would appreciate help: I need to access Oracle (already running on a separate server) via PHP4/Apache from a windows system. 1) Can this be done? (It will be possible with php scripts but i've oci8 errors) 2) Where do I find instructions? 3) Where do I get php_oci8 ?? i need to rebuild php ? I would find php4 with oci8 extension ready yet ! :) Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle via php under windows 2k
I don't use oracle with my windows php but in my extensions directory there is a php_oci8.dll. Do you have it? did you uncomment the line in your php.ini? If you installed your php from the installer, probably you don't have this file. download the zipped file from www.php.net and extract the extensions in your extensions_dir. If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Hope I don't sad a lot of things you've done before. Bruno. - Original Message - From: titanesk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 14, 2001 6:07 PM Subject: [PHP-DB] Oracle via php under windows 2k Hello These are pretty basic questions, but I would appreciate help: I need to access Oracle (already running on a separate server) via PHP4/Apache from a windows system. 1) Can this be done? (It will be possible with php scripts but i've oci8 errors) 2) Where do I find instructions? 3) Where do I get php_oci8 ?? i need to rebuild php ? I would find php4 with oci8 extension ready yet ! :) Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle via php under windows 2k
If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Oracle and PHP
TathitSA, You'll need to have the Oracle networking software (Net8) installed on your Web server. Then, compile PHP with the Oracle directive turned on. These are just general concepts, but if this is incomprehensible, then please ask more questions before proceeding. For more details, see the installation manual , and if you don't understand what they say, ask a more specific question. I'll be happy to help translate whatever I can. Anthony -Original Message- From: TathitSA [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 1:47 AM To: PHP General; PHP DB Subject: [PHP-DB] Oracle and PHP Hi, I'm a newbie in PHP, what should I do to connect to Oracle Database. Do I have to install a library to do that? Please anyone, help. Thanks, TathitSA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] oracle and php
At 09:05 AM 4/6/01 -0500, Brian.J.Mauter wrote: If you're using Linux or Unix, then you're going to have to compile Oracle into PHP. right... This is quite troublesome. not really. For this to work, you first must install Oracle8i (maybe just the client will work?). Yes, you may install only the client Net8 client on the webserver. ..but you also must configure it so that it can reach your Oracle database (presumably on a different server). Here, I've got Apache/PHP and the Oracle Net8 client installed on a Linux box. The database is installed on a huge Sun box. This also requires a specific version of the Java Runtime Environment (available at www.blackdown.com for Linux). Could you explain this? I don't recall having to install any specific Java Runtime Environment on our Linux box... After that, on your ./configure line, you need the option --with-oci=/usr/local/Oracle/ or wherever you installed Oracle. or, more specifically, the ORACLE_HOME directory. Quite likely, it's more apt to be --with-oci=/home/oracle/OraHome1/ Brian Mauter [EMAIL PROTECTED] Roll Tide! - Brian - Brian S. Dunworth Sr. Software Development Engineer Oracle Database Administrator The Printing House, Ltd. (850) 875-1500 x225 [EMAIL PROTECTED] - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] oracle and php
Hi all, I am begginer in using ORACLE 8i DB with PHP, so please, could anybody help me ? When I try to connect or use any OCI or ORA function, it only say me Fatal error: Call to unsupported or undefined function ocilogon() in /home/httpd/html/ora.php3 on line 8 here is the part of code: ? $handle = OCILogon("scott","tiger"); if ($handle == false ) { echo 'error'; echo ocierror($handle).":".OCIError($handle); exit; } But I suppose, the problem is not in the code, but in some adjustment ... Thanks, Petr. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] oracle and php
It seems that you must include support of oracle functions (special module) in your configuration file. In windows it is php.ini file. Hi all, I am begginer in using ORACLE 8i DB with PHP, so please, could anybody help me ? When I try to connect or use any OCI or ORA function, it only say me Fatal error: Call to unsupported or undefined function ocilogon() in /home/httpd/html/ora.php3 on line 8 here is the part of code: ? $handle = OCILogon("scott","tiger"); if ($handle == false ) { echo 'error'; echo ocierror($handle).":".OCIError($handle); exit; } But I suppose, the problem is not in the code, but in some adjustment ... Thanks, Petr. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]