PHP connectivity to Oracle DB
I am currently trying to write a PHP script to connect to an Oracle database. The reason I am using PHP is because I need to connect the Oracle database with my current CRM system, written in PHP/MySQL.
The PHP is hosted on 1&1 hosting, which is an exter开发者_运维技巧nal server. I read that I need to enable the extension php_oci8.dll to connect using oci_connect(), but I cannot do so since I do not have root privileges. Did a search, and couldn't find the DLL either.
Is there any other way around this? Any help greatly appreciated, please let me know if you need more information. Thanks!
1) 1&1 will have Linux, so you will have to use linux names for extensions. In this case name of extension will be php_oci8.so
2) create the php.ini
in root directory and put the following line
extension=php_oci8.so
3) create a simple php script with one line to test if it works:
<?php phpinfo(); ?>
Please note -- 1&1 may physically not have that file available on their server (or some additional libraries that may be required by that extension). If the problem just with absence of .so file, then you can provide your own version of it (upload it and put the correct full path to the extension in php.ini)
Useful links: 1) http://faq.1and1.com/scripting_languages_supported/php/6.html 2) http://faq.1and1.com/scripting_languages_supported/php/8.html
According to your problem. first thing is that linux doesn't support .dll file. You have to install OCI8 extension module in your Apache server. Follow this link to get easy solution.
http://coffeewithcode.com/2012/09/how-to-install-oracle-libraries-for-php5-on-ubuntu-server/
Please check that there are no blank spaces. 1. put the php.ini and the php_oci8.so in the same folder as where you are going to run the php program that is going to access the database. 2. php.ini contents should look like:
extesion=./php_oci8.so
精彩评论