PHP + Apache + Oracle Installation

Install Apache

./Configure -- prefix =/opt/apache2 -- enable-module = so

Compile PHP

. /Configure -- prefix =/myhome/php-5 -- With-Gd -- With-JPEG-Dir =/usr -- With-zlib-Dir =/usr/local --- PNG-Dir =/usr/local \
-- With-apxs2 =/myhome/apache2/bin/apxs -- with-oci8 =/Oracle/product/10.2.0/db_7

Modify the Apache configuration file httpd. conf

Code

  Loadmodule php5_module modules  /  Libphp5.so
  <  Ifmodule mod_php5.c >  
Addtype Application  /  X  -  Httpd  -  PHP. php
Php_admin_flag magic_quotes_gpc off
Php_admin_flag magic_quotes_runtime off
  </  Ifmodule  >  
 

 

 

Test Database Connection
 

Code

<? PHP
  $ SQL  =  "  Select * From wh_hosts  "  ;
$ Db_conn  =  Oci_connect (  "Sys  "  ,  "Tiger  "  ,  "Sid "  );
$ Stmt  =  Ociparse ($ db_conn, $ SQL );
Ociexecute ($ stmt );
$ Nrows  =  Oci_fetch_all ($ stmt, $ results );
Oci_free_statement ($ stmt );
Oci_close ($ db_conn ); ?>