agung susanto

found solution here aymsystems and here CSRF Protection in CodeIgniter 2.0: A closer look

first add on views:

<?php echo form_open('data/loadjson'); ?>
<table id="tt"></table>
<?php echo form_close();?>

add this on script tag

var cct = $("input[name=mcr_token_name]").val();

and add

$('#tt').datagrid({
            url: '<?php echo base_url(); ?>data/loadjson',
            title: 'Your Grid Title',
            queryParams: {'mcr_token_name': cct},
            ....

full sample source ->

the controllers

function loadjson(){
 $page = isset($_POST['page']) ? intval($_POST['page']) : 1;
 $rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
 $offset = ($page-1)*$rows;
 $this->the_model->limit = $rows;
 $this->the_model->offset = $offset;
 $result['total'] = $this->the_model->num_page();
 $result['rows'] = $this->the_model->list_page();
 return json_encode($result);
 }

the models

// add this variable on top of the models
public $limit;
public $offset;
//....
public function list_page() {
        $query = $this->db->select('field1,field2,field...')
                ->from('table_name')
                ->get('', $this->limit, $this->offset);
        return $query->result_array();
    }

public function num_page() {
       $result = $this->db->from('table_name')
                        ->count_all_results();
        return $result;
    }

the views

//add this on head

<link href="<?php echo base_url(); ?>css/easyui/themes/default/easyui.css" type="text/css" rel="stylesheet" />
<link rel="stylesheet" href="<?php echo base_url(); ?>css/easyui/themes/icon.css" type="text/css" />
<script src="<?php echo base_url(); ?>js/easyui/jquery.easyui.min.js"></script>
<script src="<?php echo base_url(); ?>js/easyui/jquery.min.js"></script>

//the body
<div id="right">
        <p>
         <?php echo form_open('data/loadjson');?>
         <table id="tt"></table>
         <?php echo form_close();?>
        </p>
</div>

<script type="text/javascript">
    var cct = $("input[name=mcr_token_name]").val();
    $(function(){
        $('#tt').datagrid({
            url: '<?php echo base_url(); ?>data/loadjson',
            title: 'Your Grid Title',
            width: 640,
            height: 'auto',
            nowrap: false,
            striped: true,
            collapsible:true,
            fitColumns: true,
            idField:'field1',
            queryParams: {'mcr_token_name': cct},
            pagination:true,
            rownumbers:true,
            frozenColumns:[[
                {field:'ck',checkbox:true},
                {title:'Field 1',field:'field1',width:300}
            ]],
            columns:[[
                {field:'field2',title:'Field 2',width:80},
                {field:'field...',title:'Field ...',width:80,align:'right'}
            ]]
        });
    });
</script>

that’s all, I hope this can help, as it has also helped me 🙂