php oci8 connect to EDB postgres

Highlighted
Gold Adventurer

php oci8 connect to EDB postgres

Hi all.

Can i use oci8 to connect from PHP to EDB Postgres, through ocilib the documentation link https://www.enterprisedb.com/docs/en/10.0/oci/toc.html

 

 

for example  i need use the same connection from PHP, OCI8 to connect to EDB Postgres

like this image:

 

https://www.enterprisedb.com/docs/en/10.0/oci/EDB_Postgres_Advanced_Server_OCI_Connector_Guide.1.05....

 

is posible?

 

 

regards

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

3 REPLIES 3
Highlighted
EDB Team Member

Re: php oci8 connect to EDB postgres

Hi  asotolongo,

 

We are looking into the reported request.

We will update you soon with the progress.

 

Kindly let us know in case of any concerns or issues.

Regards,
Dhananjay
Highlighted
EDB Team Member

Re: php oci8 connect to EDB postgres

Hello asotolongo,

 

Yes, We use oci8 to connect from PHP to EDB Postgres.

Below are the Steps for connecting PHP application to EPAS using OCI connector :

  1. yum install php php-devel php-pear php-pgsql
  2. install edb connectors: ./edb-connectors-9.6.0.3-2-linux-x64.run
  3. install Oracle instant client 11.2 + SDK
  4. pecl install oci8-2.0.12
  5. in /etc/php.ini add(if necessary) extension=oci8.so and extension=pgsql.so
  6. ldd /usr/lib64/php/modules/oci8.so will list all libraries
  7. change libraries above to edb libraries in /opt/edb/connectors
  8. run simple php script to connect to EPAS database:
  9. cat e.php
    <?php
    error_reporting(E_ALL|E_STRICT);
    ini_set('display_errors', 'On');
    oci_internal_debug(1);
    $conn = oci_connect('enterprisedb', 'password', '//epas96:5444/edb') ;
    var_dump($conn);
    oci_close($conn);
    ?>
  10. php e.php


Also, Please find the attached readme file for the more insight.

Hope this helps!

Regards,
Dhananjay
Highlighted
Gold Adventurer

Re: php oci8 connect to EDB postgres

hi @dhananjayjejur, thanks

we wil check your notes and tell you the feedback

 

Regards

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks