EasyUI服务端分页

来源：互联网发布：淘宝代运营销售话术编辑：程序博客网时间：2024/05/29 14:27

//jQuery页面

var options={};options.rownumbers="true";options.pagination="true";options.pageSize=20;//默认20条记录每页options.pageList=[10,20,50];var words="select * from table";getData(words,1,options.pageSize);function getData(words,page,rows){    $.post('deal.php',{words:words,pageNumber:page,pageSize:rows},function(d){        var jsonObj=eval('('+d+')');//对象化        options.pageNumber = page;        options.pageSize = rows;        $('#dg').datagrid(options);        $('#dg').datagrid("loadData",jsonObj);//Datagrid绑定数据        //分页操作        $('#dg').datagrid('getPager').pagination({            onSelectPage:function(pageNumber,pageSize){                options.pageNumber = pageNumber;                options.pageSize = pageSize;                getData(words,pageNumber,pageSize);            }        })    })}

//PHP页面

    $con = mysql_connect("localhost","root","");    if (!$con)    {        die('Could not connect: ' . mysql_error());    }    mysql_select_db("mysql", $con);    mysql_query("SET NAMES 'UTF8'");//防止乱码    mysql_query("SET CHARACTER SET UTF8");    mysql_query("SET CHARACTER_SET_RESULTS=UTF8'");    $words=$_POST["words"];    $i=mysql_num_rows(mysql_query($words));//获取结果集中行数    $stratIndex=$_POST["pageSize"]*($_POST["pageNumber"]-1);//计算开始索引值    $words.=" limit ".$stratIndex.",".$_POST["pageSize"];//限定记录    $flag=mysql_query($words);    if($flag!=false){        $result="";        while ($row=mysql_fetch_array($flag,MYSQL_ASSOC)) {            $result[]=$row;        }        echo '{"total":'.$i.',"rows":'.json_encode($result).'}';    }    else        echo "Error";

0 0