問題描述

//1:定義每條多少頁$page=4;//2:獲取數(shù)據(jù)總條數(shù)$len=sqlsrv_num_rows($result);//3:得到總頁數(shù)$prgeall=(int)ceil($len/$page);//4:獲取當(dāng)前頁$dpage=$_GET['page']?? 1;//5:處理上一頁$prepage=$dpage-1<=1?1:($dpage-1);//6:處理下一頁$nextpage=$dpage +1>=$prgeall ? $prgeall:($dpage+1);//$num=($dpage-1)*$page;//7:數(shù)據(jù)處理//mssql_data_seek($result,($dpage-1)*$page);//$offset=($dpage-1)*$page;//$start = $offset;//$pagesize = $page;//$sqls = "select top $pagesize o.*from ($result) as o where id not in(select top $start id from ($result) as oo order by id asc) order by id asc" ;//$result=array_slice($result,$num,$page,true);

問題解答

你如果當(dāng)前$_GET['page']取不到值，那就要看看你前端頁面有沒有傳入page這個(gè)值

數(shù)據(jù)庫用得MSSQL