jQuery Grid Plugin - jqGrid

Done 🙂

Hope it will help somebody.

Javascript Code

var actionHandlerGrid = "<?php echo WEBSITE_URL ?>admin/contact/grid";

jQuery("#single").jqGrid({
    scrollrows : true,
       url:actionHandlerGrid,
    datatype: "json",
    height: 255, width: 860,
       colNames:['Id','Country Name', 'Area'],
       colModel:[
           {name:'id',index:'id', width:65, sorttype:'int'},
                {name:'country_name',index:'country_name', width:150},
                {name:'area',index:'area', width:100} ],
       rowNum:10,
       rowList:[10,20,30],
       pager: '#psingle',
       sortname: 'country_name',
    viewrecords: true,
    sortorder: "desc",
    caption:"Navigator Example",
    height:150
});
jQuery("#single").jqGrid('navGrid','#psingle',
{del:false,add:false,edit:false}, //options
{height:280,reloadAfterSubmit:false}, // edit options
{}, // add options
{reloadAfterSubmit:false}, // del options
{} // search options
);

Php Code

function gridAction() {

    
    $page = $this->getRequest()->getParam('page');
    $limit = $this->getRequest()->getParam('rows');
    $sidx = $this->getRequest()->getParam('sidx');
    $sord = $this->getRequest()->getParam('sord');
    $totalrowsData = $this->getRequest()->getParam('totalrows');

    if(!$sidx){ $sidx =1; }
    $totalrows = isset($totalrowsData) ? $totalrowsData: false;
    if($totalrows) {
        $limit = $totalrows;
    }

    $objCountry = new Country();
    $count = $objCountry->fetchMyCount();

    if( $count >0 ) {
        $total_pages = ceil($count/$limit);
    } else {
        $total_pages = 0;
    }

    if ($page > $total_pages) $page=$total_pages;
    if ($limit<0) $limit = 0;
    $start = $limit*$page - $limit; // do not put
    if ($start<0) $start = 0;

    
        
    $countries_data =  $objCountry->getRequiredData($start, $limit);

    //$countries_data = $objCountry->fetchAll($objCountry->select()->limit($start, $limit));

    $responce->page = $page; $responce->total = $total_pages; $responce->records = $count;
    $i=0;

    foreach($countries_data as $data) {

        $responce->rows[$i]['id']=$data['id'];
            $responce->rows[$i]['cell']=array($data['id'],$data['country_name'],$data['area']);
        $i++;
    }
    
    echo json_encode($responce); die;

}