Server-Side Pagination, Sort, Filter with MySQL and PHP

Data in this demo is loaded on demand from MySql Database and especially the 'Customers' table of the Northwind Database. Server request is made when you change Page, Sort, Filter or expand a Group. This is achieved by using the Table's Data Virtualization in combination with DataAdapter's "virtualDataSource".

• Paging is enabled by setting the property paging to true.
• Filtering is enabled by setting the properties filtering and filterRow to true.
• Sorting is enabled by setting the property sortMode to 'one'.
• The number of rows returned per request is set to 10, which is equal to pageSize.
• The 'query' in the data request is used by the server to perform pagination, sorting and filtering.