Php+mysql database query Pagination code example

/* * Php+mysql Pagination Code * */ $SQL _tabl= "ABC"; Table name $where _name= "ID > 10";//Query criteria $perpagenum = 3; Display quantity per page $total = Mysql_fetch_array (mysql_query ("SELECT count (*) as Count from $SQL _tabl WHERE (". @ $where _name. ")); $sql _count= $total [' count ']; Gets the number of data bars returned Unset ($total); Unregister variable $total Calculates an inaccurate number of pages $page_all_num_f is an integer, $page _all_num_t is the exact value (possibly fractional) $page _all_num_f=round ($page _all_num_t= $sql _count/$perpagenum, 0); if ($page _all_num_f< $page _all_num_t)//Calculate the correct number of pages $page _all_num= $page _all_num_f+1; Else $page _all_num= $page _all_num_f; if (Is_numeric (@$_get[' P ')) && @$_get[' P ']>1 && @$_get[' P ']<= $page _all_num)//Get Get parameters to determine the current page $page _num=$_get[' P ']; Else $page _num=1; $sql _s_num= ($page _num-1) * $perpagenum; Number of data bars to start calculation $sql _p= "LIMIT". $sql _s_num. ",". $perpagenum; Generate database Query code $result = mysql_query ("select * from $SQL _tabl WHERE (". @ $where _name. "). $sql _p); Querying data while ($row =mysql_fetch_array ($result)) {//main loop Output content } Paging button for ($i =1; $i <= $page _all_num; $i + +) { if (@$_get[name]!=null)//page other GET parameters $p _n= "Name=". @$_get[name]. " & "; Else $p _n=null; if ($page _num== $i)//Emphasis of the current page number $p _flag= "class=\" flag\ ""; Else $p _flag=null; echo "$i \ n"; } ?> Copy Code Recommended reading: PHP and Ajax No Refresh paging code PHP article pagination Implementation code PHP Limit Paging (paging) code PHP Paging class with a variety of paging methods Previous page and next page of PHP page code PHP pagination code for the first 10 pages and the next 10 pages Example of a simple PHP page-out code A nice code for the PHP paging class A paging function: previous page next page A handy PHP paging class PHP Long article pagination code A useful PHP page-out class Fast PHP page-out class

