Php paging principle, php Paging
<? Php // contains the File include "conn. php "; // variable related to paging $ pagesize = 5; // display the number of entries per page // obtain the page parameter if (empty ($ _ GET ["page"]) passed in the address bar) {$ page = 1; $ startrow = 0;} else {$ page = (int) $ _ GET ["page"]; $ startrow = ($ page-1) * $ pagesize ;} // construct the query SQL statement $ SQL = "SELECT * FROM 007_news"; // execute the SQL statement $ result = mysql_query ($ SQL ); // total number of records and total number of pages $ records = mysql_num_rows ($ result); // total number of records $ pages = ceil ($ records/$ pagesize ); // total number of pages // SQL statement for paging construction $ SQL = "SELE CT * FROM 007_news order by orderby ASC, id desc limit $ startrow, $ pagesize "; // execute the SQL statement $ result = mysql_query ($ SQL);?> <! DOCTYPE html>