Database Connection PHP to OracleDB

[webstarter7]

Hello, i am new here and new to PHP.
I am trying to connect my application with the oracleDB i got provided.
So i have got a TNS entry of the database. Something like this:

Code: Select all

myname =
(DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx.com)(PORT=1530)))
(CONNECT_DATA=(SERVICE_NAME=dbname))
)

and i got provided an jdbc code, like this:

Code: Select all

jdbc:oracle:[email protected]//xxx-x.xxxxxx.com:1530/myname

.

I never worked with Oracle Database before, so i have no idea. I tried some reserach but only found informations about

Code: Select all

oci_connect

but i think this is not the right for me.

Can u help me to build the connection please.

Thank you mates!

[Michalio]

Try to use PDO:
http://www.learn-coding.today/php_pdo_oracle.php

[webstarter7]

i cannot get the connection, dont know whats the problem. I dont get any errors

[webstarter7]

So i get

Code: Select all

could not find driver

.
Can u help me with the problem?

[Michalio]

on windows you need to find php.ini file and find that line:

Code: Select all

;extension=php_pdo_oci.dll

and remove the semicolon
on linux try to run:

Code: Select all

sudo apt-get install php php-dev php-pear php-cli libaio1
sudo pecl install pdo

after changes you need to restart php-fpm or http server (like apache2)