Connect to Oracle 8i Using PHP

gman

I have been using Oracle 8i for 3 years now and would like to start working with it in conjunction with PHP scripting. I have installed PHP 4 along with Apache 1.3 (using NuSphere's packaged installation program for PHP and MySQL) on a Windows NT 4.0 Workstation (the Oracle installation is running on this computer as well). While I have not had a problem connecting to MySQL databases using PHP on this computer, it seems that I cannot get a PHP connection to Oracle. Can anyone give me detailed instructions as to how to configure PHP, Apache and Oracle 8i so that I can start writing PHP scripts utilizing Oracle? Thanks in advance.

Glenn

tsinka

Hi,

first check if the oracle environment variables (ORACLE_HOME, NLS_LANG ...) are set correctly. To enable oracle support on Windows systems at least the Oracle client has to be installed on the server (I think that's already the case on your system). In the php.ini activate the oracle extensions that is uncomment the line

;extension=php_oci8.dll

and/or

;extension=php_oracle.dll

and restart apache. You should then be able to connect to Oracle with the php oracle functions.

hpnadig

I could connect to oracle. But am having problem with insertion for multiple tables...

getting lots and lots of errors..
Can you direct me to any link which gives me info to do this..

tsinka

Hi,

can you post some php code ? This would help a lot 🙂

hpnadig

db5 = OCILogon("scott","tiger");
$stmt5 = OCIParse($db5,"insert into circuit (cid,cname) values (:cid,:cname) ");

	OCIBindByName($stmt5,":CID",$cid,4);
	OCIBindByName($stmt5,":CNAME",$cname,32);

I used this and similiar thing to some 4 more tables....

Now the error says...

violated - parent key not found in c:\phpdev[url]www...........[/url] and all that stuff...

cannot insert NULL into ("SCOTT"."CIRCUIT"."CID") in c:\phpdev[url]www.......[/url]

I used proper primary keys alright, but dunno what's causing this...

tsinka

Hi,

seems like you have some constraints that are violated in this case. You might have to take care of the query order. First insert the data into the table the id in the second table refers to.

Hope I was clear enough, my english isn't that good 🙂

The NULL problem might be a "NOT NULL" problem. If you have any auto_increment values (or values incremented by triggers in case of oracle) you might change the query so that it omits that field by specifiying the remaining fields you want to insert.

INSERT INTO table (field1,field2..) VALUES (value1,value2...)

omitting the triggered field.

Thomas

hpnadig

here's the code...

please tell me whats wrong....

tsinka

Hi,

if you put some code just in front you queries to echo the form variables, does it show anything ? If not, register_globals might be set to off and you might either need to place

extract($_POST); in front of the

if(!isset($status)) $status = "show" ; // set form for viewing

line or replace all form variables with $_POST['variable'] intead of using $variable.

hpnadig

Pardon me, I didn't get you....

hpnadig

hey no! many thanks to you... I got it!

I got it right and the code's workin' fine....

thanks tsinka

tsinka

Hi,

I wasn't clear enough, I shoud've told you how I came to my last post 🙂

The following message:

cannot insert NULL into ("SCOTT"."CIRCUIT"."CID") in

after executing:

db5 = OCILogon("scott","tiger");
$stmt5 = OCIParse($db5,"insert into circuit (cid,cname) values (:cid,:cname) ");

OCIBindByName($stmt5,":CID",$cid,4);
OCIBindByName($stmt5,":CNAME",$cname,32);

caused my last post:

It seems like $cid doesn't exist after you submit the form because Oracle compains about the NULL value. In most cases there is one reason for this.

There is a variable called register_globals in the php.ini that is set to Off per default in recent php versions for security reasons.

If that variable is set to off then you can't access the form variables as $variable. You have to do it with $POST['variable'] for security reasons (and $GET for get variables).

If you don#t want to review the complete code there is another solution. PHP has a function called extract() that takes an array as argument and makes the values globally available for using them them directly as $variable.

tsinka

Ah,

ok, so forget my last post 🙂

hpnadig

OK, thanks, the script is working fine now, and I don't see any reason for my file being here. so I deleted it..

thanks tsinka 4 ur help

hpnadig

Since the topic of this post suggests connecting to oracle with php and till now there has been a different talk 'cos of me. So I attach this file I got while searching to make up 4 that....

this is a great one to get started with oracle - php.
Hope There's no problem in putting these here..
If there's any plase inform me I'll delete it...

So here you go...🙂