Free cookie consent management tool by TermsFeed Policy Generator

source: branches/WebApplication/MVC2/HeuristicLabWeb.PluginHost/HLWebPluginHost/Content/jQuery/jQueryPlugins/DataTables-1.7.6/examples/api/editable.html @ 6286

Last change on this file since 6286 was 6286, checked in by dkahn, 13 years ago

#1198 Added jQuery plus plugins

File size: 18.8 KB
Line 
1<!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.datatables.net/media/images/favicon.ico" />
6   
7    <title>DataTables example</title>
8    <style type="text/css" title="currentStyle">
9      @import "../../media/css/demo_page.css";
10      @import "../../media/css/demo_table.css";
11    </style>
12    <script type="text/javascript" language="javascript" src="../../media/js/jquery.js"></script>
13    <script type="text/javascript" language="javascript" src="../examples_support/jquery.jeditable.js"></script>
14    <script type="text/javascript" language="javascript" src="../../media/js/jquery.dataTables.js"></script>
15    <script type="text/javascript" charset="utf-8">
16      $(document).ready(function() {
17        /* Init DataTables */
18        var oTable = $('#example').dataTable();
19       
20        /* Apply the jEditable handlers to the table */
21        $('td', oTable.fnGetNodes()).editable( '../examples_support/editable_ajax.php', {
22          "callback": function( sValue, y ) {
23            var aPos = oTable.fnGetPosition( this );
24            oTable.fnUpdate( sValue, aPos[0], aPos[1] );
25          },
26          "submitdata": function ( value, settings ) {
27            return {
28              "row_id": this.parentNode.getAttribute('id'),
29              "column": oTable.fnGetPosition( this )[2]
30            };
31          },
32          "height": "14px"
33        } );
34      } );
35    </script>
36  </head>
37  <body id="dt_example">
38    <div id="container">
39      <div class="full_width big">
40        <i>DataTables</i> editing example
41      </div>
42     
43      <h1>Preamble</h1>
44      <p>Using <i>DataTables</i> in-combination with the excellent <a href="http://www.appelsiini.net/projects/jeditable">jEditable</a> plugin for jQuery allows you to produce a table which can have individual cells edited. The table can then be updated such that filtering, sorting etc. will all work as expected. This is showing in the demo below.</p>
45      <p>The example shows how a table element can be edited (you could limit to a particular column if you wish using the selector), posted to the server (for saving in a database or whatever) and then placed back into the DataTable. The server's processing in this example simply appends the string '(server updated)' to indicate that something has happened on the server.</p>
46      <p>Note also that this example makes use of the information in the 'ID' attribute of the TR element. This is useful in order to tell the server what row is being updated - this can readily be expended to include column information as required. Further to this, it is worth noting that to use this type of example with DataTables' server-side processing option, you must use <a href="http://datatables.net/usage/callbacks#fnDrawCallback">fnDrawCallback</a> to apply the event listeners on each draw.</p>
47     
48      <h1>Live example</h1>
49      <div id="demo">
50<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
51  <thead>
52    <tr>
53      <th>Rendering engine</th>
54      <th>Browser</th>
55      <th>Platform(s)</th>
56      <th>Engine version</th>
57      <th>CSS grade</th>
58    </tr>
59  </thead>
60  <tbody>
61    <tr id="1" class="gradeX">
62      <td>Trident</td>
63      <td>Internet
64         Explorer
65        4.0
66        </td>
67      <td>Win 95+</td>
68      <td class="center">4</td>
69      <td class="center">X</td>
70    </tr>
71    <tr id="2" class="gradeC">
72      <td>Trident</td>
73      <td>Internet
74         Explorer 5.0</td>
75      <td>Win 95+</td>
76      <td class="center">5</td>
77      <td class="center">C</td>
78    </tr>
79    <tr id="3" class="gradeA">
80      <td>Trident</td>
81      <td>Internet
82         Explorer 5.5</td>
83      <td>Win 95+</td>
84      <td class="center">5.5</td>
85      <td class="center">A</td>
86    </tr>
87    <tr id="4" class="gradeA">
88      <td>Trident</td>
89      <td>Internet
90         Explorer 6</td>
91      <td>Win 98+</td>
92      <td class="center">6</td>
93      <td class="center">A</td>
94    </tr>
95    <tr id="5" class="gradeA">
96      <td>Trident</td>
97      <td>Internet Explorer 7</td>
98      <td>Win XP SP2+</td>
99      <td class="center">7</td>
100      <td class="center">A</td>
101    </tr>
102    <tr id="6" class="gradeA">
103      <td>Trident</td>
104      <td>AOL browser (AOL desktop)</td>
105      <td>Win XP</td>
106      <td class="center">6</td>
107      <td class="center">A</td>
108    </tr>
109    <tr id="7" class="gradeA">
110      <td>Gecko</td>
111      <td>Firefox 1.0</td>
112      <td>Win 98+ / OSX.2+</td>
113      <td class="center">1.7</td>
114      <td class="center">A</td>
115    </tr>
116    <tr id="8" class="gradeA">
117      <td>Gecko</td>
118      <td>Firefox 1.5</td>
119      <td>Win 98+ / OSX.2+</td>
120      <td class="center">1.8</td>
121      <td class="center">A</td>
122    </tr>
123    <tr id="9" class="gradeA">
124      <td>Gecko</td>
125      <td>Firefox 2.0</td>
126      <td>Win 98+ / OSX.2+</td>
127      <td class="center">1.8</td>
128      <td class="center">A</td>
129    </tr>
130    <tr id="10" class="gradeA">
131      <td>Gecko</td>
132      <td>Firefox 3.0</td>
133      <td>Win 2k+ / OSX.3+</td>
134      <td class="center">1.9</td>
135      <td class="center">A</td>
136    </tr>
137    <tr id="11" class="gradeA">
138      <td>Gecko</td>
139      <td>Camino 1.0</td>
140      <td>OSX.2+</td>
141      <td class="center">1.8</td>
142      <td class="center">A</td>
143    </tr>
144    <tr id="12" class="gradeA">
145      <td>Gecko</td>
146      <td>Camino 1.5</td>
147      <td>OSX.3+</td>
148      <td class="center">1.8</td>
149      <td class="center">A</td>
150    </tr>
151    <tr id="13" class="gradeA">
152      <td>Gecko</td>
153      <td>Netscape 7.2</td>
154      <td>Win 95+ / Mac OS 8.6-9.2</td>
155      <td class="center">1.7</td>
156      <td class="center">A</td>
157    </tr>
158    <tr id="14" class="gradeA">
159      <td>Gecko</td>
160      <td>Netscape Browser 8</td>
161      <td>Win 98SE+</td>
162      <td class="center">1.7</td>
163      <td class="center">A</td>
164    </tr>
165    <tr id="15" class="gradeA">
166      <td>Gecko</td>
167      <td>Netscape Navigator 9</td>
168      <td>Win 98+ / OSX.2+</td>
169      <td class="center">1.8</td>
170      <td class="center">A</td>
171    </tr>
172    <tr id="16" class="gradeA">
173      <td>Gecko</td>
174      <td>Mozilla 1.0</td>
175      <td>Win 95+ / OSX.1+</td>
176      <td class="center">1</td>
177      <td class="center">A</td>
178    </tr>
179    <tr id="17" class="gradeA">
180      <td>Gecko</td>
181      <td>Mozilla 1.1</td>
182      <td>Win 95+ / OSX.1+</td>
183      <td class="center">1.1</td>
184      <td class="center">A</td>
185    </tr>
186    <tr id="18" class="gradeA">
187      <td>Gecko</td>
188      <td>Mozilla 1.2</td>
189      <td>Win 95+ / OSX.1+</td>
190      <td class="center">1.2</td>
191      <td class="center">A</td>
192    </tr>
193    <tr id="19" class="gradeA">
194      <td>Gecko</td>
195      <td>Mozilla 1.3</td>
196      <td>Win 95+ / OSX.1+</td>
197      <td class="center">1.3</td>
198      <td class="center">A</td>
199    </tr>
200    <tr id="20" class="gradeA">
201      <td>Gecko</td>
202      <td>Mozilla 1.4</td>
203      <td>Win 95+ / OSX.1+</td>
204      <td class="center">1.4</td>
205      <td class="center">A</td>
206    </tr>
207    <tr id="21" class="gradeA">
208      <td>Gecko</td>
209      <td>Mozilla 1.5</td>
210      <td>Win 95+ / OSX.1+</td>
211      <td class="center">1.5</td>
212      <td class="center">A</td>
213    </tr>
214    <tr id="22" class="gradeA">
215      <td>Gecko</td>
216      <td>Mozilla 1.6</td>
217      <td>Win 95+ / OSX.1+</td>
218      <td class="center">1.6</td>
219      <td class="center">A</td>
220    </tr>
221    <tr id="23" class="gradeA">
222      <td>Gecko</td>
223      <td>Mozilla 1.7</td>
224      <td>Win 98+ / OSX.1+</td>
225      <td class="center">1.7</td>
226      <td class="center">A</td>
227    </tr>
228    <tr id="24" class="gradeA">
229      <td>Gecko</td>
230      <td>Mozilla 1.8</td>
231      <td>Win 98+ / OSX.1+</td>
232      <td class="center">1.8</td>
233      <td class="center">A</td>
234    </tr>
235    <tr id="25" class="gradeA">
236      <td>Gecko</td>
237      <td>Seamonkey 1.1</td>
238      <td>Win 98+ / OSX.2+</td>
239      <td class="center">1.8</td>
240      <td class="center">A</td>
241    </tr>
242    <tr id="26" class="gradeA">
243      <td>Gecko</td>
244      <td>Epiphany 2.20</td>
245      <td>Gnome</td>
246      <td class="center">1.8</td>
247      <td class="center">A</td>
248    </tr>
249    <tr id="27" class="gradeA">
250      <td>Webkit</td>
251      <td>Safari 1.2</td>
252      <td>OSX.3</td>
253      <td class="center">125.5</td>
254      <td class="center">A</td>
255    </tr>
256    <tr id="28" class="gradeA">
257      <td>Webkit</td>
258      <td>Safari 1.3</td>
259      <td>OSX.3</td>
260      <td class="center">312.8</td>
261      <td class="center">A</td>
262    </tr>
263    <tr id="29" class="gradeA">
264      <td>Webkit</td>
265      <td>Safari 2.0</td>
266      <td>OSX.4+</td>
267      <td class="center">419.3</td>
268      <td class="center">A</td>
269    </tr>
270    <tr id="30" class="gradeA">
271      <td>Webkit</td>
272      <td>Safari 3.0</td>
273      <td>OSX.4+</td>
274      <td class="center">522.1</td>
275      <td class="center">A</td>
276    </tr>
277    <tr id="31" class="gradeA">
278      <td>Webkit</td>
279      <td>OmniWeb 5.5</td>
280      <td>OSX.4+</td>
281      <td class="center">420</td>
282      <td class="center">A</td>
283    </tr>
284    <tr id="32" class="gradeA">
285      <td>Webkit</td>
286      <td>iPod Touch / iPhone</td>
287      <td>iPod</td>
288      <td class="center">420.1</td>
289      <td class="center">A</td>
290    </tr>
291    <tr id="33" class="gradeA">
292      <td>Webkit</td>
293      <td>S60</td>
294      <td>S60</td>
295      <td class="center">413</td>
296      <td class="center">A</td>
297    </tr>
298    <tr id="34" class="gradeA">
299      <td>Presto</td>
300      <td>Opera 7.0</td>
301      <td>Win 95+ / OSX.1+</td>
302      <td class="center">-</td>
303      <td class="center">A</td>
304    </tr>
305    <tr id="35" class="gradeA">
306      <td>Presto</td>
307      <td>Opera 7.5</td>
308      <td>Win 95+ / OSX.2+</td>
309      <td class="center">-</td>
310      <td class="center">A</td>
311    </tr>
312    <tr id="36" class="gradeA">
313      <td>Presto</td>
314      <td>Opera 8.0</td>
315      <td>Win 95+ / OSX.2+</td>
316      <td class="center">-</td>
317      <td class="center">A</td>
318    </tr>
319    <tr id="37" class="gradeA">
320      <td>Presto</td>
321      <td>Opera 8.5</td>
322      <td>Win 95+ / OSX.2+</td>
323      <td class="center">-</td>
324      <td class="center">A</td>
325    </tr>
326    <tr id="38" class="gradeA">
327      <td>Presto</td>
328      <td>Opera 9.0</td>
329      <td>Win 95+ / OSX.3+</td>
330      <td class="center">-</td>
331      <td class="center">A</td>
332    </tr>
333    <tr id="39" class="gradeA">
334      <td>Presto</td>
335      <td>Opera 9.2</td>
336      <td>Win 88+ / OSX.3+</td>
337      <td class="center">-</td>
338      <td class="center">A</td>
339    </tr>
340    <tr id="40" class="gradeA">
341      <td>Presto</td>
342      <td>Opera 9.5</td>
343      <td>Win 88+ / OSX.3+</td>
344      <td class="center">-</td>
345      <td class="center">A</td>
346    </tr>
347    <tr id="41" class="gradeA">
348      <td>Presto</td>
349      <td>Opera for Wii</td>
350      <td>Wii</td>
351      <td class="center">-</td>
352      <td class="center">A</td>
353    </tr>
354    <tr id="42" class="gradeA">
355      <td>Presto</td>
356      <td>Nokia N800</td>
357      <td>N800</td>
358      <td class="center">-</td>
359      <td class="center">A</td>
360    </tr>
361    <tr id="43" class="gradeA">
362      <td>Presto</td>
363      <td>Nintendo DS browser</td>
364      <td>Nintendo DS</td>
365      <td class="center">8.5</td>
366      <td class="center">C/A<sup>1</sup></td>
367    </tr>
368    <tr id="44" class="gradeC">
369      <td>KHTML</td>
370      <td>Konqureror 3.1</td>
371      <td>KDE 3.1</td>
372      <td class="center">3.1</td>
373      <td class="center">C</td>
374    </tr>
375    <tr id="45" class="gradeA">
376      <td>KHTML</td>
377      <td>Konqureror 3.3</td>
378      <td>KDE 3.3</td>
379      <td class="center">3.3</td>
380      <td class="center">A</td>
381    </tr>
382    <tr id="46" class="gradeA">
383      <td>KHTML</td>
384      <td>Konqureror 3.5</td>
385      <td>KDE 3.5</td>
386      <td class="center">3.5</td>
387      <td class="center">A</td>
388    </tr>
389    <tr id="47" class="gradeX">
390      <td>Tasman</td>
391      <td>Internet Explorer 4.5</td>
392      <td>Mac OS 8-9</td>
393      <td class="center">-</td>
394      <td class="center">X</td>
395    </tr>
396    <tr id="48" class="gradeC">
397      <td>Tasman</td>
398      <td>Internet Explorer 5.1</td>
399      <td>Mac OS 7.6-9</td>
400      <td class="center">1</td>
401      <td class="center">C</td>
402    </tr>
403    <tr id="49" class="gradeC">
404      <td>Tasman</td>
405      <td>Internet Explorer 5.2</td>
406      <td>Mac OS 8-X</td>
407      <td class="center">1</td>
408      <td class="center">C</td>
409    </tr>
410    <tr id="50" class="gradeA">
411      <td>Misc</td>
412      <td>NetFront 3.1</td>
413      <td>Embedded devices</td>
414      <td class="center">-</td>
415      <td class="center">C</td>
416    </tr>
417    <tr id="51" class="gradeA">
418      <td>Misc</td>
419      <td>NetFront 3.4</td>
420      <td>Embedded devices</td>
421      <td class="center">-</td>
422      <td class="center">A</td>
423    </tr>
424    <tr id="52" class="gradeX">
425      <td>Misc</td>
426      <td>Dillo 0.8</td>
427      <td>Embedded devices</td>
428      <td class="center">-</td>
429      <td class="center">X</td>
430    </tr>
431    <tr id="53" class="gradeX">
432      <td>Misc</td>
433      <td>Links</td>
434      <td>Text only</td>
435      <td class="center">-</td>
436      <td class="center">X</td>
437    </tr>
438    <tr id="54" class="gradeX">
439      <td>Misc</td>
440      <td>Lynx</td>
441      <td>Text only</td>
442      <td class="center">-</td>
443      <td class="center">X</td>
444    </tr>
445    <tr id="55" class="gradeC">
446      <td>Misc</td>
447      <td>IE Mobile</td>
448      <td>Windows Mobile 6</td>
449      <td class="center">-</td>
450      <td class="center">C</td>
451    </tr>
452    <tr id="56" class="gradeC">
453      <td>Misc</td>
454      <td>PSP browser</td>
455      <td>PSP</td>
456      <td class="center">-</td>
457      <td class="center">C</td>
458    </tr>
459    <tr id="57" class="gradeU">
460      <td>Other browsers</td>
461      <td>All others</td>
462      <td>-</td>
463      <td class="center">-</td>
464      <td class="center">U</td>
465    </tr>
466  </tbody>
467  <tfoot>
468    <tr>
469      <th>Rendering engine</th>
470      <th>Browser</th>
471      <th>Platform(s)</th>
472      <th>Engine version</th>
473      <th>CSS grade</th>
474    </tr>
475  </tfoot>
476</table>
477      </div>
478      <div class="spacer"></div>
479     
480     
481      <h1>Initialisation code</h1>
482      <pre>$(document).ready(function() {
483  /* Init DataTables */
484  var oTable = $('#example').dataTable();
485 
486  /* Apply the jEditable handlers to the table */
487  $('td', oTable.fnGetNodes()).editable( '../examples_support/editable_ajax.php', {
488    "callback": function( sValue, y ) {
489      var aPos = oTable.fnGetPosition( this );
490      oTable.fnUpdate( sValue, aPos[0], aPos[1] );
491    },
492    "submitdata": function ( value, settings ) {
493      return {
494        "row_id": this.parentNode.getAttribute('id'),
495        "column": oTable.fnGetPosition( this )[2]
496      };
497    },
498    "height": "14px"
499  } );
500} );</pre>
501     
502     
503      <h1>Other examples</h1>
504      <h2>Basic initialisation</h2>
505      <ul>
506        <li><a href="../basic_init/zero_config.html">Zero configuration</a></li>
507        <li><a href="../basic_init/filter_only.html">Feature enablement</a></li>
508        <li><a href="../basic_init/table_sorting.html">Sorting data</a></li>
509        <li><a href="../basic_init/multi_col_sort.html">Multi-column sorting</a></li>
510        <li><a href="../basic_init/multiple_tables.html">Multiple tables</a></li>
511        <li><a href="../basic_init/hidden_columns.html">Hidden columns</a></li>
512        <li><a href="../basic_init/dom.html">DOM positioning</a></li>
513        <li><a href="../basic_init/state_save.html">State saving</a></li>
514        <li><a href="../basic_init/alt_pagination.html">Alternative pagination styles</a></li>
515        <li>Scrolling:
516          <a href="../basic_init/scroll_x.html">Horizontal</a> /
517          <a href="../basic_init/scroll_y.html">Vertical</a> /
518          <a href="../basic_init/scroll_xy.html">Both</a> /
519          <a href="../basic_init/scroll_y_theme.html">Themed</a> /
520          <a href="../basic_init/scroll_y_infinite.html">Infinite</a>
521        </li>
522        <li><a href="../basic_init/language.html">Change language information (internationalisation)</a></li>
523        <li><a href="../basic_init/themes.html">ThemeRoller themes (Smoothness)</a></li>
524      </ul>
525     
526      <h2>Advanced initialisation</h2>
527      <ul>
528        <li><a href="../advanced_init/events_pre_init.html">Events (pre initialisation)</a></li>
529        <li><a href="../advanced_init/events_post_init.html">Events (post initialisation)</a></li>
530        <li><a href="../advanced_init/column_render.html">Column rendering</a></li>
531        <li><a href="../advanced_init/html_sort.html">Sorting without HTML tags</a></li>
532        <li><a href="../advanced_init/dom_multiple_elements.html">Multiple table controls (sDom)</a></li>
533        <li><a href="../advanced_init/length_menu.html">Defining length menu options</a></li>
534        <li><a href="../advanced_init/dom_toolbar.html">Custom toolbar (element) around table</a></li>
535        <li><a href="../advanced_init/highlight.html">Row highlighting with CSS</a></li>
536        <li><a href="../advanced_init/complex_header.html">Column grouping through col/row spans</a></li>
537        <li><a href="../advanced_init/row_grouping.html">Row grouping</a></li>
538        <li><a href="../advanced_init/row_callback.html">Row callback</a></li>
539        <li><a href="../advanced_init/footer_callback.html">Footer callback</a></li>
540        <li><a href="../advanced_init/language_file.html">Change language information from a file (internationalisation)</a></li>
541      </ul>
542     
543      <h2>Data sources</h2>
544      <ul>
545        <li><a href="../data_sources/dom.html">DOM</a></li>
546        <li><a href="../data_sources/js_array.html">Javascript array</a></li>
547        <li><a href="../data_sources/ajax.html">Ajax source</a></li>
548        <li><a href="../data_sources/server_side.html">Server side processing</a></li>
549      </ul>
550     
551      <h2>Server-side processing</h2>
552      <ul>
553        <li><a href="../server_side/server_side.html">Obtain server-side data</a></li>
554        <li><a href="../server_side/custom_vars.html">Add extra HTTP variables</a></li>
555        <li><a href="../server_side/post.html">Use HTTP POST</a></li>
556        <li><a href="../server_side/column_ordering.html">Custom column ordering (in callback data)</a></li>
557        <li><a href="../server_side/pipeline.html">Pipelining data (reduce Ajax calls for paging)</a></li>
558        <li><a href="../server_side/row_details.html">Show and hide details about a particular record</a></li>
559        <li><a href="../server_side/select_rows.html">User selectable rows (multiple rows)</a></li>
560      </ul>
561     
562      <h2>API</h2>
563      <ul>
564        <li><a href="../api/add_row.html">Dynamically add a new row</a></li>
565        <li><a href="../api/multi_filter.html">Individual column filtering (using "input" elements)</a></li>
566        <li><a href="../api/multi_filter_select.html">Individual column filtering (using "select" elements)</a></li>
567        <li><a href="../api/highlight.html">Highlight rows and columns</a></li>
568        <li><a href="../api/row_details.html">Show and hide details about a particular record</a></li>
569        <li><a href="../api/select_row.html">User selectable rows (multiple rows)</a></li>
570        <li><a href="../api/select_single_row.html">User selectable rows (single row) and delete rows</a></li>
571        <li><a href="../api/editable.html">Editable rows (with jEditable)</a></li>
572        <li><a href="../api/form.html">Submit form with elements in table</a></li>
573        <li><a href="../api/counter_column.html">Index column (static number column)</a></li>
574        <li><a href="../api/show_hide.html">Show and hide columns dynamically</a></li>
575        <li><a href="../api/api_in_init.html">API function use in initialisation object (callback)</a></li>
576        <li><a href="../api/tabs_and_scrolling.html">DataTables scrolling and tabs</a></li>
577        <li><a href="../api/regex.html">Regular expression filtering</a></li>
578      </ul>
579     
580      <h2>Plug-ins</h2>
581      <ul>
582        <li><a href="../plug-ins/plugin_api.html">Add custom API functions</a></li>
583        <li><a href="../plug-ins/sorting_plugin.html">Sorting and type detection</a></li>
584        <li><a href="../plug-ins/paging_plugin.html">Custom pagination controls</a></li>
585        <li><a href="../plug-ins/range_filtering.html">Range filtering / custom filtering</a></li>
586        <li><a href="../plug-ins/dom_sort.html">Live DOM sorting</a></li>
587        <li><a href="../plug-ins/html_sort.html">Automatic HTML type detection</a></li>
588      </ul>
589     
590     
591      <p>Please refer to the <a href="http://www.datatables.net/"><i>DataTables</i> documentation</a> for full information about its API properties and methods.</p>
592     
593     
594      <div id="footer" style="text-align:center;">
595        <span style="font-size:10px;">DataTables &copy; Allan Jardine 2008-2010</span>
596      </div>
597    </div>
598  </body>
599</html>
Note: See TracBrowser for help on using the repository browser.