im trying use jqgrid in zendframework project, im trying fecth values table called utilizadores. in firebug receiving ok message, aswer this:
<br /> <b>warning</b>: creating default object empty value in <b>c:\xampp\htdocs\eulen2\application\controllers\utilizadorescontroller.php</b> on line <b>51</b><br /> {"page":"1","total":1,"records":1,"rows":[{"id":"1","cell":["hugo silva","admin","admin"]}]} the line 51 this:
$responce->page = $page > $total_pages ? $total_pages : $page; here code:
utilizadores controller action list
public function listaction() { // action body if($this->_request->isxmlhttprequest()) { $this->_helper->layout()->disablelayout(); $this->_helper->viewrenderer->setnorender(true); zend_paginator::setdefaultscrollingstyle('sliding'); $page = $this->_getparam('page', 1); $limit = $this->_getparam('rows', 0); $sidx = $this->_getparam('sidx', 1); $sord = $this->_getparam('sord', 0); $totalrows = $this->_getparam('totalrows', false); if($totalrows) $limit = $totalrows; $employeesmodel = new application_model_account(); $filters = !empty($_request['filters']) ? (array) json_decode($_request['filters']) : array(); //$jqgridmodel = new application_model_jqgrid(); $employeesmodelselect = ($_get['_search'] == 'true') ? $jqgridmodel->where($employeesmodel, $filters['rules']) : $employeesmodel->select(); $employeesmodelselect->order("$sidx $sord"); $adapter = new zend_paginator_adapter_dbtableselect($employeesmodelselect); $paginator = new zend_paginator($adapter); $paginator->setcurrentpagenumber($page)->setitemcountperpage($limit); $count = count($employeesmodel->fetchall() ); $total_pages = $count > 0 ? ceil($count / $limit) : 1; $responce->page = $page > $total_pages ? $total_pages : $page; $responce->total = $total_pages; $responce->records = $count; $i = 0; foreach($paginator $item) { $responce->rows[$i]['id'] = $item['id_utilizador']; $responce->rows[$i]['cell'] = array($item['nome'], $item['username'],$item['tipo_utilizador']); $i++; } echo json_encode($responce); } else { $this->_helper->layout()->pagetitle = 'listagem de utilizadores'; $this->_helper->layout()->pagedescription = 'neste seção podes listar todos os utilizadores'; } } in list.phtml have got this:
<script> $(function() { $("#toolbar").jqgrid({ caption:"utilizadores", colnames:['nome', 'apelido','cargo'], colmodel:[ {name:'nome',index:'nome'}, {name:'username',index:'username'}, {name:'tipo_utilizador',index:'tipo_utilizaodr'} ], datatype:"json", height:421, rownumwidth:40, pager:'#ptoolbar', rowlist:[10,20,30], rownum:10, sortname:'id_utilizador', sortorder:'desc', url:'/utilizadores/list/', viewrecords:true, width:740 }); $("#toolbar").jqgrid('navgrid','#ptoolbar',{del:false,add:false,edit:false,search:false}); $("#toolbar").jqgrid('filtertoolbar',{stringresult:true,searchonenter:false}); }); </script> and account model
class application_model_account extends zend_db_table { protected $_name = 'utilizadores'; } the connection db working fine, because ive got login form, , can acess according field existent on table "utilizadores".
i have tried substitute code return xml instead of json samething happens...
$responce not defined before used it, why warning.
try adding
$responce = new stdclass(); just before $responce->page ...
Comments
Post a Comment