JqGrid on Codeigniter
Lately I’m developing a portal , using codeigniter as framework, and jqgrid as view grid,,
It’s so great and maximize the lookability of my site.
Later I’ll describe more about how to things…
antonrifco \’s memoir
— psych —
antonrifco \'s memoir 
hi, maybe doy you know how make the SEARCH works?
I’m having problems with that, thanks
my code is working too for searching…
perhaps I can help you if you show here your html / script code…
Good. keep it up
jangan lupa dokumentasi n share ke kita2 yah
Hi,
perhaps you can help me with jqgrid and Codeigniter.
I have somethings like this but i have no data in my grid ?
json is ok in phpinfo().
Have you an idea?
Thanks
$.jgrid.no_legacy_api = true;
$.jgrid.useJSON = true;
jQuery(document).ready(function(){
jQuery(“#list”).jqGrid({
url:’http://192.168.0.10/main/index.php/m1/user_list/index’,
datatype: ‘json’,
colNames:[‘Id’,’LastName’, ‘FirstName’,’Phone’,’Mail’,’Login’],
colModel :[
{name:’Id’, index:’Id’, width:55},
{name:’LastName’, index:’LastName’, width:90},
{name:’FirstName’, index:’FirstName’, width:80, align:’right’},
{name:’Phone’, index:’Phone’, width:80, align:’right’},
{name:’Mail’, index:’Mail’, width:80, align:’right’},
{name:’Login’, index:’Login’, width:80, align:’right’}
],
pager: ‘#pager’,
rowNum:10,
rowList:[10,20,30],
sortname: ‘Id’,
sortorder: ‘desc’,
viewrecords: true,
caption: ‘My first grid’
});
jQuery(“#list”).jqGrid(‘navGrid’,’#pager’,{edit:false,add:false,del:false});
});
total = “2”;
$responce->page = “1”;
$responce->records = “20”;
$i=0;
$query = $this->db->query(‘SELECT Id, LastName, FirstName, Phone, Mail, Login FROM user WHERE Available = 1 ORDER BY LastName, FirstName’);
foreach ($query->result() as $row)
{
$responce->rows[$i][‘id’]=$row->Id;
$responce->rows[$i][‘cell’]=array($row->Id,$row->LastName,$row->FirstName,$row->Phone,$row->Mail,$row->Login);
$i++;
}
echo json_encode($responce);
?>
Hi guys maybe you can try this codeigniter library for the jqgrid implementation, configurations are done in php it can support basic crud and search functionality. heres the blog
http://blog.markmirandilla.com/2011/09/04/codeigniter-jqgrid-library/