CakePHP + jqGrid整合的例子
html:
|
1 2 3 |
Html代码 <table id="list47"></table> <div id="plist47"></div> |
js:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
Js代码 $(document).ready(function(){ jQuery("#list47").jqGrid({ //data: mydata, url:"/sites/ajaxListAll?XDEBUG_SESSION_START=php_debug", datatype: "json", height: 150, rowNum: 10, rowList: [10,20,30], colNames:['ID', '欢迎语句','显示订阅','显示联系方式','网站名称','网站邮箱','联系邮箱','电话','描述'], colModel:[ {name:'site_id',index:'site_id', width:100}, {name:'wellcome_title',index:'wellcome_title', width:80}, {name:'is_subscription',index:'is_subscription', width:80}, {name:'is_contact',index:'is_contact', width:80}, {name:'name',index:'name', width:80}, {name:'site_email',index:'site_email', width:80}, {name:'site_contact_email',index:'site_contact_email', width:80}, {name:'tel',index:'tel', width:80}, {name:'descript',index:'descript', width:150} ], pager: "#plist47", viewrecords: true, jsonReader: { repeatitems: false }, loadComplete:function(){ }, caption: "Manipulating Array Data" }); }); |
Controller:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
Php代码 <?php class SitesController extends AppController { public $name = "Site"; public function ajaxListAll() { $list=$this->Site->find("all"); $data=array(); for($i=0; $i<count($list); $i++){ $data[$i]['site_id'] = $list[$i]['Site']['site_id']; $data[$i]['wellcome_title'] = $list[$i]['Site']['wellcome_title']; $data[$i]['is_subscription'] = $list[$i]['Site']['is_subscription']; $data[$i]['is_contact'] = $list[$i]['Site']['is_contact']; $data[$i]['name'] = $list[$i]['Site']['name']; $data[$i]['site_email'] = $list[$i]['Site']['site_email']; $data[$i]['site_contact_email'] = $list[$i]['Site']['site_contact_email']; $data[$i]['tel'] = $list[$i]['Site']['tel']; $data[$i]['descript'] = $list[$i]['Site']['descript']; } if ($this->request->is('get')) { //这里怎么判断。可能根据情况，但是我使用这样判断是没问题的。 $result = array( 'rows' => $data, 'page' => 1, 'total' => 2, 'records' =>1 ); return new CakeResponse(array('body' => json_encode($result), 'status' => 200)); } } } ?> |
