php 分页php分页代码
public function rangeIndex(){
$start= explode(".",$_GET['startIp']);
$startIp=$start[count($start)-1];
$stop= explode(".",$_GET['stopIp']);
$stopIp=$stop[count($stop)-1];
$range= explode(".",$_GET['stopIp']);
$rangIp=$range[count($stop)-2];
import('ORG.Util.Page');//导入分页类
//$m=M("Machine_info");
$m=M();
//$where[substring_index("ip",'.',-1)] = array(array('gt',$startIp),array('lt',$stopIp));
$countNum = $m->query("select count(*) from machine_info where substring_index(ip,'.',-1)>$startIp and substring_index(ip,'.',-1)<$stopIp and substring_index(substring_index(ip,'.',-2),'.',1) =$rangIp");
//$count = $m->where($where)->select();
$count = (int)$countNum[0]["count(*)"];
$page=new Page($count,15);//实例化分页类 传入总记录数和每页显示的记录数
$show=$page->show();//分页显示输出
$result=$m->query("select * from machine_info where substring_index(ip,'.',-1)>$startIp and substring_index(ip,'.',-1)<$stopIp and substring_index(substring_index(ip,'.',-2),'.',1) =$rangIp limit ".$page->firstRow.",".$page->listRows);
//$result = $m->where($where)->limit($page->firstRow.','.$page->listRows)->select();
$this->assign('result',$result);
$this->assign('show',$show);
$this->assign('startIp',$_GET['startIp']);
$this->assign('stopIp',$_GET['stopIp']);
$this->display();
}