Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle 12c not connect with php see error Call to undefined function oci_connect()

User_OYQDCFeb 6 2017 — edited Feb 8 2017

Dear

I have 12c that run rightly

now i try to connect with PhP

i install

Instant Client Downloads for Microsoft Windows (32-bit)

and

Instant Client Downloads for Microsoft Windows (64-bit)

test both with download and install and set environment variable path

and my php.ini have

;extension=php_oci8_12c.dll  ; Use with Oracle Database 12c Instant Client

this line already 

see my code

<?php

$conn = oci_connect('mfatest', 'testphp', 'localhost/pdborcl'); /==( also i try with 'HOST_IP:PORT/orcl')

$query = 'select EMPNAME from  MDAEMPLOYEES';

$stid = oci_parse($conn, $query);

oci_execute($stid, OCI_DEFAULT);

while ($row = oci_fetch_array($stid, OCI_ASSOC)) {

foreach ($row as $item) {

echo $item." | ";

}

echo "

\n";

}

oci_free_statement($stid);

oci_close($conn);

?>

================

<?php

$conn = oci_connect('mfatest', 'testphp', 'localhost/pdborcl'); /==( also i try with 'HOST_IP:PORT/orcl')

$query = 'select EMPNAME from  MDAEMPLOYEES';

$stid = oci_parse($conn, $query);

oci_execute($stid, OCI_DEFAULT);

while ($row = oci_fetch_array($stid, OCI_ASSOC)) {

foreach ($row as $item) {

echo $item." | ";

}

echo "

\n";

}

oci_free_statement($stid);

oci_close($conn);

?>

but both code give me this error

see error

Fatal error: Uncaught Error: Call to undefined function oci_connect() in C:\xampp\htdocs\mfamda\test12c.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\mfamda\test12c.php on line 2

please give me idea what is the problem

regard

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2017
Added on Feb 6 2017
2 comments
37,295 views