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

怪我咯
Release: 2023-03-13 11:34:01
Original
2547 people have browsed it

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)))");
Copy after login

2.

The code is as follows:

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

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;"
Copy after login

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;"
Copy after login

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>";   
}
Copy after login

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 )
Copy after login

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); 
?>
Copy after login

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"; 
?>
Copy after login
rrree

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template