当前位置:首页 > 数据库 > 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."
"; ?>

www.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...


【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!

相关教程推荐

其他课程推荐