Thursday, 15 March 2012

php - Jeasyui Datagrid Pagination Issues with second page only -


I am pulling my hair on the JSU Data Grid.

It correctly calculates the number of rows I currently have 22 rows, which gives 3 pages in the grid. The second page does not appear though I do not get it. The third page works

I have a suspicion on my SQL, and offset and limit, but what is wrong? I have set $ offsets and $ rows in this way (e.g. by JCEE)

  $ page = isset ($ _ POST ['page'])? Interval ($ _ POST ['page']): 1; $ Line = release ($ _ POST ['rows'])? Interval ($ _ POST ['rows']): 10; $ Offset = ($ page-1) * $ rows;  

I'm using this selection to get the data $ rs = mysql_query ("Select z.list_name as the name , Z.list_pointsPerHour as PPH, as the acquisition of List_takeoverPoints zone z, tempzones tz where z.list_id = tz.zoneid limit $ offset, $ rows ");

If I put $ rows 20 into the file and run php from the command line, then it does not give anything, if I leave it at 10 then gives 10 and happiness 22 total

SQL uses hacking as defined values ​​in the MySQL console and for offset and boundary tasks.

My site is turned on:

And it is such an example that I

I was unsuccessful, so it was all about me I have Latin 1 in my database and PHP is relatively UTF-8. Ouput and forced UTF-8 problem solved


No comments:

Post a Comment