Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Stuck Call to undefined function oci_connect() using XAMPP

i'm want connect PHP to Oracle Database 12c, i'm already try in this video https://www.youtube.com/watch?v=KJme5JMxKeo

  • i'm already install xampp v3.2.2 and using PHP 5.6

  • install oracle database 12c : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

  • test login in SQLPlus enter image description here

  • unzip and paste Instant Client(Version 12.1.0.2.0) http://www.oracle.com/technetwork/topics/winsoft-085727.html to directory C

  • set path environtment C:\instantclient_12_1;

  • uncoment semicolon (;) extension=php_oci8_12c.dll in php.ini enter image description here

  • and already download php_oci8_12c.dll file in here : http://pecl.php.net/package/oci8/2.0.8/windows

    and already paste to in C:\xampp\php\ext

  • when i test script connect : http://pastebin.com/f1isKKar enter image description here

error message : Call to undefined function oci_connect()

i'm confused why can't connect to ORACLE DATABASE 12c :(

like image 479
Maestro Vladimir Avatar asked Jan 05 '23 18:01

Maestro Vladimir


2 Answers

you are very close.

  1. Add oci.dll, oraociei12.dll, and oraons.dll from C:\instantclient_12_1 to xampp/apache/bin folder. Replace the existing ones.

  2. Restart the Apache

N.B: Make sure that your PATH environment variable are set to this folder "C:\instantclient_12_1".

like image 59
Manyalo Avatar answered Jan 08 '23 06:01

Manyalo


Check whether command line PHP works. See if there are any log errors. Make sure you have the right OCI8 DLL. Triple check you have 32bit Oracle Instant Client and that it occurs first in PATH. If you have other Oracle libraries installed then your webserver may be finding them first: fix this.

like image 28
Christopher Jones Avatar answered Jan 08 '23 06:01

Christopher Jones