hello all
I have problems with pagination on datagrid
I put on my retrieve data script the variables $page and $rows like in the demo
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 50;
$offset = ($page-1)*$rows;
In the query is set limit like:
The declaration of datagrid is:
<table id="dg" class="easyui-datagrid" style="width:100%;height:590px;" data-options="
singleSelect:true,
striped:true,
url:'../retrieve/get.php',
emptyMsg: 'No data',
toolbar:'#tb',
sortName:'fbit',
sortOrder:'desc',
multiSort:false,
pagination:true,
pagePosition:'bottom',
pageSize:50,
pageList:[50,100,150,200,250],
..........
The problem is that the datagrid is showing only 50 rows and the pagination said Displaying 1 to 50 of
50 itemsand is showing just one page,
Page 1 of 1There are 117 rows in my data base table
Maybe Im missing something?
Please your help, thanks