How to use pagination on codeignator datagrid??

Posted by riad on Stack Overflow See other posts from Stack Overflow or by riad
Published on 2010-04-29T07:43:02Z Indexed on 2010/04/29 7:47 UTC
Read the original article Hit count: 305

Filed under:

Dear all, Below is my code.Can anybody guide me how can i use pagination on data grid in codeignator??

function viewAllList()

{

$sql = '(SELECT id,songName,albumName,artistName,category FROM tbl_rbt )as abc';

$getInstance = & get_instance(); $getInstance->load->library('rapyd'); $this->rapyd->load('datagrid');
$grid = new DataGrid('', $sql); $grid->column('Song Name', 'songName', 'align=\'left\''); $grid->column('Album Name','albumName', 'align=\'left\''); $grid->column('Artist Name','artistName', 'align=\'left\''); $grid->column('Category', 'category', 'align=\'left\''); $linkshow = anchor('admin_controller/editRbt/<#id#>', 'Edit'); $linkshow .= ' ' . anchor('admin_controller/deleteRbt/<#id#>', 'Delete', 'onclick = "return checkDelete();"'); $grid->column('Actions', $linkshow,'align=\'left\' width="100px"');
$grid->build(); return $grid->output; }

I need urgent help.Pls help

Thanks in advance

Riad

© Stack Overflow or respective owner

Related posts about datagridview