DataTables buttons and bootstrap 3
How do I make an datatables buttons and bootstrap 3?
DataTables styled with bootstrap 3. Customised column visibility button, showing the number of visible columns and a customised pagination. This also shows how to use the DOM option when using bootstrap and dataTables.. What is a datatables buttons and bootstrap 3? How do you make a datatables buttons and bootstrap 3? This script and codes were developed by Dirk Drijkoningen on 19 January 2023, Thursday.
DataTables buttons and bootstrap 3 - Script Codes HTML Codes
<!DOCTYPE html>
<html >
<head> <meta charset="UTF-8"> <title>dataTables buttons and bootstrap 3</title> <link rel='stylesheet prefetch' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css'>
<link rel='stylesheet prefetch' href='https://cdn.datatables.net/1.10.12/css/dataTables.bootstrap.min.css'>
<link rel='stylesheet prefetch' href='https://cdn.datatables.net/buttons/1.2.2/css/buttons.bootstrap.min.css'> <link rel="stylesheet" href="css/style.css">
</head>
<body> <a class="btn btn-success" style="margin-bottom:16px;" href="https://codepen.io/collection/XKgNLN/" target="_blank">Other examples on Codepen</a>
<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%"> <thead> <tr> <th>Order</th> <th>Description</th> <th>Deadline</th> <th>Status</th> <th>Amount</th> </tr> </thead> <tbody> <tr> <td>1</td> <td>Alphabet puzzle</td> <td>2016/01/15</td> <td>Done</td> <td data-order="1000">€1.000,00</td> </tr> <tr> <td>2</td> <td>Layout for poster</td> <td>2016/01/31</td> <td>Planned</td> <td data-order="1834">€1.834,00</td> </tr> <tr> <td>3</td> <td>Image creation</td> <td>2016/01/23</td> <td>To Do</td> <td data-order="1500">€1.500,00</td> </tr> <tr> <td>4</td> <td>Create font</td> <td>2016/02/26</td> <td>Done</td> <td data-order="1200">€1.200,00</td> </tr> <tr> <td>5</td> <td>Sticker production</td> <td>2016/02/18</td> <td>Planned</td> <td data-order="2100">€2.100,00</td> </tr> <tr> <td>6</td> <td>Glossy poster</td> <td>2016/03/17</td> <td>To Do</td> <td data-order="899">€899,00</td> </tr> <tr> <td>7</td> <td>Beer label</td> <td>2016/05/28</td> <td>Confirmed</td> <td data-order="2499">€2.499,00</td> </tr> <tr> <td>8</td> <td>Shop sign</td> <td>2016/04/19</td> <td>Offer</td> <td data-order="1099">€1.099,00</td> </tr> <tr> <td>9</td> <td>X-Mas decoration</td> <td>2016/10/31</td> <td>Confirmed</td> <td data-order="1750">€1.750,00</td> </tr> <tr> <td>10</td> <td>Halloween invite</td> <td>2016/09/12</td> <td>Planned</td> <td data-order="400">€400,00</td> </tr> <tr> <td>11</td> <td>Wedding announcement</td> <td>2016/07/09</td> <td>To Do</td> <td data-order="299">€299,00</td> </tr> <tr> <td>12</td> <td>Member pasport</td> <td>2016/06/22</td> <td>Offer</td> <td data-order="149">€149,00</td> </tr> <tr> <td>13</td> <td>Drink tickets</td> <td>2016/11/01</td> <td>Confirmed</td> <td data-order="199">€199,00</td> </tr> <tr> <td>14</td> <td>Album cover</td> <td>2017/03/15</td> <td>To Do</td> <td data-order="4999">€4.999,00</td> </tr> <tr> <td>15</td> <td>Shipment box</td> <td>2017/02/08</td> <td>Offer</td> <td data-order="1399">€1.399,00</td> </tr> <tr> <td>16</td> <td>Wooden puzzle</td> <td>2017/01/11</td> <td>Done</td> <td data-order="1000">€1.000,00</td> </tr> <tr> <td>17</td> <td>Fashion Layout</td> <td>2016/01/30</td> <td>Planned</td> <td data-order="1834">€1.834,00</td> </tr> <tr> <td>18</td> <td>Toy creation</td> <td>2016/01/10</td> <td>To Do</td> <td data-order="1550">€1.550,00</td> </tr> <tr> <td>19</td> <td>Create stamps</td> <td>2016/02/26</td> <td>Done</td> <td data-order="1220">€1.220,00</td> </tr> <tr> <td>20</td> <td>Sticker design</td> <td>2017/02/18</td> <td>Planned</td> <td data-order="2100">€2.100,00</td> </tr> <tr> <td>21</td> <td>Poster rock concert</td> <td>2017/04/17</td> <td>To Do</td> <td data-order="899">€899,00</td> </tr> <tr> <td>22</td> <td>Wine label</td> <td>2017/05/28</td> <td>Confirmed</td> <td data-order="2799">€2.799,00</td> </tr> <tr> <td>23</td> <td>Shopping bag</td> <td>2017/04/19</td> <td>Offer</td> <td data-order="1299">€1.299,00</td> </tr> <tr> <td>24</td> <td>Decoration for Easter</td> <td>2017/10/31</td> <td>Confirmed</td> <td data-order="1650">€1.650,00</td> </tr> <tr> <td>25</td> <td>Saint Nicolas colorbook</td> <td>2017/09/12</td> <td>Planned</td> <td data-order="510">€510,00</td> </tr> <tr> <td>26</td> <td>Wedding invites</td> <td>2017/07/09</td> <td>To Do</td> <td data-order="399">€399,00</td> </tr> <tr> <td>27</td> <td>Member pasport</td> <td>2017/06/22</td> <td>Offer</td> <td data-order="249">€249,00</td> </tr> <tr> <td>28</td> <td>Drink tickets</td> <td>2017/11/01</td> <td>Confirmed</td> <td data-order="199">€199,00</td> </tr> <tr> <td>29</td> <td>Blue-Ray cover</td> <td>2018/03/15</td> <td>To Do</td> <td data-order="1999">€1.999,00</td> </tr> <tr> <td>30</td> <td>TV carton</td> <td>2019/02/08</td> <td>Offer</td> <td data-order="1369">€1.369,00</td> </tr> </tbody>
</table> <script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.0/jquery.min.js'></script>
<script src='https://cdn.datatables.net/1.10.12/js/jquery.dataTables.min.js'></script>
<script src='https://cdn.datatables.net/buttons/1.2.2/js/dataTables.buttons.min.js'></script>
<script src='https://cdn.datatables.net/buttons/1.2.2/js/buttons.colVis.min.js'></script>
<script src='https://cdn.datatables.net/buttons/1.2.2/js/buttons.html5.min.js'></script>
<script src='https://cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js'></script>
<script src='https://cdn.datatables.net/1.10.12/js/dataTables.bootstrap.min.js'></script>
<script src='https://cdn.datatables.net/buttons/1.2.2/js/buttons.bootstrap.min.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js'></script>
<script src='https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js'></script>
<script src='https://cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js'></script> <script src="js/index.js"></script>
</body>
</html>
DataTables buttons and bootstrap 3 - Script Codes CSS Codes
body {margin:2em;}
ul.dt-button-collection{ background-color: #e5e5e5; border: 1px solid #c0c0c0;
}
li.dt-button a:hover{ background-color: transparent; color: #115094; font-weight: bold;
}
li.dt-button.active a,
li.dt-button.active a:hover,
li.dt-button.active a:focus{ color: #337ab6; background-color: transparent; font-weight: bold;
}
li.dt-button.active a::before{ content: '✔ ';
}
.dataTables_info { font-size: 0.8em; margin-top: -12px; text-align: right;
}
.previous a,
.next a
{ font-weight: bold;
}
DataTables buttons and bootstrap 3 - Script Codes JS Codes
$(document).ready(function() { //Only needed for the filename of export files. //Normally set in the title tag of your page.document.title = 'Simple DataTable'; //Define hidden columns var hCols = [3, 4]; // DataTable initialisation $('#example').DataTable({ "dom": "<'row'<'col-sm-4'B><'col-sm-2'l><'col-sm-6'p<br/>i>>" + "<'row'<'col-sm-12'tr>>" + "<'row'<'col-sm-12'p<br/>i>>", "paging": true, "autoWidth": true, "columnDefs": [{ "visible": false, "targets": hCols }], "buttons": [{ extend: 'colvis', collectionLayout: 'three-column', text: function() { var totCols = $('#example thead th').length; var hiddenCols = hCols.length; var shownCols = totCols - hiddenCols; return 'Columns (' + shownCols + ' of ' + totCols + ')'; }, prefixButtons: [{ extend: 'colvisGroup', text: 'Show all', show: ':hidden' }, { extend: 'colvisRestore', text: 'Restore' }] }, { extend: 'collection', text: 'Export', buttons: [{ text: 'Excel', extend: 'excelHtml5', footer: false, exportOptions: { columns: ':visible' } }, { text: 'CSV', extend: 'csvHtml5', fieldSeparator: ';', exportOptions: { columns: ':visible' } }, { text: 'PDF Portrait', extend: 'pdfHtml5', message: '', exportOptions: { columns: ':visible' } }, { text: 'PDF Landscape', extend: 'pdfHtml5', message: '', orientation: 'landscape', exportOptions: { columns: ':visible' } }] }] ,oLanguage: { oPaginate: { sNext: '<span class="pagination-default">❯</span>', sPrevious: '<span class="pagination-default">❮</span>' } } ,"initComplete": function(settings, json) { // Adjust hidden columns counter text in button --> $('#example').on('column-visibility.dt', function(e, settings, column, state) { var visCols = $('#example thead tr:first th').length; //Below: The minus 2 because of the 2 extra buttons Show all and Restore var tblCols = $('.dt-button-collection li[aria-controls=example] a').length - 2; $('.buttons-colvis[aria-controls=example] span').html('Columns (' + visCols + ' of ' + tblCols + ')'); e.stopPropagation(); }); } }); });
![DataTables buttons and bootstrap 3 - Script Codes](http://shots.codepen.io/RedJokingInn/pen/RpddaE-512.jpg)
Developer | Dirk Drijkoningen |
Username | RedJokingInn |
Uploaded | January 19, 2023 |
Rating | 3 |
Size | 3,998 Kb |
Views | 12,144 |
Find the perfect freelance services for your business! Fiverr's mission is to change how the world works together. Fiverr connects businesses with freelancers offering digital services in 500+ categories. Find Developer!
Name | Size |
Horizontal rule decorations | 1,874 Kb |
Functie en array | 1,477 Kb |
Testtekening | 2,108 Kb |
Fixed table header | 2,995 Kb |
For loop | 1,388 Kb |
Maanden en dagen | 1,383 Kb |
Just a test | 3,868 Kb |
DataTables conditional row styling | 3,136 Kb |
DataTables percentage bar renderer plugin v1.1 | 3,513 Kb |
DataTables Excel Header and Footer | 3,702 Kb |
Jasper is the AI Content Generator that helps you and your team break through creative blocks to create amazing, original content 10X faster. Discover all the ways the Jasper AI Content Platform can help streamline your creative workflows. Start For Free!
Name | Username | Size |
Day 1 - Portfolio | Chpecson | 3,532 Kb |
Next Word Predictor | Rfalor | 2,776 Kb |
Super Discount | Orrinward | 3,225 Kb |
SVG Text Masking | JMChristensen | 2,141 Kb |
Sitemap generator for Sharepoint | Gyusza | 2,518 Kb |
Exploding Text | Jjmartucci | 4,749 Kb |
Formations | Cantelope | 5,731 Kb |
Apex Calculator | Michaelwnelson | 2,370 Kb |
Weather App | Kw7oe | 3,162 Kb |
RAQuote | Naderk007 | 4,412 Kb |
Surf anonymously, prevent hackers from acquiring your IP address, send anonymous email, and encrypt your Internet connection. High speed, ultra secure, and easy to use. Instant setup. Hide Your IP Now!