null_data_source.html 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <link rel="shortcut icon" type="image/ico" href="http://www.datatables.net/favicon.ico">
  6. <meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">
  7. <title>DataTables example - Generated content for a column</title>
  8. <link rel="stylesheet" type="text/css" href="../../media/css/jquery.dataTables.css">
  9. <link rel="stylesheet" type="text/css" href="../resources/syntax/shCore.css">
  10. <link rel="stylesheet" type="text/css" href="../resources/demo.css">
  11. <style type="text/css" class="init">
  12. </style>
  13. <script type="text/javascript" language="javascript" src="../../media/js/jquery.js"></script>
  14. <script type="text/javascript" language="javascript" src="../../media/js/jquery.dataTables.js"></script>
  15. <script type="text/javascript" language="javascript" src="../resources/syntax/shCore.js"></script>
  16. <script type="text/javascript" language="javascript" src="../resources/demo.js"></script>
  17. <script type="text/javascript" language="javascript" class="init">
  18. $(document).ready(function() {
  19. var table = $('#example').DataTable( {
  20. "ajax": "data/arrays.txt",
  21. "columnDefs": [ {
  22. "targets": -1,
  23. "data": null,
  24. "defaultContent": "<button>Click!</button>"
  25. } ]
  26. } );
  27. $('#example tbody').on( 'click', 'button', function () {
  28. var data = table.row( $(this).parents('tr') ).data();
  29. alert( data[0] +"'s salary is: "+ data[ 5 ] );
  30. } );
  31. } );
  32. </script>
  33. </head>
  34. <body class="dt-example">
  35. <div class="container">
  36. <section>
  37. <h1>DataTables example <span>Generated content for a column</span></h1>
  38. <div class="info">
  39. <p>In some tables you might wish to have some content generated automatically. This can be done in a
  40. number of ways:</p>
  41. <ul class="markdown">
  42. <li><a href="//datatables.net/reference/option/columns.render"><code class="option" title=
  43. "DataTables initialisation option">columns.render<span>DT</span></code></a> for content that is
  44. dynamic (i.e. based upon the row's data)</li>
  45. <li><a href="//datatables.net/reference/option/columns.defaultContent"><code class="option" title=
  46. "DataTables initialisation option">columns.defaultContent<span>DT</span></code></a> for static
  47. content (i.e. simple strings)</li>
  48. </ul>
  49. <p>This examples shows the use of <a href=
  50. "//datatables.net/reference/option/columns.defaultContent"><code class="option" title=
  51. "DataTables initialisation option">columns.defaultContent<span>DT</span></code></a> to create a
  52. <em>button</em> element in the last column of the table. A simple jQuery <code>click</code> event
  53. listener is used to watch for clicks on the row, and when activated uses the <a href=
  54. "//datatables.net/reference/api/row().data()"><code class="api" title=
  55. "DataTables API method">row().data()<span>DT</span></code></a> method to get the data for the row and
  56. show a bit of information about it in an <code>alert</code> box. This is a simple use case, but it can
  57. be built up to be arbitrarily complex.</p>
  58. <p>Note also that the <a href="//datatables.net/reference/option/columns.data"><code class="option"
  59. title="DataTables initialisation option">columns.data<span>DT</span></code></a> option for the column
  60. has been set to <code>null</code> to indicate that the column has no information that should be
  61. obtained data source object.</p>
  62. </div>
  63. <table id="example" class="display" cellspacing="0" width="100%">
  64. <thead>
  65. <tr>
  66. <th>Name</th>
  67. <th>Position</th>
  68. <th>Office</th>
  69. <th>Extn.</th>
  70. <th>Start date</th>
  71. <th>Salary</th>
  72. </tr>
  73. </thead>
  74. <tfoot>
  75. <tr>
  76. <th>Name</th>
  77. <th>Position</th>
  78. <th>Office</th>
  79. <th>Extn.</th>
  80. <th>Start date</th>
  81. <th>Salary</th>
  82. </tr>
  83. </tfoot>
  84. </table>
  85. <ul class="tabs">
  86. <li class="active">Javascript</li>
  87. <li>HTML</li>
  88. <li>CSS</li>
  89. <li>Ajax</li>
  90. <li>Server-side script</li>
  91. </ul>
  92. <div class="tabs">
  93. <div class="js">
  94. <p>The Javascript shown below is used to initialise the table shown in this
  95. example:</p><code class="multiline brush: js;">$(document).ready(function() {
  96. var table = $('#example').DataTable( {
  97. &quot;ajax&quot;: &quot;data/arrays.txt&quot;,
  98. &quot;columnDefs&quot;: [ {
  99. &quot;targets&quot;: -1,
  100. &quot;data&quot;: null,
  101. &quot;defaultContent&quot;: &quot;&lt;button&gt;Click!&lt;/button&gt;&quot;
  102. } ]
  103. } );
  104. $('#example tbody').on( 'click', 'button', function () {
  105. var data = table.row( $(this).parents('tr') ).data();
  106. alert( data[0] +&quot;'s salary is: &quot;+ data[ 5 ] );
  107. } );
  108. } );</code>
  109. <p>In addition to the above code, the following Javascript library files are loaded for use in this
  110. example:</p>
  111. <ul>
  112. <li><a href="../../media/js/jquery.js">../../media/js/jquery.js</a></li>
  113. <li><a href="../../media/js/jquery.dataTables.js">../../media/js/jquery.dataTables.js</a></li>
  114. </ul>
  115. </div>
  116. <div class="table">
  117. <p>The HTML shown below is the raw HTML table element, before it has been enhanced by
  118. DataTables:</p>
  119. </div>
  120. <div class="css">
  121. <div>
  122. <p>This example uses a little bit of additional CSS beyond what is loaded from the library
  123. files (below), in order to correctly display the table. The additional CSS used is shown
  124. below:</p><code class="multiline brush: js;"></code>
  125. </div>
  126. <p>The following CSS library files are loaded for use in this example to provide the styling of the
  127. table:</p>
  128. <ul>
  129. <li><a href=
  130. "../../media/css/jquery.dataTables.css">../../media/css/jquery.dataTables.css</a></li>
  131. </ul>
  132. </div>
  133. <div class="ajax">
  134. <p>This table loads data by Ajax. The latest data that has been loaded is shown below. This data
  135. will update automatically as any additional data is loaded.</p>
  136. </div>
  137. <div class="php">
  138. <p>The script used to perform the server-side processing for this table is shown below. Please note
  139. that this is just an example script using PHP. Server-side processing scripts can be written in any
  140. language, using <a href="//datatables.net/manual/server-side">the protocol described in the
  141. DataTables documentation</a>.</p>
  142. </div>
  143. </div>
  144. </section>
  145. </div>
  146. <section>
  147. <div class="footer">
  148. <div class="gradient"></div>
  149. <div class="liner">
  150. <h2>Other examples</h2>
  151. <div class="toc">
  152. <div class="toc-group">
  153. <h3><a href="../basic_init/index.html">Basic initialisation</a></h3>
  154. <ul class="toc">
  155. <li><a href="../basic_init/zero_configuration.html">Zero configuration</a></li>
  156. <li><a href="../basic_init/filter_only.html">Feature enable / disable</a></li>
  157. <li><a href="../basic_init/table_sorting.html">Default ordering (sorting)</a></li>
  158. <li><a href="../basic_init/multi_col_sort.html">Multi-column ordering</a></li>
  159. <li><a href="../basic_init/multiple_tables.html">Multiple tables</a></li>
  160. <li><a href="../basic_init/hidden_columns.html">Hidden columns</a></li>
  161. <li><a href="../basic_init/complex_header.html">Complex headers (rowspan and
  162. colspan)</a></li>
  163. <li><a href="../basic_init/dom.html">DOM positioning</a></li>
  164. <li><a href="../basic_init/flexible_width.html">Flexible table width</a></li>
  165. <li><a href="../basic_init/state_save.html">State saving</a></li>
  166. <li><a href="../basic_init/alt_pagination.html">Alternative pagination</a></li>
  167. <li><a href="../basic_init/scroll_y.html">Scroll - vertical</a></li>
  168. <li><a href="../basic_init/scroll_x.html">Scroll - horizontal</a></li>
  169. <li><a href="../basic_init/scroll_xy.html">Scroll - horizontal and vertical</a></li>
  170. <li><a href="../basic_init/scroll_y_theme.html">Scroll - vertical with jQuery UI
  171. ThemeRoller</a></li>
  172. <li><a href="../basic_init/comma-decimal.html">Language - Comma decimal place</a></li>
  173. <li><a href="../basic_init/language.html">Language options</a></li>
  174. </ul>
  175. </div>
  176. <div class="toc-group">
  177. <h3><a href="../advanced_init/index.html">Advanced initialisation</a></h3>
  178. <ul class="toc">
  179. <li><a href="../advanced_init/events_live.html">DOM / jQuery events</a></li>
  180. <li><a href="../advanced_init/dt_events.html">DataTables events</a></li>
  181. <li><a href="../advanced_init/column_render.html">Column rendering</a></li>
  182. <li><a href="../advanced_init/length_menu.html">Page length options</a></li>
  183. <li><a href="../advanced_init/dom_multiple_elements.html">Multiple table control
  184. elements</a></li>
  185. <li><a href="../advanced_init/complex_header.html">Complex headers (rowspan /
  186. colspan)</a></li>
  187. <li><a href="../advanced_init/html5-data-attributes.html">HTML5 data-* attributes</a></li>
  188. <li><a href="../advanced_init/language_file.html">Language file</a></li>
  189. <li><a href="../advanced_init/defaults.html">Setting defaults</a></li>
  190. <li><a href="../advanced_init/row_callback.html">Row created callback</a></li>
  191. <li><a href="../advanced_init/row_grouping.html">Row grouping</a></li>
  192. <li><a href="../advanced_init/footer_callback.html">Footer callback</a></li>
  193. <li><a href="../advanced_init/dom_toolbar.html">Custom toolbar elements</a></li>
  194. <li><a href="../advanced_init/sort_direction_control.html">Order direction sequence
  195. control</a></li>
  196. </ul>
  197. </div>
  198. <div class="toc-group">
  199. <h3><a href="../styling/index.html">Styling</a></h3>
  200. <ul class="toc">
  201. <li><a href="../styling/display.html">Base style</a></li>
  202. <li><a href="../styling/no-classes.html">Base style - no styling classes</a></li>
  203. <li><a href="../styling/cell-border.html">Base style - cell borders</a></li>
  204. <li><a href="../styling/compact.html">Base style - compact</a></li>
  205. <li><a href="../styling/hover.html">Base style - hover</a></li>
  206. <li><a href="../styling/order-column.html">Base style - order-column</a></li>
  207. <li><a href="../styling/row-border.html">Base style - row borders</a></li>
  208. <li><a href="../styling/stripe.html">Base style - stripe</a></li>
  209. <li><a href="../styling/bootstrap.html">Bootstrap</a></li>
  210. <li><a href="../styling/foundation.html">Foundation</a></li>
  211. <li><a href="../styling/jqueryUI.html">jQuery UI ThemeRoller</a></li>
  212. </ul>
  213. </div>
  214. <div class="toc-group">
  215. <h3><a href="../data_sources/index.html">Data sources</a></h3>
  216. <ul class="toc">
  217. <li><a href="../data_sources/dom.html">HTML (DOM) sourced data</a></li>
  218. <li><a href="../data_sources/ajax.html">Ajax sourced data</a></li>
  219. <li><a href="../data_sources/js_array.html">Javascript sourced data</a></li>
  220. <li><a href="../data_sources/server_side.html">Server-side processing</a></li>
  221. </ul>
  222. </div>
  223. <div class="toc-group">
  224. <h3><a href="../api/index.html">API</a></h3>
  225. <ul class="toc">
  226. <li><a href="../api/add_row.html">Add rows</a></li>
  227. <li><a href="../api/multi_filter.html">Individual column searching (text inputs)</a></li>
  228. <li><a href="../api/multi_filter_select.html">Individual column searching (select
  229. inputs)</a></li>
  230. <li><a href="../api/highlight.html">Highlighting rows and columns</a></li>
  231. <li><a href="../api/row_details.html">Child rows (show extra / detailed
  232. information)</a></li>
  233. <li><a href="../api/select_row.html">Row selection (multiple rows)</a></li>
  234. <li><a href="../api/select_single_row.html">Row selection and deletion (single
  235. row)</a></li>
  236. <li><a href="../api/form.html">Form inputs</a></li>
  237. <li><a href="../api/counter_columns.html">Index column</a></li>
  238. <li><a href="../api/show_hide.html">Show / hide columns dynamically</a></li>
  239. <li><a href="../api/api_in_init.html">Using API in callbacks</a></li>
  240. <li><a href="../api/tabs_and_scrolling.html">Scrolling and jQuery UI tabs</a></li>
  241. <li><a href="../api/regex.html">Search API (regular expressions)</a></li>
  242. </ul>
  243. </div>
  244. <div class="toc-group">
  245. <h3><a href="./index.html">Ajax</a></h3>
  246. <ul class="toc active">
  247. <li><a href="./simple.html">Ajax data source (arrays)</a></li>
  248. <li><a href="./objects.html">Ajax data source (objects)</a></li>
  249. <li><a href="./deep.html">Nested object data (objects)</a></li>
  250. <li><a href="./objects_subarrays.html">Nested object data (arrays)</a></li>
  251. <li><a href="./orthogonal-data.html">Orthogonal data</a></li>
  252. <li class="active"><a href="./null_data_source.html">Generated content for a
  253. column</a></li>
  254. <li><a href="./custom_data_property.html">Custom data source property</a></li>
  255. <li><a href="./custom_data_flat.html">Flat array data source</a></li>
  256. <li><a href="./defer_render.html">Deferred rendering for speed</a></li>
  257. </ul>
  258. </div>
  259. <div class="toc-group">
  260. <h3><a href="../server_side/index.html">Server-side</a></h3>
  261. <ul class="toc">
  262. <li><a href="../server_side/simple.html">Server-side processing</a></li>
  263. <li><a href="../server_side/custom_vars.html">Custom HTTP variables</a></li>
  264. <li><a href="../server_side/post.html">POST data</a></li>
  265. <li><a href="../server_side/ids.html">Automatic addition of row ID attributes</a></li>
  266. <li><a href="../server_side/object_data.html">Object data source</a></li>
  267. <li><a href="../server_side/row_details.html">Row details</a></li>
  268. <li><a href="../server_side/select_rows.html">Row selection</a></li>
  269. <li><a href="../server_side/jsonp.html">JSONP data source for remote domains</a></li>
  270. <li><a href="../server_side/defer_loading.html">Deferred loading of data</a></li>
  271. <li><a href="../server_side/pipeline.html">Pipelining data to reduce Ajax calls for
  272. paging</a></li>
  273. </ul>
  274. </div>
  275. <div class="toc-group">
  276. <h3><a href="../plug-ins/index.html">Plug-ins</a></h3>
  277. <ul class="toc">
  278. <li><a href="../plug-ins/api.html">API plug-in methods</a></li>
  279. <li><a href="../plug-ins/sorting_auto.html">Ordering plug-ins (with type
  280. detection)</a></li>
  281. <li><a href="../plug-ins/sorting_manual.html">Ordering plug-ins (no type
  282. detection)</a></li>
  283. <li><a href="../plug-ins/range_filtering.html">Custom filtering - range search</a></li>
  284. <li><a href="../plug-ins/dom_sort.html">Live DOM ordering</a></li>
  285. </ul>
  286. </div>
  287. </div>
  288. <div class="epilogue">
  289. <p>Please refer to the <a href="http://www.datatables.net">DataTables documentation</a> for full
  290. information about its API properties and methods.<br>
  291. Additionally, there are a wide range of <a href="http://www.datatables.net/extras">extras</a> and
  292. <a href="http://www.datatables.net/plug-ins">plug-ins</a> which extend the capabilities of
  293. DataTables.</p>
  294. <p class="copyright">DataTables designed and created by <a href=
  295. "http://www.sprymedia.co.uk">SpryMedia Ltd</a> &#169; 2007-2014<br>
  296. DataTables is licensed under the <a href="http://www.datatables.net/mit">MIT license</a>.</p>
  297. </div>
  298. </div>
  299. </div>
  300. </section>
  301. </body>
  302. </html>