3 Replies Latest reply on Feb 10, 2017 4:15 AM by Billy~Verreynne

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

    3276943

      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