ExtJs 初学——php分页

分页搞了两三天，终于弄好啦！送给初学者，避免走弯路啊！

userList.html

var itemsPerPage =2;//分页大小
    var store = new Ext.data.Store({
		autoLoad: {start: 0, limit: itemsPerPage},
		fields:['uid','pwd'],
		pageSize: itemsPerPage, //设置分页大小
		proxy :new Ext.data.HttpProxy({ 
			method: 'GET',
			url: 'sqlData.php',
			reader : {
					type:'json',
					root : 'results',//需和sqlData.php一致
					totalProperty: 'total'//需和sqlData.php一致

			}
		})
    });

sqData.php

 <?php

$link=mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS);
$connect = mysql_select_db(app_gdmc12580,$link);


$sql_count = "SELECT * FROM `managers`";
$rs_count = mysql_query($sql_count);
$rows = mysql_num_rows($rs_count);

$start = isset($_GET['start']) ? $_GET['start']:0;//开始ID  GET
$limit = isset($_GET['limit']) ? $_GET['limit']:10;//每页条数

$sql_query = "SELECT uid,pwd FROM `managers` limit {$start},{$limit}";  

$data = array(); 
$result=mysql_query($sql_query);
    
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
	$data[]=$row;
}
echo '{"total":"'.$rows.'","results":'.json_encode($data).'}'; 
?>