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 Grid's Data Virtualization in combination with DataAdapter's "virtualDataSource".

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