php+mssql 分页,php+mssql 分页处理

No

Department Code

Department Name

Department Description

Action

require('connectDB.php');

$depcode = $_POST['departmentCode'];

//echo $depcode."
";

$depname = $_POST['departmentName'];

//echo $depname."
";

$depquery = "SELECT * FROM TBLDEPARTMENT WHERE 1>0 ";

if($depcode ){

$depquery .=" AND DEPTCODE = '{$depcode}' ";

}

if($depname ){

$depquery .=" AND DEPTNAME = '{$depname }' ";

}

// echo "sql---{$depquery}" ;

$ntt_result_info = MSSQL_QUERY($depquery);

/*分页处理开始*/

$ntt_row_counts=mssql_num_rows($ntt_result_info); //查询出数据集的行数

if($ntt_row_counts!=0) //如果查询出数据集不为空

{

$ntt_perpagerows=2; //设定每页行数

$ntt_page = $_GET['page']; //当前现实页数

if(!$ntt_page||$ntt_page<1)

{

$ntt_page=1;

}

$ntt_max_page=ceil($ntt_row_counts/$ntt_perpagerows); //查询出的数据集最多能分得页数

//echo $row_counts;

$ntt_result_index=($ntt_page-1)*$ntt_perpagerows; //当前页要显示的第一条数据的index

//echo "index---{$result_index}";

mssql_data_seek($ntt_result_info,$ntt_result_index);//设定在数据集的开始index设定成当前页要显示的第一条数据

$ntt_count=1; //计数器

while($ntt_row_info=mssql_fetch_array($ntt_result_info))//开始从设定好的index开始循环

{

if($ntt_count>$ntt_perpagerows)//将要输出数据的行数大于每页行数时跳出循环

{

break;

}

?>

<?php echo $ntt_perpagerows*($ntt_page-1)+$ntt_count; ?><?php echo $ntt_row_info[DEPTCODE]; ?><?php echo $ntt_row_info[DEPTNAME]; ?><?php echo $ntt_row_info[DEPTDESC]; ?>

$ntt_count++; //计数器累加

}

}else{ //如果查询出数据集为空

$ntt_page=1;

$ntt_max_page=0;

}

mssql_free_result($ntt_result_info);

mssql_close();

?>

class='xyh_short_btn'>

class='xyh_short_btn'>

=$ntt_max_page){echo "disabled";} ?> class='xyh_short_btn'>

=$ntt_max_page){echo "disabled";} ?> class='xyh_short_btn'>