一个ORACLE分页程序

一个ORACLE分页程序

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