extras/ColReorder/server_side.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
        <head>
                <meta http-equiv="content-type" content="text/html; charset=utf-8">
                <link rel="shortcut icon" type="image/ico" href="http://www.sprymedia.co.uk/media/images/favicon.ico">
                
                <title>ColReorder example</title>
                <style type="text/css" title="currentStyle">
                        @import "../../media/css/demo_page.css";
                        @import "../../media/css/demo_table.css";
                        @import "media/css/ColReorder.css";
                </style>
                <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.js"></script>
                <script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script>
                <script type="text/javascript" charset="utf-8" src="media/js/ColReorder.js"></script>
                <script type="text/javascript" charset="utf-8">
                        $(document).ready( function () {
                                var oTable = $('#example').dataTable( {
                                        "sDom": 'Rlfrtip',
                                        "bProcessing": true,
                                        "bServerSide": true,
                                        "sAjaxSource": "../../examples/server_side/scripts/objects.php",
                                        "aoColumns": [
                                                { "mDataProp": "engine" },
                                                { "mDataProp": "browser" },
                                                { "mDataProp": "platform" },
                                                { "mDataProp": "version" },
                                                { "mDataProp": "grade" }
                                        ]
                                } );
                        } );
                </script>
        </head>
        <body id="dt_example">
                <div id="container">
                        <div class="full_width big">
                                ColReorder example with server-side processing
                        </div>
                        
                        <h1>Preamble</h1>
                        <p>Server-side processing can be exceptionally useful in DataTables when dealing with 
                                massive data sets, and ColReorder works with this as would be expected. There must be
                                special consideration for the column ordering on the server-side script since the 
                                columns can be in an unexpected order. For this you can either choose to use the 
                                <i>sName</i> parameter for each column and take this into account in the server-side
                                script (the parameter 'sColumns' is a comma separated string of these sName parameters).</p>
                        
                        </p>Alternatively use the more flexible <a href="http://datatables.net/usage/columns#mDataProp">mDataProp</a>
                                option for each column. This allows you to use JSON objects which DataTables, so order doesn't
                                matter like it would do in an array. Again the server-side script must take this into account
                                through the <i>mDataProp_{i}</i> which is sent for each column (so the server knows which
                                column is to be sorted on).</p>
                                
                        
                        <h1>Live example</h1>
                        <form>
                        <div id="demo">
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
        <thead>
                <tr>
                        <th>Rendering engine</th>
                        <th>Browser</th>
                        <th>Platform(s)</th>
                        <th>Engine version</th>
                        <th>CSS grade</th>
                </tr>
        </thead>
        <tfoot>
                <tr>
                        <th>Rendering engine</th>
                        <th>Browser</th>
                        <th>Platform(s)</th>
                        <th>Engine version</th>
                        <th>CSS grade</th>
                </tr>
        </tfoot>
        <tbody>
        </tbody>
</table>
                        </div>
                </form>
                        <div class="spacer"></div>
                        
                        
                        <h1>Examples</h1>
                        <ul>
                                <li><a href="index.html">Basic initialisation</a></li>
                                <li><a href="alt_insert.html">Styling the insert cursor</a></li>
                                <li><a href="col_filter.html">Individual column filtering</a></li>
                                <li><a href="colvis.html">Integration with DataTables' ColVis plug-in</a></li>
                                <li><a href="fixedcolumns.html">Integration with DataTables' FixedColumns plug-in</a></li>
                                <li><a href="fixedheader.html">Integration with DataTables' FixedHeader plug-in</a></li>
                                <li><a href="predefined.html">Using a predefined column order set</a></li>
                                <li><a href="reset.html">Providing a user control to reset the column order</a></li>
                                <li><a href="scrolling.html">Column reordering shown with scrolling in DataTables</a></li>
                                <li><a href="server_side.html">Server-side processing support</a></li>
                                <li><a href="state_save.html">State saving of the column position</a></li>
                                <li><a href="theme.html">jQuery UI theme integration</a></li>
                        </ul>
                        
                        
                        <h1>Initialisation code</h1>
                        <pre>$(document).ready( function () {
        var oTable = $('#example').dataTable( {
                "sDom": 'Rlfrtip',
                "bProcessing": true,
                "bServerSide": true,
                "sAjaxSource": "../../examples/server_side/scripts/objects.php",
                "aoColumns": [
                        { "mDataProp": "engine" },
                        { "mDataProp": "browser" },
                        { "mDataProp": "platform" },
                        { "mDataProp": "version" },
                        { "mDataProp": "grade" }
                ]
        } );
} );</pre>

      <h1>Example JSON return from the server</h1>
      <pre>{
"sEcho": 1,
"iTotalRecords": "57",
"iTotalDisplayRecords": "57",
"aaData": [
    {
        "engine": "Gecko",
        "browser": "Firefox 1.0",
        "platform": "Win 98+ / OSX.2+",
        "version": "1.7",
        "grade": "A"
    },
    {
        "engine": "Gecko",
        "browser": "Firefox 1.5",
        "platform": "Win 98+ / OSX.2+",
        "version": "1.8",
        "grade": "A"
    },
    ...
  ]
}</pre>
                        
                        <div id="footer" style="text-align:center;">
                                <span style="font-size:10px;">
                                        ColReorder and DataTables &copy; Allan Jardine 2010
                                </span>
                        </div>
                </div>
        </body>
</html>
1	torben	2125	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
2			<html>
3			<head>
4			<meta http-equiv="content-type" content="text/html; charset=utf-8">
5			<link rel="shortcut icon" type="image/ico" href="http://www.sprymedia.co.uk/media/images/favicon.ico">
6
7			<title>ColReorder example</title>
8			<style type="text/css" title="currentStyle">
9			@import "../../media/css/demo_page.css";
10			@import "../../media/css/demo_table.css";
11			@import "media/css/ColReorder.css";
12			</style>
13			<script type="text/javascript" charset="utf-8" src="../../media/js/jquery.js"></script>
14			<script type="text/javascript" charset="utf-8" src="../../media/js/jquery.dataTables.js"></script>
15			<script type="text/javascript" charset="utf-8" src="media/js/ColReorder.js"></script>
16			<script type="text/javascript" charset="utf-8">
17			$(document).ready( function () {
18			var oTable = $('#example').dataTable( {
19			"sDom": 'Rlfrtip',
20			"bProcessing": true,
21			"bServerSide": true,
22			"sAjaxSource": "../../examples/server_side/scripts/objects.php",
23			"aoColumns": [
24			{ "mDataProp": "engine" },
25			{ "mDataProp": "browser" },
26			{ "mDataProp": "platform" },
27			{ "mDataProp": "version" },
28			{ "mDataProp": "grade" }
29			]
30			} );
31			} );
32			</script>
33			</head>
34			<body id="dt_example">
35			<div id="container">
36			<div class="full_width big">
37			ColReorder example with server-side processing
38			</div>
39
40			<h1>Preamble</h1>
41			<p>Server-side processing can be exceptionally useful in DataTables when dealing with
42			massive data sets, and ColReorder works with this as would be expected. There must be
43			special consideration for the column ordering on the server-side script since the
44			columns can be in an unexpected order. For this you can either choose to use the
45			<i>sName</i> parameter for each column and take this into account in the server-side
46			script (the parameter 'sColumns' is a comma separated string of these sName parameters).</p>
47
48			</p>Alternatively use the more flexible <a href="http://datatables.net/usage/columns#mDataProp">mDataProp</a>
49			option for each column. This allows you to use JSON objects which DataTables, so order doesn't
50			matter like it would do in an array. Again the server-side script must take this into account
51			through the <i>mDataProp_{i}</i> which is sent for each column (so the server knows which
52			column is to be sorted on).</p>
53
54
55			<h1>Live example</h1>
56			<form>
57			<div id="demo">
58			<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
59			<thead>
60			<tr>
61			<th>Rendering engine</th>
62			<th>Browser</th>
63			<th>Platform(s)</th>
64			<th>Engine version</th>
65			<th>CSS grade</th>
66			</tr>
67			</thead>
68			<tfoot>
69			<tr>
70			<th>Rendering engine</th>
71			<th>Browser</th>
72			<th>Platform(s)</th>
73			<th>Engine version</th>
74			<th>CSS grade</th>
75			</tr>
76			</tfoot>
77			<tbody>
78			</tbody>
79			</table>
80			</div>
81			</form>
82			<div class="spacer"></div>
83
84
85			<h1>Examples</h1>
86			<ul>
87			<li><a href="index.html">Basic initialisation</a></li>
88			<li><a href="alt_insert.html">Styling the insert cursor</a></li>
89			<li><a href="col_filter.html">Individual column filtering</a></li>
90			<li><a href="colvis.html">Integration with DataTables' ColVis plug-in</a></li>
91			<li><a href="fixedcolumns.html">Integration with DataTables' FixedColumns plug-in</a></li>
92			<li><a href="fixedheader.html">Integration with DataTables' FixedHeader plug-in</a></li>
93			<li><a href="predefined.html">Using a predefined column order set</a></li>
94			<li><a href="reset.html">Providing a user control to reset the column order</a></li>
95			<li><a href="scrolling.html">Column reordering shown with scrolling in DataTables</a></li>
96			<li><a href="server_side.html">Server-side processing support</a></li>
97			<li><a href="state_save.html">State saving of the column position</a></li>
98			<li><a href="theme.html">jQuery UI theme integration</a></li>
99			</ul>
100
101
102			<h1>Initialisation code</h1>
103			<pre>$(document).ready( function () {
104			var oTable = $('#example').dataTable( {
105			"sDom": 'Rlfrtip',
106			"bProcessing": true,
107			"bServerSide": true,
108			"sAjaxSource": "../../examples/server_side/scripts/objects.php",
109			"aoColumns": [
110			{ "mDataProp": "engine" },
111			{ "mDataProp": "browser" },
112			{ "mDataProp": "platform" },
113			{ "mDataProp": "version" },
114			{ "mDataProp": "grade" }
115			]
116			} );
117			} );</pre>
118
119			<h1>Example JSON return from the server</h1>
120			<pre>{
121			"sEcho": 1,
122			"iTotalRecords": "57",
123			"iTotalDisplayRecords": "57",
124			"aaData": [
125			{
126			"engine": "Gecko",
127			"browser": "Firefox 1.0",
128			"platform": "Win 98+ / OSX.2+",
129			"version": "1.7",
130			"grade": "A"
131			},
132			{
133			"engine": "Gecko",
134			"browser": "Firefox 1.5",
135			"platform": "Win 98+ / OSX.2+",
136			"version": "1.8",
137			"grade": "A"
138			},
139			...
140			]
141			}</pre>
142
143			<div id="footer" style="text-align:center;">
144			<span style="font-size:10px;">
145			ColReorder and DataTables © Allan Jardine 2010
146			</span>
147			</div>
148			</div>
149			</body>
150			</html>