How to connect php to oracle database and query data to implement paging

This article mainly introduces the method of connecting PHP to Oracle database and querying data. It analyzes the usage skills of PHP to operate Oracle database in detail in the form of examples. It has certain reference value and is needed. Friends can refer to

. The example in this article describes the method of connecting PHP to the Oracle database and querying data. Share it with everyone for your reference. The specific analysis is as follows:

php has powerful functions. It can not only support mysql, mssql, and mysqli. We can also connect with oracle data. To make php support oracle, it is very simple. We only need to add; in php.ini; extention = php_oci8.dll, just remove the semicolon.

php supports oracle connectionfunction

Configuration in the php.ini file, remove; extension = php_oci8.dll, Just remove the semicolon in front and restart apache. If that doesn't work, let's copy the php_oci8.dll in the php directory to system32 of the windows system.

Establish a link to the oracle database, the code is as follows:

1.

The code is as follows:

$conn = oci_connect('username','password',"(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST=192.168.1.100)(PORT = 1521))(CONNECT_DATA =(SID=test)))");

2.

The code is as follows:

$conn = oci_connect('username','password','192.168.1.100/test');

3.Oracle connection method:

The code is as follows:

set adocon=Server.Createobject("adodb.connection") 
adocon.open"Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"

4.Oracle OLE DB connection method:

The code is as follows:

set adocon=Server.Createobject("adodb.connection") 
adocon.open"Provider=OraOLEDB.Oracle;data source=dbname;user id=admin;password=pass;"

Sometimes If one method doesn't work, use the second one. The parameters are user name, password, oracle service address, where test is the service name, and the code is as follows:

The code is as follows:

$sql = "select * from table_exmaple" 
$ora_test = oci_parse($conn,$sql);  //编译sql语句 
oci_execute($ora_test,OCI_DEFAULT);  //执行 
while($r=oci_fetch_row($ora_test))  //取回结果 
{ 
echo $ora_test[0]; 
echo "<BR>";   
}

Look at a complete example. If the PHP version is >5.0, then use the following function:

The code is as follows:

oci_connect ( username, password , dbname )

Example, the code is as follows:

The code is as follows:

<?php 
$conn = oci_connect(&#39;hr&#39;, &#39;hr&#39;, &#39;orcl&#39;); // 建立连接 
if (!$conn) { 
$e = oci_error(); 
print htmlentities($e[&#39;message&#39;]); 
exit; 
} 
$query = &#39;SELECT * FROM DEPARTMENTS&#39;; // 查询语句 
$stid = oci_parse($conn, $query); // 配置SQL语句，准备执行 
if (!$stid) { 
$e = oci_error($conn); 
print htmlentities($e[&#39;message&#39;]); 
exit; 
} 
$r = oci_execute($stid, OCI_DEFAULT); // 执行SQL。OCI_DEFAULT表示不要自动commit 
if(!$r) { 
$e = oci_error($stid); 
echo htmlentities($e[&#39;message&#39;]); 
exit; 
} 
// 打印执行结果 
print &#39;<table border="1">&#39;; 
while($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) { 
print &#39;<tr>&#39;; 
foreach($row as $item) { 
print &#39;<td>&#39;.($item?htmlentities($item):&#39; &#39;).&#39;</td>&#39;; 
} 
print &#39;</tr>&#39;; 
} 
print &#39;</table>&#39;; 
oci_close($conn); 
?>

The following is a paging example program. It may seem complicated, but in fact, as long as you use it, you will find that everything is so simple.

example. php

<?php 
$conn = ociplogon("test","123456","test123"); 
include_once "pager.inc.php"; 
?>

The above is the detailed content of How to connect php to oracle database and query data to implement paging. For more information, please follow other related articles on the PHP Chinese website!