Call to undefined function oci connect

Question

I got this error   Fatal error  Call to undefined function oci connect    conn   oci connect  localhost    username    password   or die could not connect   oci error    that is the code   This is the error I got   Fatal error  Call to undefined function oci connect   in C  xampp htdocs org org php myphp php on line 51   I checked the PHP DLL files in ext folder    Somebody help on this issue thanks in advance

User · Answer

You need to enable that extension in your php ini file  See Oracle Installation   extension oci8 so

User · Answer

Download xampp and uncomment oracle 12c extension or 11c  extension oci8 11g  for xampp 7 2 9 Download instant client 32 bit and set its path Download instant client 32 bit SDK package and set its path Copy instant clients and SDK dll files to xamp php ext  xampp php  and xampp appache bin  Download php-oci of same php version of tread safe x86 then copy its files to php ext  dll  php version is written on top of phpinfo tab of xampp admin  OCI8 will appear on phpadmin page or apache admin then phpadmin tab  It means phpOCI has been installed

User · Answer

I installed Wamp  amp  expected everything to work out of the box  Not so  I have 2 Oracle clients on my x64 Windows machine  instant and full   If anyone else has a similar setup  the trick is to make sure the instant client is  a  in your Path environment variable and  b  precedes the full client in the Path variable  There s a really brief section on Windows here but it gave the answer

User · Answer

I just spend THREE WHOLE DAYS fighting against this issue    I was using my ORACLE connection in Windows 7  and no problem  Last week I Just get a new computer with Windows 8  Install XAMPP 1 8 2  Every app PHP MySQL on this server works fine  The problem came when I try to connect my php apps to Oracle DB       Call to undefined function oci pconnect     And when I start stop Apache with changes  a strange  Warning  on  PHP Startup  that goes to LOG with  PHP Warning   PHP Startup   in Unknown on line 0   I did everything  uncommented php oci8 dll and php oci8 11g dll  copy oci dll to  ext directory  near  Apache and NOTHING it works  Download every version of Instant Client and NOTHING   God came into my help  When I download ORACLE Instant Client 32 bits  everything works fine  phpinfo   displays oci8 info  and my app works fine    So  NEVER MIND THAT YOUR WINDOWS VERSION BE x64  The link are between XAMPP and ORACLE Instant Client

User · Answer

Check your php    version as like as PHP 5 6 32  cli   built  Oct 25 2017 16 02 15   Using the OCI8 extension to access Oracle Database  So Download php oci8 dll  from 1https   pecl php net package oci8 2 0 8 windows   5 6 Thread Safe  TS  x86    php oci8 dll must be the same version with your php version Then unzipped it and you will find   1 php oci8 dll  2 php oci8 11g dll  as per your oralce version  these two file pasted into your   xampp php ext   folder  Open your php ini file and add these   extension php oci8 dll  extension php oci8 11g dll Check your oracle version and service name using these commands   Open your cmd  sqlplus   as sysdba select   from v version  Oracle Database 11g Enterprise Edition Release 11 2 0 1 0 - Production  our oracle version is 11g so we can use instantclient 11 1  Instant Client 32-bit  downloads    from https   www oracle com technetwork topics winsoft-085727 html  show parameter service name  service name is orcl  you should remember this service name  After downloading instantclient 11 1 unzipped it and then pasted  in your Local Disk  And copy the path C  instantclient 11 1 and then set this path as your user variable  amp   system variable  Note is that my code is working without setting path variable  Open your cmd and enter into SQL  create your schema following these commands    sqlplus   as sysdba create user dbname identified by pass123  grant connect resource to dbname  Create table user info and insert data into your table and commit out  Note   you must commit your data either data is not inserted  Then this script run in your htdocs     x000D   x000D   lt html gt  x000D   lt head gt  lt title gt Oracle demo lt  title gt  lt  head gt  x000D   lt body gt  x000D   lt  php x000D   x000D     Create connection to Oracle x000D   conn   oci connect  dbname    pass123      localhost orcl        orcl is your service name x000D   x000D   query    select   from user info   x000D   stid   oci parse  conn   query   x000D   r   oci execute  stid   x000D   x000D     Fetch each row in an associative array x000D  print   lt table border  1  gt    x000D  while   row   oci fetch array  stid  OCI RETURN NULLS OCI ASSOC     x000D     print   lt tr gt    x000D     foreach   row as  item    x000D         print   lt td gt     item     null   htmlentities  item  ENT QUOTES      amp nbsp     lt  td gt    x000D       x000D     print   lt  tr gt    x000D    x000D  print   lt  table gt    x000D   x000D   x000D

User · Answer

I had the same issue  the solution on this page helped me  it s caused by using incompatible oci ddl files   Hope it helps

User · Answer

Download from Instant Client for Microsoft Windows  x64  and extract the files below to  quot c  oracle quot   instantclient-basic-windows x64-12 1 0 2 0 zip instantclient-sqlplus-windows x64-12 1 0 2 0 zip instantclient-sdk-windows x64-12 1 0 2 0 zip This will create the following folder  quot C  Oracle instantclient 12 1 quot   Finally  add the  quot C  Oracle instantclient 12 1 quot  folder to the PATH enviroment variable  placing it on the leftmost place  Then Restart your server

User · Answer

try this  in the php ini file uncomment this  extension dir         remove semicolon

User · Answer

I installed WAMPServer 2 5  32-bit  and also encountered an oci connect error  I also had Oracle 11g client  32-bit  installed  The common fix I read in other posts was to alter the php ini file in your C  wamp bin php php5 5 12 directory  however this never worked for me  Maybe I misunderstood  but I found that if you alter the php ini file in the C  wamp bin apache apache2 4 9 directory instead  you will get the results you want  The only thing I altered in the apache php ini file was remove the semicolon to extension php oci8 11g dll in order to enable it  I then restarted all the services and it now works  I hope this works for you

User · Answer

Simple steps  You need to enable the below extension in your php ini   extension php oci8 dll  extension php oci8 11 g dll   by removing the     so that the results will below   extension php oci8 dll extension php oci8 11 g dll   Download Oracle Instant Client - Preferably 32 bit  32 bit will also work on 64 bit  You can just google  download oracle instant client windows 32 bit  Use version 11 of the client because extension php oci8 11 g dll won t work with 12  Unzip the package into a location such as C  Oracle instantclient 11 2   Finally modify the System s PATH Environment Variable with end location  under system variables not user variables  Then you need to restart the System for PATH changes to fully propagate   If you just restart XAMPP WAMP without restarting the machine the Client s DLL files  i e  OCL dll  will not be loaded  nor found  by PHP s php oci8 11g dll extension

User · Answer

Alright  folks   First  use    lt  php  phpinfo      gt     and determine your PHP Version  located at the very top  e g  7 0 xxx  and also  your PHP Version architecture  x64 or x86 and also  Thread Safe or Not THread Safe  located in the first table as  Thread Safety     Disabled  obviously means  Not Thread Safe    It is absolutely critical that the following three pieces of software that you will need are    for the same major version of PHP  7 0 for 7 0 xxx  same version of Oracle as the version you are accessing  11g  12g  etc  the same Not Thread Safe   Thread Safe version of PHP all for the same architecture    If any of the following are for a different architecture  Not Thread Safe Thread Safe version  PHP major version number  or database version  you ll get errors    1  PHP for Windows  2  OCI8 PECL Drivers for PHP  https   pecl php net package oci8   3  Oracle Instant Client   Remember  If you are connecting to an 11g Oracle instance  you need an 11g driver   Second  install the correct PHP  OCI8 PECL Driver  and instant client   I chose   d  php  for php d  oci  for instant client unzip the contents of the OCI8 PECL Driver into d  php ext    Third  modify d  php php ini according the instructions given by Oracle   1  set the extension directory 2  set only one of the following    a  for 11g drivers  use extension php oci8 11g dll   b  for 12c drivers  use extension php oci8 12c dll   c  for other oracle DB drivers  use the correct oracle extension    Fourth  Add d  oci   or whatever your instant client install location is  to your system PATH   Fifth  reboot your PC   Sixth  on a command prompt  type  where oci   and verify that your Instant Client install path version of oci dll is present   Seventh  go to d  php  and type  php -m  and you should see OCI8 in the list   If you do not see OCI8 in the list of modules after typing  php -m   open up d  php errorlog txt  If you see something like   PHP Warning   PHP Startup  Unable to load dynamic library  ext php oci8 11g dll  -  1 is not a valid Win32 application    then either instant client or your PECL driver download is not the same architecture as your PHP version   If you see something like   PHP Warning   PHP Startup  Unable to load dynamic library  ext php oci8 12c dll  - The specified procedure could not be found    then you are using the wrong OCI8 PECL driver for your version of instant client   Hope this helps

User · Answer

Things to Make sure    Whenever you connecting Oracle Database   try to use 32 Bit oracle client libraries  Since XAMP PHP is compiled with 32 Bit Though you have 64 Bit windows Machine  Download Oracle Client from  Download From here Paste it in C  instantclient 12 1 Then Set the path to above in System Environment Variable Then Go to C  xampp php php ini and uncomment extension php oci8 12c dll Then Restart the XAMP and it should work without any Issue

[php] Call to undefined function oci_connect()

Examples related to php

Examples related to oracle