Search Box, Paging, Showing Entries And Button Export to Excel not Showing

armstronge

Hello guys, can you help me. I've got table but Search Box, Paging, Showing Entries And Button Export to Excel not Showing. Here's the test link http://live.datatables.net/tipaqede/5/edit

armstronge

i've try to check the console panel and appear 3 error like this
http://prntscr.com/kn81e6

armstronge

'''
font-awesome.min.css:1 Failed to load resource: the server responded with a status of 404 (Not Found)
script.js:143 Uncaught SyntaxError: Unexpected token :
jquery.min.js:2 jQuery.Deferred exception: Cannot read property 'mData' of undefined TypeError: Cannot read property 'mData' of undefined
at HTMLTableCellElement.<anonymous> (https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js:90:259)
at Function.each (https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js:2:2715)
at r.fn.init.each (https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js:2:1003)
at HTMLTableElement.<anonymous> (https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js:90:214)
at Function.each (https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js:2:2715)
at r.fn.init.each (https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js:2:1003)
at r.fn.init.n [as dataTable] (https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js:83:199)
at r.fn.init.h.fn.DataTable (https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js:165:488)
at HTMLDocument.<anonymous> (http://localhost:8080/CRUD/data_booking.php:85:32)
at j (https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js:2:29999) undefined
r.Deferred.exceptionHook @ jquery.min.js:2
jquery.min.js:2 Uncaught TypeError: Cannot read property 'mData' of undefined
at HTMLTableCellElement.<anonymous> (jquery.dataTables.min.js:90)
at Function.each (jquery.min.js:2)
at r.fn.init.each (jquery.min.js:2)
at HTMLTableElement.<anonymous> (jquery.dataTables.min.js:90)
at Function.each (jquery.min.js:2)
at r.fn.init.each (jquery.min.js:2)
at r.fn.init.n [as dataTable] (jquery.dataTables.min.js:83)
at r.fn.init.h.fn.DataTable (jquery.dataTables.min.js:165)
at HTMLDocument.<anonymous> (data_booking.php:85)
at j (jquery.min.js:2)
font-awesome.min.css:1 Failed to load resource: the server responded with a status of 404 (Not Found)
''''

allan

Your HTML wasn't valid for DataTables. It requires thead and tbody elements. Adding them and removing the HTML from your Javascript panel shows the Excel export button: http://live.datatables.net/tipaqede/6/edit

Allan