Datatables Php Library Star

Handles server-side processing for Datatables, in a fast and simple way !

Group by statement

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