Example 16: Pagination

Click on the table headers to sort the rows.
Click in a cell to edit the data.

Your table rows can now be paginated. This is very nice to have with huge tables especially since TableGear can slow down significantly when it has too many rows to work with (remember, it's doing a lot!).

The concept of adding new rows on any page of a paginated table is a bit nonsensical, or at least counter-intuitive as a user experience, but it's also a convenience that's hard to throw out. In any case, the "addNewRows" parameter can turn off this feature, so I leave the decision up to you!

Setup

You need to setup your database info. This is only required once.

You can always change this data later by changing the index.php file.

Database not found.