配合bootstrap的分頁

1. 用搜尋條件處理$where


$where='1';
if ($dist && $schname)
  $where = "sch_dist='$dist' AND sch_name LIKE '%$schname%'";
elseif ($dist && !$schname)
  $where = "sch_dist='$dist'";
elseif ($schname && !$dist)
  $where= "sch_name LIKE '%$schname%'";
else
  $where='1';

2.   $count = rsCount($tn,"$where","*");

3. if ($count==0)  //無資料狀態

4.
   if (isset($_GET['page']))
     $page=intval($_GET['page']);
  else
     $page=0;

5. $list = rsList($tn," $where Limit ".($page*20).",20");

6. $i=$page*20
foreach($list as $var) {
  $i++; //序號
}

7. if ($count>20) {
echo " <div class="panel-footer"> <div class="row"> <div class="col col-xs-8"> <ul class="pagination hidden-xs pull-right"> "; for ($i=$page-5;$i<=$page+5;$i++) { if ($i>=0 and $i<$pages) { if ($i==$page) $tag = "class='active' "; else $tag=''; //class="active" echo " <li tag=""><a cl="" href="https://www.blogger.com/blogger.g?do=list&page={$i}&title={$_GET[" title="">".($i+1)."</a></li> "; } } $prev=$i-1; $next=$i+1; echo " </ul> <ul class="pagination visible-xs pull-right"> <li><a cl="" href="https://www.blogger.com/blogger.g?do=list&page={$prev}&title={$_GET[" title="">«</a></li> <li><a cl="" href="https://www.blogger.com/blogger.g?do=list&page={$next}&title={$_GET[" title="">»</a></li> </ul> </div> </div> </div> ";