文章詳情頁(yè)

一個(gè)ORACLE分頁(yè)程序，挺實(shí)用的.

瀏覽：5日期：2023-10-26 13:36:45

<!DOCTYPE HTML PUBLIC "http://W3C//DTD HTML 3.2 Final//EN"><HTML><HEAD><TITLE>Paging Test</TITLE><META NAME="Generator" CONTENT="TextPad 4.0"><META NAME="Author" CONTENT="?"><META NAME="Keywords" CONTENT="?"><META NAME="Description" CONTENT="?"></HEAD><BODY BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#FF0000" VLINK="#800000" ALINK="#FF00FF" BACKGROUND="?"><?php// How to split the result into pages, like 'limits' in MySQL?// ===========================================================// Tutorial by Neil Craig (neilc@netactive.co.za)// Date: 2001-06-05// With this example, I will explain paging of database queries where the// result is more than the developer want to print to the page, but wish to // split the result into seperate pages.// The table "SAMPLE_TABLE" accessed in this tutorial has 4 fields:// PK_ID, FIELD1, FIELD2 and FIELD3. The types don't matter but you should// define a primary key on the PK_ID field.$display_rows = 5;;;;;;// The rows that should be display at a time. You can;;;;;;;// modify this if you like.// Connect to the Oracle databaseputenv("ORACLE_SID=purk");putenv("ORACLE_HOME=/export/oracle8i");putenv("TNS_ADMIN=$ORACLE_HOME/network/admin");$OracleDBConn = OCILogon("purk","purk","lengana.world");// This query counts the records$sql_count = "SELECT COUNT(*) FROM SAMPLE_TABLE";// Parse the SQL string & execute it$row_count=OCIParse($OracleDBConn, $sql_count)OCIExecute($row_count);// From the parsed & executed query, we get the amount of records found.// I'm not storing this result into a session variable because it allows for// new records to be shown as it is entered by another user while the result// is printed.if (OCIFetch($row_count)) {;;;;$num_rows = OCIResult($row_count,1);} else {;;;;$num_rows = 0;// If no record was found}// Free the resources that were used for this queryOCIFreeStatement($row_count);// We need to prepare the query that will print the results as a page. I will // explain the query to you in detail.// If no page was specified in the url (ex. http://mysite.com/result.php?page=2),// set it to page 1.if (empty($page) || $page == 0) {;;;;$page = 1;}// The start range from where the results should be printed$start_range = (($page - 1) * $display_rows) + 1;// The end range to where the results should be printed$end_range = $page * $display_rows;// The main query. It consists of 3 "SELECT" statements nested into each// other. The center query is the query you would normally use to return the// records you want. Do you ordering and "WHERE" clauses in this statement.// We select the rows to limit our results but because the row numbers are// assigned to the rows before any ordering is done, lets the code print the// result unsorted.// The second nested "SELECTED" assigns the new row numbers to the result// for us to select from.$sql = "SELECT PK_ID, FIELD1, FIELD2, FIELD3, ROW_NO FROM (SELECT PK_ID, ";$sql .= "FIELD1, FIELD2, FIELD3, ROWNUM ROW_NO FROM (SELECT PK_ID, FIELD1, ";$sql .= "FIELD2, FIELD3 FROM SAMPLE_TABLE ORDER BY FIELD3)) WHERE ROW_NO BETWEEN ";$sql .= $start_range." AND ".$end_range;// start results formattingecho "<table border='1' cellspacing='1' cellpadding='2' align='center'>";echo "<tr bgcolor='#666666'>"echo "<td>PK ID</td>";echo "<td>Field 1</td>";echo "<td>Field 2</td>";echo "<td>Field 3</td>";echo "<td>Row No</td>";echo "</tr>";if ($num_rows != 0) {;;;;// Parse the SQL string & execute it;;;;$rs=OCIParse($OracleDBConn, $sql);;;;OCIExecute($rs);;;;;;;;;// get number of columns for use later;;;;$num_columns = OCINumCols($rs);;;;;;;;;while (OCIFetch($rs)){echo "<tr>";for ($i = 1; $i < ($num_columns + 1); $i++) {;;;;$column_value = OCIResult($rs,$i);;;;;echo "<TD>$column_value</TD>";}echo "</tr>";;;;;}} else {;;;;// Print a message stating that no records was found;;;;echo "<tr><td align=center>Sorry! No records was found</td></tr>";}// Close the tableecho "</TABLE>";// free resources and close connectionOCIFreeStatement($rs);OCILogoff($OracleDBConn);?><div align=center><?php// Here we will print the links to the other pages// Calculating the amount of pagesif ($num_rows % $display_rows == 0) {;;;;$total_pages = $num_rows / $display_rows;} else {;;;;$total_pages = ($num_rows / $display_rows) + 1;;;;;settype($total_pages, integer); // Rounding the variable}// If this is not the first page print a link to the previous pageif ($page != 1) {;;;;echo "<a href='http://www.hdgsjgj.cn/bcjs/".$PHP_SELF."?page=".($page - 1)."'>Previous</a>";}// Now we can print the links to the other pagesfor ($i = 1; $i <= $total_pages;;;$i++) {;;;;if ($page == $i){// Don't print the link to the current pageecho " ".$i;;;;;} else {//Print the links to the other pagesecho " <a href='http://www.hdgsjgj.cn/bcjs/".$PHP_SELF."?page=".$i."'>".$i."</a>";;;;;}}// If this is not the last page print a link to the next pageif ($page < $total_pages) {;;;;echo " <a href='http://www.hdgsjgj.cn/bcjs/".$PHP_SELF."?page=".($page + 1)."'>Next</a>";}?></div><?php// I'm just adding this section to print some of the variables for extra info// and some debuggingecho "Total pages: ".$total_pages."";echo "Number of records: ".$num_rows."";echo "The SQL Query is: ".$sql."";?></BODY></HTML>

上一條：一個(gè)odbc連mssql分頁(yè)的類下一條：MySQL通用查詢程序

排行榜

					
					關(guān)于Oracle數(shù)據(jù)庫(kù)中的N層認(rèn)證具體介紹
MySQL找出未提交事務(wù)的SQL實(shí)例淺析
MySQL存儲(chǔ)過(guò)程例子（包含事務(wù)、參數(shù)、嵌套調(diào)用、游標(biāo)循環(huán)等）
DB2數(shù)據(jù)庫(kù)安全性全面介紹（1）
Mysql命令行連接遠(yuǎn)程/本地?cái)?shù)據(jù)庫(kù)詳解
分析DB2活動(dòng)日志滿的原因及解決DB2日志滿方法與避免方案
影響SQL server性能的關(guān)鍵三個(gè)方面 
淺談MySQL之select優(yōu)化方案
MySQL數(shù)據(jù)庫(kù)配置優(yōu)化的方案
推薦精華文章：Oracle數(shù)據(jù)庫(kù)高手調(diào)優(yōu)秘密
SQL語(yǔ)句如何實(shí)現(xiàn)超簡(jiǎn)單的多表查詢
				

熱門標(biāo)簽

电脑知识|欧美黑人一区二区三区|软件|欧美黑人一级爽快片淫片高清|系统|欧美黑人狂野猛交老妇|数据库|服务器|编程开发|网络运营|知识问答|技术教程文章 - 好吧啦网

一個(gè)ORACLE分頁(yè)程序，挺實(shí)用的.