This example shows how FixedColumns can be used with server-side processing in DataTables to cope with very large tables. No special considerations are - required, just initialise FixedColumns as you normally would!
- -Note that the table width is constrained in this example to allow scrolling to occur as the server-side processing data set has a limited number of columns in - this demo!
-| 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() {
- var table = $('#example').DataTable( {
- scrollY: "300px",
- scrollX: true,
- scrollCollapse: true,
- ajax: "../../../examples/server_side/scripts/server_processing.php",
- serverSide: true
- } );
- new $.fn.dataTable.FixedColumns( table );
-} );
-
- 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:
/* Ensure that the demo table scrolls */
- th, td { white-space: nowrap; }
- div.dataTables_wrapper {
- width: 600px;
- margin: 0 auto;
- }
-
- /* Lots of padding for the cells as SSP has limited data in the demo */
- th,
- td {
- padding-left: 40px !important;
- padding-right: 40px !important;
- }
- 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.
-