oracle logon

mccark

Hello everyone,

I am new to PhP and have a question about db connectivity:

Is it really that simple to connect to an instance on a Oracle server (separate box)from a webserver running php4.x using the line:

int ociplogon(user, pwd, instance_name)

As a network/systems guy who is making the move to more coding I appreciate the help.

Cheers to all.

mccark

jeremuck

http://www.php.net/manual/en/ref.oracle.php

The second user comment looks like a real good example.

short answer is yes, I guess.

here's that guys comment:

<?php 



putenv( 
"ORACLE_SID=sid1"); 

putenv( 
"ORACLE_HOME=/u01/app/oracle/product/8.0.5"); 



$handle = ora_plogon( 
"SCOTT@sid1", "TIGER")or die; 

$cursor = ora_open($handle); 

ora_commitoff($handle); 



$query = "SELECT * FROM EMP"; 

ora_parse($cursor, $query) or die; 

ora_exec($cursor); 



echo "<HTML><PRE>\n"; 

echo "$query\n\n"; 

$numcols = 0; 

while(ora_fetch($cursor)){ 

$numcols = ora_numcols($cursor); 

for($column=0; $column < $numcols; $column++){ 

$data = trim(ora_getcolumn($cursor, $column)); 

if($data =="") $data = "NULL"; 

echo"$data\t"; 

} 

echo "\n"; 

} 

$numrows = ora_numrows($cursor); 

echo "\nROWS RETURNED: $numrows\n"; 

echo "</PRE></HTML>\n"; 



ora_close($cursor); 



?>

mccark

Thanks Jeremuck,

One problem is that the Oracle server is Win 2k and remote (still accessible on the lan) so the putenv () param confuses me with regards to syntax.

I appreciate the help.

mccark