Server-Side Sort and 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 Sort or Filter. This is achieved by using the CardView's Data Virtualization in combination with DataAdapter's "virtualDataSource".

Filtering and sorting UI is enabled by setting the property headerPosition to 'top' or 'bottom'.
The 'query' in the data request is used by the server to perform sorting and filtering.

Server-Side Sort and Filter with MySQL and PHP

SQL Query