How to SELECT data from Oracle database using PHP

Question

How do I fetch the EMPNO and ENAME columns from the table called emp?

This is my connection string:

if ($c = oci_connect("tharindu", "123456", "localhost/XE")) {  
   echo "Successfully connected to Oracle.";   
   oci_close($c);
} else {  
   $err = oci_error();   
   echo "Oracle Connect Error " . $err['text'];
}

Jude Cooray · Accepted Answer · 2011-05-11 04:08:28Z

4

$array = oci_parse($c, "SELECT EMPNO,ENAME
                            FROM emp");

oci_execute($array);

while($row=oci_fetch_array($array))

{

echo $row[0]." ".$row[1];

}

edited May 11, 2011 at 4:08

Jude Cooray

19.9k21 gold badges85 silver badges128 bronze badges

answered May 11, 2011 at 3:59

Rasel

15.5k6 gold badges42 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tharindu Over a year ago

i have error msg: Successfully connected to Oracle. Warning: oci_parse() expects parameter 1 to be resource, null given in C:\wamp\www\temp\example2\x.php on line 11 Warning: oci_execute() expects parameter 1 to be resource, null given in C:\wamp\www\temp\example2\x.php on line 13 Notice: Undefined variable: stid in C:\wamp\www\temp\example2\x.php on line 15 Warning: oci_fetch_array() expects parameter 1 to be resource, null given in C:\wamp\www\temp\example2\x.php on line 15

Collectives™ on Stack Overflow

How to SELECT data from Oracle database using PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related