[PHP] PHP with Oracle
is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. The server is Linux king 2.6.5-7.191-bigsmp #1 SMP Tue Jun 28 14:58:56 UTC 2005 i686 i686 i386 GNU/Linux PHP 4.3.4 (cli) (built: Jul 1 2004 16:44:46) Copyright (c) 1997-2003 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies DB Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options -- PONS Communications/Network and Systems Engineer
RE: [PHP] PHP with Oracle
[snip] is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. [/snip] Please RTFM at http://www.php.net/oracle and have a look at oci_connect -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP with Oracle
Assuming the PHP web page is available, anyone else having problems connecting to php.net? -B Jay Blanchard wrote: [snip] is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. [/snip] Please RTFM at http://www.php.net/oracle and have a look at oci_connect -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP with Oracle
php.net is DOWN!!! or what On 4/19/06, Brad Bonkoski [EMAIL PROTECTED] wrote: Assuming the PHP web page is available, anyone else having problems connecting to php.net? -B Jay Blanchard wrote: [snip] is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. [/snip] Please RTFM at http://www.php.net/oracle and have a look at oci_connect -- PONS Communications/Network and Systems Engineer
Re: [PHP] PHP with Oracle
Only the main US Server. Try: http://us2.php.net/ on Wednesday 19 April 2006 15:13, Brad Bonkoski wrote: Assuming the PHP web page is available, anyone else having problems connecting to php.net? -B Jay Blanchard wrote: [snip] is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. [/snip] Please RTFM at http://www.php.net/oracle and have a look at oci_connect -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP with Oracle
[snip] php.net is DOWN!!! or what [/snip] Use your resources. There are mirrors if the main is down, also here is Oracle's PHP Dev Center; http://www.oracle.com/technology/tech/php/index.html http://us3.php.net/oci8 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP with Oracle
http://us2.php.net/ http://us3.php.net/ using mirror On 4/19/06, Thomas Munz [EMAIL PROTECTED] wrote: Only the main US Server. Try: http://us2.php.net/ on Wednesday 19 April 2006 15:13, Brad Bonkoski wrote: Assuming the PHP web page is available, anyone else having problems connecting to php.net? -B Jay Blanchard wrote: [snip] is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. [/snip] Please RTFM at http://www.php.net/oracle and have a look at oci_connect -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PONS Communications/Network and Systems Engineer
Re: [PHP] PHP with Oracle
Brad: Yes, I'm having problems as well (as well as top posting). Bu,t there are other sources, such as: http://www.weberdev.com/oci_connect tedd At 9:13 AM -0400 4/19/06, Brad Bonkoski wrote: Assuming the PHP web page is available, anyone else having problems connecting to php.net? -B Jay Blanchard wrote: [snip] is there a ready script that handle entering user name and password for authentication by extracting the Data from Oracle10g DB without showing the URL in the address bar...I am thinking of using a popup window Spec. [/snip] Please RTFM at http://www.php.net/oracle and have a look at oci_connect -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP and Oracle RAC
Has anyone succesfully got PHP and Oracle Real Application Cluster (RAC) working together? -=Kevin=- - Do you Yahoo!? Yahoo! Tax Center - File online by April 15th
Re: [PHP] PHP and Oracle RAC
Hi Kevin, Well, I use Oracle 8.1.7 in the DB server (not a RAC) and Oracle 9.2.0 in the web server (Linux). It works fine. AFAICT, there is no need to do something else in order to be able to connect to a RAC. You just have to (optionally) define a load balancing option in the tnsnames.ora in the client, in this case the web server, to let the RAC know that it must determine which real server within the cluster will recieve the connection. I might be wrong though. -William El mi? 14-04-2004 a las 17:45, Kevin O'Brien escribió: Has anyone succesfully got PHP and Oracle Real Application Cluster (RAC) working together? -=Kevin=- - Do you Yahoo!? Yahoo! Tax Center - File online by April 15th -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Php, Blob, Oracle
Hi, How can i display a blob column that contins a MS word object. OR How can i display a blob column that contins a bitmap object. function foo() { $this-statement = OCIParse($this-db_con_id, SELECT blobcolumn FROM XX ); if (!$this-statement) { $oerr = OCIError($this-statement); echo Fetch Code 1:.$oerr[message]; exit; }else{ OCIExecute($this-statement); } $displaypage= table; while (OCIFetchInto($this-statement,$row,OCI_ASSOC)){ $displaypage =$displaypage. tr td align=\center\ class=\td_yazi\.$row[blobcolumn]./td; }; $displaypage= \table; return$displaypage; }
Re: [PHP] Php, Blob, Oracle
On Thu, Feb 27, 2003 at 05:51:01PM +0200, M.ALPER KARASAHIN wrote: Hi, How can i display a blob column that contins a MS word object. OR How can i display a blob column that contins a bitmap object. function foo() { $this-statement = OCIParse($this-db_con_id, SELECT blobcolumn FROM XX ); if (!$this-statement) { $oerr = OCIError($this-statement); echo Fetch Code 1:.$oerr[message]; exit; }else{ OCIExecute($this-statement); } $displaypage= table; while (OCIFetchInto($this-statement,$row,OCI_ASSOC)){ while (OCIFetchInto($this-statement,$row,OCI_ASSOC|OCI_RETURN_LOBS)){ $displaypage =$displaypage. tr td align=\center\ class=\td_yazi\.$row[blobcolumn]./td; td align=\center\ class=\td_yazi\.$row[BLOBCOLUMN]./td; }; $displaypage= \table; return$displaypage; } -- Thies C. Arntzen - Looking for all sorts of freelance work - just ask.. http://www.amazon.de/exec/obidos/wishlist/AB9DY62QWDSZ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP and Oracle
Hello, Does someone had a speed trouble when using PHP and Oracle with OCI ?? The trouble i have is that the php pages are slower and slower during the day. It looks that if I make an apache restart things restart in a good way. I don't understand where the trouble come from. Help ! Christophe -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP and Oracle
Does someone had a speed trouble when using PHP and Oracle with OCI ?? The trouble i have is that the php pages are slower and slower during the day. It looks that if I make an apache restart things restart in a good way. I don't understand where the trouble come from. I've seen this once before and the cause was lots of phantom Oracle connections left open. So it wasn't PHP or Apache but connecting to the database which slowed things down. That may not be your problem but it's worth looking into... Larry -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP and Oracle
Hi, I'm having a big problem with php4 and Oracle 8.1.6 and I'd like to know if anybody knows how to handle CLOB fields using oracle's functions. Thanks. Jadiel Flores - http://www.abargon.com [EMAIL PROTECTED] (52-55) 52-29-80-34 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP with Oracle
Hi guys, I'm having some problems here, I have to do an application using Oracle in Windows, I enabled the extension php_oci8.dll but I'm receiving this error: Warning: Unable to load dynamic library 'C:\PHP\extensions/php_oci8.dll' - Access is denied. in Unknown on line 0 The dll is in the directory but I have no idea why php can't load it. Any suggestion?? Jadiel Flores - http://www.abargon.com [EMAIL PROTECTED] (52-55) 52-29-80-34 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP with Oracle
Have you tried to check the access permissons ? Maybe the Oracle/PHP user/app doesn't have the right permissons in that directory. Regards, Francisco M. Vaucher Departamento IT Tyco / ADT Security Services Buenos Aires - Argentina mailto:[EMAIL PROTECTED] -Mensaje original- De: Jadiel Flores [mailto:[EMAIL PROTECTED]] Enviado el: martes, 01 de octubre de 2002 12:51 Para: [EMAIL PROTECTED] Asunto: [PHP] PHP with Oracle Hi guys, I'm having some problems here, I have to do an application using Oracle in Windows, I enabled the extension php_oci8.dll but I'm receiving this error: Warning: Unable to load dynamic library 'C:\PHP\extensions/php_oci8.dll' - Access is denied. in Unknown on line 0 The dll is in the directory but I have no idea why php can't load it. Any suggestion?? Jadiel Flores - http://www.abargon.com [EMAIL PROTECTED] (52-55) 52-29-80-34 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP and ORACLE
Hi, I started with PHP and MYSQL a while ago and now I've been involved in a huge database project with ORACLE. My point is I never used it nor develop with ORACLE, so I want to know where and what kind of information I need to port my web application developed with php and mysql to port it to ORACLE, and where can I find information regarding HUGE database applications design using php. So far I only have the book Designing Web Applications using PHP and MySQL by Luke Wellington, and MySQL by Paul Dubois. And i don't have any kind of experience with Oracle, so I would appreciate any recommendations from experienced developers. TIA, Regards, Ricardo Fitzgerald -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP and ORACLE
ðÒÉ×ÅÔ! I hope you are not really living in the early 70's, are you? Ricardo Fitzgerald wrote: Hi, I started with PHP and MYSQL a while ago and now I've been involved in a huge database project with ORACLE. Have the Oracle box do most of it. Make sure that: 1) there is a well defined API for external application (including your PHP client) to access data. This *must* written an paper and documented. No code writing prior to this. 2) all about referential integrity is done within Oracle 3) use triggers and SPs to enforce data consistency (handle with care, they load the db server if used unproperly) 4) find a good DBA to maintain the system (Oracle can degrade quite dramatically if not properly maintained) 5) interact very little with the DB, to avoid loading its server. (That is, call an SP, get the result set from a tmp table) 6) avoid locking as much as you can 7) Prey the current Oracle bugs are not too evil. 8) get ready to say good bye to your vacations. 9) ask for a paycheck raise ðÏËÁ áÌØÂÅÒÔÏ ëÉÅ× -_=}{=_-@-_=}{=_--_=}{=_-@-_=}{=_--_=}{=_-@-_=}{=_--_=}{=_- LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? lOrD i'M sHiNiNg... YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE tHe TeSt, YeS iT iS ThE tEsT, yEs It Is tHe TeSt, YeS iT iS ThE tEsT, yEs It Is... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP and ORACLE
On Fri, 12 Jul 2002, Alberto Serra wrote: Ricardo Fitzgerald wrote: I started with PHP and MYSQL a while ago and now I've been involved in a huge database project with ORACLE. Have the Oracle box do most of it. Make sure that: 1) there is a well defined API for external application (including your PHP client) to access data. This *must* written an paper and documented. No code writing prior to this. 2) all about referential integrity is done within Oracle 3) use triggers and SPs to enforce data consistency (handle with care, they load the db server if used unproperly) 4) find a good DBA to maintain the system (Oracle can degrade quite dramatically if not properly maintained) 5) interact very little with the DB, to avoid loading its server. (That is, call an SP, get the result set from a tmp table) 6) avoid locking as much as you can 7) Prey the current Oracle bugs are not too evil. 8) get ready to say good bye to your vacations. 9) ask for a paycheck raise This is all very good advice (especially 4 and 8). Oracle can do amazing things but if you just pretend it's MySQL you'll have a pretty miserable time. Learn about triggers and stored procedures and views and you will be amazed at how quickly and scalably you can do very complicated things. Don't learn about indexing and table optimization and you will be amazed at how slow your application is. miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP and ORACLE
Ricardo Fitzgerald wrote: Hi, I started with PHP and MYSQL a while ago and now I've been involved in a huge database project with ORACLE. ---snip--- And i don't have any kind of experience with Oracle, so I would appreciate any recommendations from experienced developers. I develop a lot with Oracle (pl/sql not php) but I think the key factors remain the same with a small or large amount of data. Spend time ensuring the table layout (and its indices) are fairly optimal. With a small amount of data extra time in doing sql statements may not be critical, but with a lot of data it would be very noticeable. Two of the Oracle CDs in the distribution are documentation. MostOne of the books on them is the Server Applications Developer's Guide, some of the information on table layout and general optimising may be useful, but most of it is about using pl/sql. Otherwise just ensure the database is doing all your sorting etc, and gives you the data in the order you need it. This doesn't seem much advice, but its a start. Post anything else more specific. Hope it helps. Chris PS Your computer clock tells me I'm a teenager again! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP and ORACLE
I don't think you would find any book covering PHP and Oracle. They technologies usually don't mix. Oracle is very enterprise oriented; whereas, PHP is open source community favorite. Oracle is a beast by its nature. So, you would need a few good books on Oracle. I would suggest following proper design approaches up-front. Large/huge projects incur large costs if design has to change during later stages of development. Frankly, I don't know of any good PHP design books. Please let me know if you find any. Good luck. Ricardo Fitzgerald [EMAIL PROTECTED] wrote: Hi, I started with PHP and MYSQL a while ago and now I've been involved in a huge database project with ORACLE. My point is I never used it nor develop with ORACLE, so I want to know where and what kind of information I need to port my web application developed with php and mysql to port it to ORACLE, and where can I find information regarding HUGE database applications design using php. So far I only have the book Designing Web Applications using PHP and MySQL by Luke Wellington, and MySQL by Paul Dubois. And i don't have any kind of experience with Oracle, so I would appreciate any recommendations from experienced developers. TIA, Regards, Ricardo Fitzgerald -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - Do You Yahoo!? New! SBC Yahoo! Dial - 1st Month Free unlimited access
Re: [PHP] PHP and Oracle
On Mon, Mar 25, 2002 at 02:49:07PM -0500, Scarbrough, Jeb (ISS Atlanta) wrote: Is it possible to create a transaction the involves multiple pages using PHP and oracle. For example, can I log onto oracle using OCIPLogon on one page named master, insert information, go to the next page named detail, insert information and commit both transactions at the same time? no you can't - bacause HTTP is stateless and it is unlikely that your 2nd page will be served by the same httpd process there's no way to have transactions span multiple pages. you will have to emulate this behaviour! tc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP and Oracle
Is it possible to create a transaction the involves multiple pages using PHP and oracle. For example, can I log onto oracle using OCIPLogon on one page named master, insert information, go to the next page named detail, insert information and commit both transactions at the same time? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP with ORACLE 8i/9i
Question: I want to build php withd support for ORACLE 8i or 9i. Normally you use the option with-oci=path-to-oraclehome. So far so good. How can I achieve this when the oracle database is running on another server? Thx Haemelinck Steve Haemelinck.be - Developers Unite (Under construction ) http://www.haemelinck.com http://www.haemelinck.be:8080/ [EMAIL PROTECTED] -- PHP General 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] PHP with ORACLE 8i/9i
On Fri, Nov 16, 2001 at 10:49:17AM +0100, Steve Haemelinck wrote: Question: I want to build php withd support for ORACLE 8i or 9i. Normally you use the option with-oci=path-to-oraclehome. So far so good. How can I achieve this when the oracle database is running on another server? you need to install oracle on the client-machine as well! tc Thx Haemelinck Steve Haemelinck.be - Developers Unite (Under construction ) http://www.haemelinck.com http://www.haemelinck.be:8080/ [EMAIL PROTECTED] -- PHP General 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 General 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] php under Oracle Web server pleaaaaaaaaaase!
Hello Is it possible to work with php under an oracle server ? If yes can u point me to some manuals and articles Thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP General 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] php under Oracle Web server pleaaaaaaaaaase!
On Mon, Mar 19, 2001 at 10:27:19AM -, kaab kaoutar wrote: Hello Is it possible to work with php under an oracle server ? If yes can u point me to some manuals and articles AFAIK, the Oracle Web server is not Open Source; hence it would be difficult to support it directly. You can always use the CGI or servlet options though. All the stuff for other web servers besides Apache is in the source tree under: /usr/src/php-4.0.4/sapi/ Regards, Frank -- PHP General 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] php under Oracle Web server pleaaaaaaaaaase!
HI! DO U MEAN I SHOULD GIVE UP USING PHP under oracle web server ? i used to work on php under PWS and apache! However i've made a project with ASP under IIS but the client changed his mind and wanted to put it in his oracle web server ! i thought of using php translation from asp ! or at last as long as i master php code it again ! any idea pleaase! Thanks From: Frank Joerdens [EMAIL PROTECTED] To: kaab kaoutar [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [PHP] php under Oracle Web server pleaase! Date: Mon, 19 Mar 2001 11:41:42 +0100 On Mon, Mar 19, 2001 at 10:27:19AM -, kaab kaoutar wrote: Hello Is it possible to work with php under an oracle server ? If yes can u point me to some manuals and articles AFAIK, the Oracle Web server is not Open Source; hence it would be difficult to support it directly. You can always use the CGI or servlet options though. All the stuff for other web servers besides Apache is in the source tree under: /usr/src/php-4.0.4/sapi/ Regards, Frank -- PHP General 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] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP General 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] php under Oracle Web server pleaaaaaaaaaase!
You can still use PHP with Oracle Webserver, www.php.net is the best resource I found so far :) - Original Message - From: "kaab kaoutar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 19, 2001 6:56 PM Subject: Re: [PHP] php under Oracle Web server pleaase! HI! DO U MEAN I SHOULD GIVE UP USING PHP under oracle web server ? i used to work on php under PWS and apache! However i've made a project with ASP under IIS but the client changed his mind and wanted to put it in his oracle web server ! i thought of using php translation from asp ! or at last as long as i master php code it again ! any idea pleaase! Thanks From: Frank Joerdens [EMAIL PROTECTED] To: kaab kaoutar [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [PHP] php under Oracle Web server pleaase! Date: Mon, 19 Mar 2001 11:41:42 +0100 On Mon, Mar 19, 2001 at 10:27:19AM -, kaab kaoutar wrote: Hello Is it possible to work with php under an oracle server ? If yes can u point me to some manuals and articles AFAIK, the Oracle Web server is not Open Source; hence it would be difficult to support it directly. You can always use the CGI or servlet options though. All the stuff for other web servers besides Apache is in the source tree under: /usr/src/php-4.0.4/sapi/ Regards, Frank -- PHP General 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] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP General 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 General 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] PHP w/ Oracle OCI8 - how stable?
I'm thinking of using PHP to talk to an Oracle database with the OCI8 interface - is PHP's OCI8 interface stable? Anything unusual I should know about? I'm using: Redhat 6.1 Linux PHP 4.0.4pl1 Oracle 8i 8.1.6 Apache 1.3.14 TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com -- PHP General 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] PHP w/ Oracle OCI8 - how stable?
Very stable. Rudolf Visagie [EMAIL PROTECTED] -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED]] Sent: 20 March 2001 01:18 To: [EMAIL PROTECTED] Subject: [PHP] PHP w/ Oracle OCI8 - how stable? I'm thinking of using PHP to talk to an Oracle database with the OCI8 interface - is PHP's OCI8 interface stable? Anything unusual I should know about? I'm using: Redhat 6.1 Linux PHP 4.0.4pl1 Oracle 8i 8.1.6 Apache 1.3.14 TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com -- PHP General 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 General 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] PHP and Oracle Zombie processes
If you don't see --enable-sigchild in phpinfo() then : (a) you are not running the version you compiled (b) your config script had something wrong. Baseline: if you don't see it, it's not there. You have to recompile. -Stathis. Bob Kakalec wrote: When I execute an sql statement against my Oracle database from PHP, I create an oracle zombie process. This eventually hits a "number of zombie process" limit and prevents my page from executing. The queries work properly (except for the zombie problem). Here is a sample that creates the zombie process: putenv("ORACLE_HOME=/h/app/oracle/product/8.1.6"); putenv("ORACLE_SID=dbase_name"); putenv("TNS_ADMIN=/h/app/oracle/product/8.1.6/network/admin");// thought this might help the zombie problem $conn=OCILogon("get_rid_of" , "zombie"); $sql_get_info="SELECT OppID, OppTitle FROM TEST WHERE OppID=4"; $stmt = OCIParse($conn,$sql_get_info); OCIExecute($stmt); OCIFetch($stmt)); $valid_opp_id = OCIResult($stmt, "OPPID"); $valid_opp_title = OCIResult($stmt, "OPPTITLE"); OCIFreeStatement($stmt); / using a separate query to get the clob.. $clob_field="OPPTEXT"; // this field in UPPPER CASE $sql="SELECT $clob_field from TEST WHERE OppID=$oid"; $stmt = OCIParse($conn, $sql); $clob_text = OCINewDescriptor($conn,OCI_D_LOB); OCIDefineByName($stmt, $clob_field, $clob_text); OCIExecute($stmt); OCIFetch($stmt); $valid_text=$clob_text-load(); $clob_text-free(); OCIFreeStatement($stmt); Here is how I configured PHP 4.0.3pl1 (this is from phpinfo();) : ./configure --with-apxs=/usr/local/apache/bin/apxs --with-config-file-path=/etc/httpd --with-oracle=/ora8/m01/app/oracle/product/8.1.6 I also added OCI8 support via.. --with-oci8=/ora8/m01/app/oracle/product/8.1.6 ... phpinfo(); states oci8 support is "enabled". I did --enable-sigchild but I don't see it showing in the phpinfo(); ??? I am using: Oracle 8.1.6, Apache 1.3.12 , RedHat 6.0 - all on one server. Any ideas on what I might be doing wrong? Am I missing something? Any help would be greatly appreciated. Thanks, Bob -- PHP General 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 General 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] PHP and Oracle Zombie processes
When I execute an sql statement against my Oracle database from PHP, I create an oracle zombie process. This eventually hits a "number of zombie process" limit and prevents my page from executing. The queries work properly (except for the zombie problem). Here is a sample that creates the zombie process: putenv("ORACLE_HOME=/h/app/oracle/product/8.1.6"); putenv("ORACLE_SID=dbase_name"); putenv("TNS_ADMIN=/h/app/oracle/product/8.1.6/network/admin");// thought this might help the zombie problem $conn=OCILogon("get_rid_of" , "zombie"); $sql_get_info="SELECT OppID, OppTitle FROM TEST WHERE OppID=4"; $stmt = OCIParse($conn,$sql_get_info); OCIExecute($stmt); OCIFetch($stmt)); $valid_opp_id = OCIResult($stmt, "OPPID"); $valid_opp_title = OCIResult($stmt, "OPPTITLE"); OCIFreeStatement($stmt); / using a separate query to get the clob.. $clob_field="OPPTEXT"; // this field in UPPPER CASE $sql="SELECT $clob_field from TEST WHERE OppID=$oid"; $stmt = OCIParse($conn, $sql); $clob_text = OCINewDescriptor($conn,OCI_D_LOB); OCIDefineByName($stmt, $clob_field, $clob_text); OCIExecute($stmt); OCIFetch($stmt); $valid_text=$clob_text-load(); $clob_text-free(); OCIFreeStatement($stmt); Here is how I configured PHP 4.0.3pl1 (this is from phpinfo();) : ./configure --with-apxs=/usr/local/apache/bin/apxs --with-config-file-path=/etc/httpd --with-oracle=/ora8/m01/app/oracle/product/8.1.6 I also added OCI8 support via.. --with-oci8=/ora8/m01/app/oracle/product/8.1.6 ... phpinfo(); states oci8 support is "enabled". I did --enable-sigchild but I don't see it showing in the phpinfo(); ??? I am using: Oracle 8.1.6, Apache 1.3.12 , RedHat 6.0 - all on one server. Any ideas on what I might be doing wrong? Am I missing something? Any help would be greatly appreciated. Thanks, Bob -- PHP General 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] PHP 4.0.4pl1 + Oracle 9iAS + AIX 4.3.3 - Seg faults at first PHP call -Pthreads?
Anyone have any ideas as to what my problem is here? From the core dump it looks like a problem with pthreads but I'm stuck as to where to go from here. Here is exactly what I did to reproduce the problem. This is on an AIX 4.3.3 box with Oracle 9iAS which runs Apache 1.3.12. I have successfully installed PHP on Oracle 8iAS which runs Apache 1.3.9. Here's the exact steps I took to install PHP: NOTE: I ran all of this as the oracle user and I had my ORACLE_HOME set to /ias/6iserver. This shouldn't be necessary since we specify this on the configure line but I did it to be safe. Added -I/ias/Apache/perl/lib/5.00503 to the end of the #!perl call at the top of the apxs script. A perl module (strict.pm) is required but is not found in the include path when the configure script runs apxs. Also, I'm not sure why, but Oracle 9iAS automatically assumes everyone is running Solaris. In the apxs script I changed a '-DSOLARIS2=260' reference to -DAIX=43. Ran CC=cc configure --with-apxs=/ias/Apache/Apache/bin/apxs --with-oci8=/ias/6iserver --without-mysql --prefix=/ias/Apache/Apache After the configure script was done I edited config_vars.mk and added -I/ias/rdbms/demo and -I/ias/rdbms/public to the INCLUDES variable. IAS keeps some of the oci8 header files in these directories. Also, for 9i I had to add -I/ias/Apache/Apache/include to the INCLUDES variable. I did not have to do this for 8iAS. AIX has a sparsely documented bug where alloca() is not defined on the system and the PHP configure script does not seem to handle this properly. We need to add -ma to CFLAGS to get around this. Created a link in /ias/6iserver/lib for libclntsh.a. For some reason only a .so was included in 9iAS. I checked 8iAS and this file is not missing here. Ran ln -s libclntsh.so libclntsh.a in the /ias/6iserver/lib directory. Ran make. Ran make install. Apache starts up ok, but I get a seg fault at the first call to PHP. Only the child http process dies. Apache error log shows: [Sun Feb 18 20:51:19 2001] [notice] Apache/1.3.12 (Unix) ApacheJServ/1.1 PHP/4.0.4pl1 mod_perl/1.22 configured -- resuming normal operations [Sun Feb 18 20:51:52 2001] [notice] child pid 16028 exit signal Segmentation fault (11) DBX output of core file: Several pages of warnings like this snipped warning: Unable to access address 0x2007d6fc from core warning: Unable to access address 0x2007d700 from core warning: Unable to access address 0x2007d700 from core warning: Unable to access address 0x2007d704 from core warning: Unable to access address 0x2007d704 from core warning: Unable to access address 0x2007d708 from core warning: Unable to access address 0x2007d708 from core [using memory image in ../core] warning: Unable to access address 0xf01558e4 from core Segmentation fault in signal._p_nsleep [/usr/lib/libpthreads.a] at 0xd0013db4 0xd0013db4 (_p_nsleep+0x10) 80410014lwz r2,0x14(r1) Any ideas? Thanks, Michael Champagne, Software Engineer Capital Institutional Services, Inc. wk: [EMAIL PROTECTED] ** This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction, unless specifically agreed otherwise. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect the views or opinions of Capital Institutional Services, Inc. Capital Institutional Services, Inc. accepts no liability for any errors or omissions arising as a result of transmission. Use of this communication by other than intended recipients is prohibited. ** -- PHP General 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] PHP and Oracle resources
On Sun, Jan 28, 2001 at 12:46:37AM -0500, Kristofer Widholm wrote : Well, I've been given the joyous task of implementing the DaveTV project at CBS via PHP, using Oracle as a database. I've never used Oracle before. Looking at the PHP functions for Oracle, and having heard about it in the past, it seems like quite a different approach than any SQL database I've ever used. I still don't get the whole point of cursor objects, etc. :-) It's ain't that hard. Just use OCILogon to connect, then OCIParse to parse the sql statement and finally OCIExecute it. Loop through your result data with OCIFetchInto. The Shitload of possible errors should be abstracted into a class. m. -- Markus Fischer, http://josefine.ben.tuwien.ac.at/~mfischer/ EMail: [EMAIL PROTECTED] PGP Public Key: http://josefine.ben.tuwien.ac.at/~mfischer/C2272BD0.asc PGP Fingerprint: D3B0 DD4F E12B F911 3CE1 C2B5 D674 B445 C227 2BD0 -- PHP General 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] PHP and Oracle resources
Well, I've been given the joyous task of implementing the DaveTV project at CBS via PHP, using Oracle as a database. I've never used Oracle before. Looking at the PHP functions for Oracle, and having heard about it in the past, it seems like quite a different approach than any SQL database I've ever used. I still don't get the whole point of cursor objects, etc. :-) It would all be pretty hilarious if it weren't so real, and with a big fat deadline looming smack for the end of February. To get to the point: Anyone have any good PHP Oracle tutorials, resources, books, etc, to point me to? EVERYTHING I see is MySQL, MySQL, MySQL, and all I get for Oracle are lists of unexplained PHP function calls. Just point me in the right direction. I can walk there myself. Thanks for the help. Kristofer -- __ Kristofer Widholm Web Pharmacy [EMAIL PROTECTED] 191 Grand Street, Brooklyn NY 11211 718.599.4893 __ -- PHP General 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]