Handles server-side processing for Datatables, in a fast and simple way !
It is difficult to use the expression "GROUP BY" in the sql query and also use server-side processing at the same time. In particular, you should deal with paging.
The following example shows there is no need for other configuration for group by statement.
| Genre | Total Length |
|---|---|
| loading... |
In addition to the above code, the following Javascript library files are loaded for use in this example:
https://code.jquery.com/jquery-3.3.1.js
https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js
https://cdn.datatables.net/responsive/2.2.3/js/dataTables.responsive.min.js
The following CSS library files are loaded for use in this example to provide the styling of the
table:
https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css
https://cdn.datatables.net/responsive/2.2.3/css/responsive.dataTables.min.css
