PHP joins Oracle using the OCI function

PHP Connect to Oracle using the OCI function

PHP Connection Visit Oracle is using the OCI function, and the following is a sorted document

1. Installing Apache and PHP Packages

Yum install-y httpd php*

2. Download Oracle Components

oracle-instantclient-basic-10.2.0.4-1.i386.rpm

oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm

oracle-instantclient-devel-10.2.0.4-1.i386.rpm

oracle-instantclient-odbc-10.2.0.4-1.i386.rpm

#rpm-IVH oracle-instantclient* (four components installed on all)

The/usr/lib/oracle/10.2.0.4/client/lib/directory is generated at this time

3. Modify the/etc/ld.so.conf file

#vim/etc/ld.so.conf

Append the following content

/usr/lib/oracle/10.2.0.4/client/lib/

#ldconfig (Execute command)

4. Download the OCI8 component

Http://pecl.php.net/get/oci8-1.4.1.tgz

#tar ZXVF oci8-1.4.1.tgz

5. Editing the OCI8 module

#cd oci8-1.4.1

#phpize (Execute command)

#./configure--with-oci8=instantclient,/usr/lib/oracle/10.2.0.4/client/lib/

#make Install

After success the system will prompt you: Oci8.so has been successfully placed in the/usr/lib/php/modules/directory

6. Modify the php.ini file

#vim/etc/php.ini

Append the following content

Extension=oci8.so

7. Restart Apache Service

Service httpd Restart

8. Use the Phpinfo () function to view

Code Connection Test Oracle Database

2. PHP
6. $ Conn = Oci_connect (' Scott ', ' Oracle ', ' 192.168.12.133/ORCL ');
10. if (! $conn) {
14. $ e = Oci_error ();
18. Print htmlentities ($e [' message ']);
22. Exit
26. }
30. $ Query = ' Select Ename,sal from Scott.emp ' ;
34. $ Stid = Oci_parse ($conn, $query);
36. if (! $stid) {
40. $ e = Oci_error ($conn);
44. Print htmlentities ($e [' message ']);
48. Exit
52. }
56. $ R = Oci_execute ($stid, oci_default);
58. if (! $r) {
62. $ e = Oci_error ($stid);
66. Echo htmlentities ($e [' message ']);
70. Exit
74. }
78. print ' < Table Border="1">";
82. While ($row = oci_fetch_array($stid, Oci_return_nulls)) {
86. print ' < TR > ';
90. foreach ($row as $item) {
94. print ' < TD > '. ($item? Htmlentities ($item): '). ' td>';
98. }
102. print ' tr>';
106. }
110. print ' table>';
114. Oci_close ($conn);
118. ?>

Finally browse the page through the browser

