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