Title: datagrid pagination Post by: catpaw on April 18, 2017, 01:24:48 PM 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 Code: $page = isset($_POST['page']) ? intval($_POST['page']) : 1; In the query is set limit like: Code: ... The declaration of datagrid is: Code: <table id="dg" class="easyui-datagrid" style="width:100%;height:590px;" data-options=" The problem is that the datagrid is showing only 50 rows and the pagination said Displaying 1 to 50 of 50 items and is showing just one page, Page 1 of 1 There are 117 rows in my data base table Maybe Im missing something? Please your help, thanks Title: Re: datagrid pagination Post by: stworthy on April 18, 2017, 11:31:12 PM Please make sure you should return the correct JSON data from your server. The code looks like this:
Code: echo json_encode(array( Title: Re: datagrid pagination Post by: catpaw on April 19, 2017, 06:16:03 AM hi sworthy, yes Im secure that the returning properly data, this is my php script:
Code: $page = isset($_POST['page']) ? intval($_POST['page']) : 1; Title: Re: datagrid pagination Post by: qianet on June 13, 2017, 01:04:38 PM 1. total=...select count(0) from ... where ...filed like '%...%' order by filed asc ===> 113
2. rows= ..select * from ... where ...filed like '%...%' and rowid between 0 to 49 order by filed asc ==>50 |