Recommend this page to a friend! |
Download .zip |
Info | Screenshots | View files (10) | Download .zip | Reputation | Support forum (19) | Blog (1) | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2010-08-15 (6 years ago) | 70% | Total: 8,309 This week: 2 | All time: 191 This week: 591 |
Version | License | PHP version | Categories | |||
ajax-paginator 1.50 | GNU General Publi... | 5.2 | HTML, PHP 5, Databases, AJAX |
Description | Author | |||||||||||||
This class can be used to split MySQL query results displayed in pages retrieved using AJAX. |
|
Deployement: 1. import the customers table(customers.sql) 2. change the database configuration options in the testpage.php and the sub_page.php 3. enjoy :) Use: first of all you have to establish a database connection using mysqli or if you decide to use anything else just modify the database related method calls from the core class The you instantiate the core class paginator passing to it: 1. page id 2. Records per page 3. SQL Query 4. MySQLi Connection Object Then call method: paginate() It does all the work and returns an associative array, else if you want to access the MySQLi result object you can access it by using the object property called result(e.g. $paginator->result) The getLinks Method returns a string that contains the actual html for the pagination links You also have to use the same settings or the same code for the subpage also. If you need further assistance contact me: omar.php@gmail.com I hope this class is useful for you. |
Screenshots | ||
Files |
File | Role | Description | ||
---|---|---|---|---|
js (2 files) | ||||
ajax-loader.gif | Data | the loader image | ||
customers.sql | Data | sql script to generate the test table | ||
ajaxpaginator.class.php | Class | core class | ||
readme | Doc. | readme | ||
screenshot-1.gif | Screen | screenshot | ||
style.css | Data | css style | ||
sub_page.php | Example | a php file that takes the requested page number and return the paginated table (requested with ajax) | ||
testpage.php | Example | main test file |
Files | / | js |
File | Role | Description |
---|---|---|
jquery-1.4.2.min.js | Appl. | jQuery 1.4.2 |
jquery.paginate.js | Data | jquery plugin to handle the ajax requests and responses |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
0% |
|
|
User Ratings | User Comments (7) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Applications that use this package |
Business Excellence Center a website using this class |
Encore Design Studio another website using this class |
If you know an application of this package, send a message to the author to add a link here.