Using this plugin you can create pages and specify function which will be called when user changed the current page.
You can try demo here
Usage
jQuery is required
Include jquery.pagination.js and jquery.pagination.css to your html page:
Create Pages
To create pages we can call createPagers function for empty div and it will add ul elements to specified div:
This
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.014982s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.152473s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.016188s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001260s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001574s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003471s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001125s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004342s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020796s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001601s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 97608 [ RunTime:0.016292s ]