Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Mathias on Mar 11, 2009 07:26
open dhtmlx forum
dhtmlxFolder PHP example for dynamic paging

Hello,

Almost all problems I solved by this very well documentation and knowledge base. But I've found no suitable example to dynamic paging in dhtmlxFolder. My problem is that i tried to load datas dynamical with PHP and SQL.

With "myFolders.enablePaging(10,true);" I would like to load just 10 items every page. Other items for example 11 till 20, should just load, if I clicked site two. Just to use GETRequest "dhx_global_page" for OFFSET dont worked.

Could you give me an easy MySQL example?

(SELECT * FROM mytable LIMIT ?????);
Answer posted by Alex (support) on Mar 11, 2009 08:52

Hello, 

It is not possible to load only 10 items if 10 items are displayed per page. The number of items should be more than 10 (for example 11); 

Possibly the following LIMIT template can be used:

if dhx_global_page is not set

LIMIT 0,11

else 

LIMIT [(dhx_global_page-1)*11],11

Answer posted by Mathias on Mar 11, 2009 10:48
Thanks a lot, it works perfect! It will show always the paging button to next side and after loading this next side there is a button again!