can not connect to oracle database using php

Question

I am using XAMPP version 5.6.15 to run my PHP file on windows 10.

But I am getting this error message:

Fatal error: Call to undefined function oci_connect() in F:\xampp\htdocs\Sbank\index.php on line 4

According to PHP docs everything should work fine.

<?php

$conn = oci_connect('admin', 'admin', 'localhost/JDT');
if (!$conn) {
    $e = oci_error();
    trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}

$stid = oci_parse($conn, 'SELECT sysdate FROM dual');
oci_execute($stid);

echo $stid;


?>

@Fairy I removed the ; before the extension=php_oci8_11g.dll within php.ini file — samer
– samer, Commented Aug 11, 2016 at 14:28

Alexanderp · Accepted Answer · 2016-08-11 14:25:25Z

1

Please ensure you have OCI8 extension enabled. check output of phpinfo() or extension_loaded ('extension name') or in CLI php -m

answered Aug 11, 2016 at 14:25

Alexanderp

3411 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

samer Over a year ago

I removed the ; before the extension=php_oci8_11g.dll within php.ini file and at phpinfo() the page is loaded but i dont really understand what do i hvae to check please ?

Alexanderp Over a year ago

Once you have enabled extension (removed ; before extension name in php.ini) restart apache and try run you script.

samer Over a year ago

same error Call to undefined function oci_connect()

Alexanderp Over a year ago

Please see Installing OCI8 on Windows section for details, hope this helps.

samer Over a year ago

thanks for your help ill check again in hope to find out what the problem >

|

Aman Maurya · Accepted Answer · 2016-08-11 14:27:12Z

1

If instant client has been installed but the full oracle client not yet ,you can use pdo to connect to oracle database like following coding:

<?php
$tns = " 
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = yourip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
       ";
$db_username = "youname";
$db_password = "yourpassword";
try{
    $conn = new PDO("oci:dbname=".$tns,$db_username,$db_password);
}catch(PDOException $e){
    echo ($e->getMessage());
}
?>

Source : http://php.net/manual/en/ref.pdo-oci.php

answered Aug 11, 2016 at 14:27

Aman Maurya

1,32512 silver badges26 bronze badges

3 Comments

samer Over a year ago

I tried to use your code instead of my and i got error message said could not find driver

Aman Maurya Over a year ago

then try this me2learn.wordpress.com/2008/10/18/…

samer Over a year ago

does it apply to xampp Apache server ?

samer · Accepted Answer · 2016-08-12 10:16:27Z

0

problem solved by following details steps within below youtube.com tutorial

youtube link

answered Aug 12, 2016 at 10:16

samer

1938 silver badges23 bronze badges

Collectives™ on Stack Overflow

can not connect to oracle database using php

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related