Server-side processing can be exceptionally useful in DataTables when dealing with massive data sets, and ColReorder works with this as would be expected.
- -It is recommend that you use object based data with server-side processing and ColReorder, as this provides easily understandable mapping between the the - columns and the data relation on the server, otherwise you need to work out array indexes on each call!
-| Name | -Position | -Office | -Extn. | -Start date | -Salary | -
|---|---|---|---|---|---|
| Name | -Position | -Office | -Extn. | -Start date | -Salary | -
The Javascript shown below is used to initialise the table shown in this example:
$(document).ready(function() {
- $('#example').dataTable( {
- dom: 'Rlfrtip',
- processing: true,
- serverSide: true,
- ajax: "../../../examples/server_side/scripts/objects.php",
- columns: [
- { data: "first_name" },
- { data: "last_name" },
- { data: "position" },
- { data: "office" },
- { data: "start_date" },
- { data: "salary" }
- ]
- } );
-} );
-
- In addition to the above code, the following Javascript library files are loaded for use in this example:
- - -The HTML shown below is the raw HTML table element, before it has been enhanced by DataTables:
-This example uses a little bit of additional CSS beyond what is loaded from the library files (below), in order to correctly display the table. The - additional CSS used is shown below:
The following CSS library files are loaded for use in this example to provide the styling of the table:
- - -This table loads data by Ajax. The latest data that has been loaded is shown below. This data will update automatically as any additional data is - loaded.
-The script used to perform the server-side processing for this table is shown below. Please note that this is just an example script using PHP. Server-side - processing scripts can be written in any language, using the protocol described in the DataTables - documentation.
-