php7 sybase,sybase分页查询（自己用，不适合其它人）

$fcc172= new FC_SQL_ALL("172","BL");

$sql = "select dsphh,dspmc,dsppp,dspgg,dlsj from sp_xxhz where dshh='900002' and isvalid='01' and djyzt='01' and xjbz='01'";

if(isset($this->queryString['type'])){

$sql.= " and dsphh ='".$keywords."' ";

}else{

$sql.= " and dkey like '%".$keywords."%' ";

}

$sql.= ' order by dsppp';

$totalQuery = new FC_SQL_ALL('172','BL');

$totalQuery->query($sql);

$data['total'] = $totalQuery->num_rows();

$totalQuery->close();

$fcc172->cursor_query("xxxx",$sql,$pagesize,$page);

while($fcc172->next_record()){

$data['rows'][] = array(

'dsphh'     =>$fcc172->f(0),

'dspmc'     =>iconv('gb2312','utf-8',$fcc172->f(1)),

'dsppp'     =>iconv('gb2312','utf-8',$fcc172->f(2)),

'dspgg'     =>iconv('gb2312','utf-8',$fcc172->f(3)),

'dlsj'      =>$fcc172->fnum(4)

);

}

$fcc172->cursor_close("xxxx");