'keyset' ));
if($data == true){$total_records=sqlsrv_num_rows($data);}else{$total_records=0;}//总行数
$total_page=ceil($total_records/$page_size); //总页数
//避免page小于0或大于总页数
$page=$page<=0?1:$page;
$page=$page>$total_page?$total_page:$page;
//计算开始和结束行数
$pageStart = ($page-1)*$page_size;
$pageEnd = $pageStart+$page_size;
$sqlPage = " where sqlData.n > $pageStart and sqlData.n <= $pageEnd " ;
$sql = "select * $Additional_sql from ($Result_sql) sqlData ".$sqlPage." order by sqlData.n" ;
$data = sqlsrv_query($conn,$sql);
if($data == true){
if (sqlsrv_rows_affected($data)==0) {
$SystemMessageType=2;
$SystemMessageTXT="数据库中相关无数据！";
$y=0;
}
}else{$SystemMessageType=4;$SystemMessageTXT="数据库中相关无数据！";}
?>
=1) {?>
$total_records) {$ShowingMax=$total_records;}
?>
1) {?>
-
« 上页";
}else{
echo "
- « 上页 "; } $acc4=0; for($i=1;$i<=$total_page;$i++) { if ($i==$page) {echo "
- $i ";} elseif ($i<=3 or $i>($total_page-3) ) {echo "
- $i ";} elseif ($acc4==0){echo "
- ... ";$acc4=$i<$page ? 1 : 2;} elseif ($acc4==1 and $i>$page+3){echo "
- ... ";$acc4=2;} elseif ($acc4==1 and $i>=$page-3){echo "
- $i ";} } if ($page>=$total_page) { echo "
- 下页 » "; }else{ echo "
- 下页 » "; } ?>