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/2.0.8/js/dataTables.min.js
https://cdn.datatables.net/responsive/3.0.2/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/2.0.8/css/dataTables.dataTables.min.css
https://cdn.datatables.net/responsive/3.0.2/css/responsive.dataTables.min.css
)