一個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."
"; ?>

http://www.bkjia.com/PHPjc/531928.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/531928.htmlTechArticlePaging Test PK ID ; echo Field 1 ; echo Field 2 ; echo Field 3 ; echo Row No ; echo ; if ($num_rows != 0) { // Parse the SQL string OCIExecute($rs); // get number of columns for us...

