Php simple paging principle and paging code example

Php simple paging principle and paging code example

/******* Paging principle *********/ // The number of records per page $ Page_size = 3; $ SQL = "select * from message "; $ Result = mysql_query ($ SQL ); // The total number of records $ Num = mysql_num_rows ($ result ); // Calculate the total number of pages If ($ num <= $ page_size) {$ page_count = 1 ;} If ($ num % $ page_size) {$ page_count = intval ($ num/$ page_size) + 1 ;} If ($ num % $ page_size = 0) {$ page_count = $ num/$ page_size ;} If (isset ($ _ GET ['Page']) { $ Page = intval ($ _ GET ['Page']); } Else { $ Page = 1; } $ SQL _page = "select * from message limit". ($ page-1) * $ page_size. ", $ page_size "; $ Do = mysql_query ($ SQL _page ); While ($ re = mysql_fetch_object ($ do )){ Echo 'anything you want to write '; } If ($ page <> 1 ){ Echo 'homepage '; Echo 'previous page '; } If ($ page <> $ page_count ){ Echo' '; Echo 'next page '; Echo 'Last overnight '; Echo' '; }