程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 網頁編程 >> PHP編程 >> 關於PHP編程 >> 一個ORACLE分頁程序

一個ORACLE分頁程序

編輯:關於PHP編程

Paging Test PK ID"; echo "Field 1"; echo "Field 2"; echo "Field 3"; echo "Row No"; echo ""; 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 ""; for ($i = 1; $i < ($num_columns + 1); $i++) { $column_value = OCIResult($rs,$i); echo "$column_value"; } echo ""; } } else { // Print a message stating that no records was found echo "Sorry! No records was found"; } // Close the table echo ""; // free resources and close connection OCIFreeStatement($rs); OCILogoff($OracleDBConn); ?> Total pages: ".$total_pages."
"; echo "
Number of records: ".$num_rows."
"; echo "
The SQL Query is: ".$sql."
"; ?>

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved