无法使用PHP与XAMPP连接到Oracle Database 11g

Question

Installed XAMMP and PHP 5.6.31 using Oracle instaclient_11_2 already in the C:\drive. Edited and enabled extension=php_oci8_11g.dll in php.ini. Installed php_oci8_11g.dll in C:\xampp\php\ext.

What did i miss?

PHP returns:

Fatal error: Call to undefined function oci_connect() in C:\xampp\htdocs\OC\oci8.php on line 3

<?php

$conn = oci_connect('hr', 'hr', 'localhost/orcl');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENTS_QUOTES),E_USER_ERROR);
}
else echo "connection successful";

?> 

Answer 1

I understand that you have enable OCI but enabling OCI can be tricky.

1. Please closely follow this link:

   https://www.oracle.com/technetwork/articles/dsl/technote-php-instant-12c-2088811.html

2. Please see dll for OCI match php , that is 64bit php , 64bit OCI DLL, or 32bit php and 32bit OCI

3. Try copying php_oci8_xx.dll to system32. and restart pc. (not recommended but just to avoid the path issue, but first thing first make sure you follow above link carefully)

Thank you