Fatal error: Call to Undefined Function oci_connect()

Question

Error connecting to Oracle database. Below is the code in PHP:

<?php 
$ora_bd = "(DESCRIPTION=
      (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=TCP) 
          (HOST=192.168.0.249)(PORT=1521)
        )
      )
      (CONNECT_DATA=(SERVICE_NAME=CSTESTE))
 )"; 

$ora_conexao = oci_connect('refeitorio', 'tiete2018', $ora_bd);

if (!$ora_conexao) { 
$erro = oci_error();
    trigger_error(htmlentities($erro['message'], ENT_QUOTES), E_USER_ERROR);
    exit;
}else{                                                         
echo "Conectado com Sucesso.";  
}

Recalling that I have already enabled the following commands on php.ini

extension=php_oci8.dll
extension=php_pdo_oci.dll
extension=php_oracle.dll

The following error appears:

Fatal error: Uncaught Error: Call to Undefined Function oci_connect() in C: wamp64 www Sistema Refeicao Core Testecon.php:11 Stack trace: #0 {main} thrown in C: wamp64 www Sistema Refeicao Core Testecon.php on line 11

Answer 1

I had this problem recently and the solution was this:

You lower the xamp or wamp 32 or 64 bits this will have to be your version of instant client oracle

after installing them with any version of php, when calling a function oci_oracle make a mistake.

You must then first enable the extensions on php.ini

an example of how to access php.ini in xamp:

enable these extensions in that order:

extension=php_oci8.dll
extension=php_oci8_12c.dll
extension=php_oracle.dll

Note: if you do not have to enable, create and check the second, I put 12c because mine instant client is 12c.

After that you need to install the Instant client.

Opens the cmd AS ADMINISTRATOR goes to the location of the client and runs odbc_install

The next step is the most important, and that’s why I was taking a beating:

you need to add in PATH where is your oracle instant client:

and create TNS.ADMIN:

does this for the two variable boxes, system and user:

Done this, configure the file tnsnames. restart your machine, and you can use the functions oci.

Your Instant client must be in the same version as php, 32 or 64

by downloading php 7 in php.ini from him he asks for version 12 of instant client as you can see in the photo.

Answer 2

Dude, I had this problem and it took my sleep away for a few days. In my case the mistake was:

Fatal error: Call to Undefined Function oci_connect()

I could only solve by reinstalling everything in version 32 bits. For me it worked well. I installed XAMPP xampp-Win32-7.3.2-0-VC15 and enabled the extension:

 extension=oci8_12c

in php.ini. It is also worth checking if the extension is in the right place:

extension_dir="C:\xampp\php\ext"

After that you install Oracle Instant Client in the right version, in my case it was 32-bits in 12_2 version. The next step is to put this path in the environment variables, as the friend above spoke. After doing this it should be possible to see OCI8 on the phpinfo page:

Another tip is to check for errors in your php. To do this open the command prompt and navigate to the php folder of xampp. in my case it was "C: xampp php". Type in the 'php' command and see if there are any problems with the enabled dlls. If there is, the problem will be shown. If you want to do this as a test in your current version, see if there are any messages like "file not found" or "file is not win 32". If it appears, most likely this solution, passing to version 32 bits, will solve your problem!