Advanced Table

Search, pagination, data export and auto save (local storage)

ID User Infos Other
Image Firstname Lastname Birthday Postal code Email Date Date Time Time Country City Amount Phone IP address User ID Car Referer
#1 Jean Dupont Jean Dupont 15/04/1985 15:50 75001 jean.dupont@example.com 2024-05-12 2024-05-12 12:10 12:10:00 France Paris € 1 250.75 +33 6 12 34 ** ** 192.168.1.23 AzureSpirit Toyota Google
#2 Marie Durand Marie Durand 22/08/1990 08:12 69001 marie.durand@example.com 2024-05-12 2024-05-12 17:45 17:45:20 Belgique Bruxelles € 500.00 +34 6 23 45 ** ** 10.20.30.40 SeraphimWings Honda Facebook
#3 Luc Martin Luc Martin 10/10/1978 07:12 13001 luc.martin@example.com 2024-03-05 2024-03-05 21:30 21:30:45 France Marseille € 3 750.25 +32 6 34 56 ** ** 172.16.254.12 CelestialWhisper Ford YouTube
#4 Anne Bernard Anne Bernard 15/01/1982 00:00 33000 anne.bernard@example.com 2023-11-30 2023-11-30 14:12 14:12:00 Suisse Genève € 1 200,75 +33 6 45 67 ** ** 131.234.56.78 MysticalEcho Chevrolet Amazon
#5 Paul Petit Paul Petit 30/06/1995 09:00 44000 paul.petit@example.com 2024-01-25 2024-01-25 15:55 15:55:50 France Nantes € 2 500.30 +33 6 56 78 ** ** 88.99.77.66 EmeraldPhoenix Nissan Twitter
#6 Clara Moreau Clara Moreau 05/05/1987 11:00 06000 clara.moreau@example.com 2023-12-01 2023-12-01 11:20 11:20:15 France Nice € 950.30 +33 6 67 89 ** ** 203.0.113.55 LunarCascade BMW Instagram
#7 Hugo Lefevre Hugo Lefevre 20/07/1975 20:20 67000 hugo.lefevre@example.com 2024-02-28 2024-02-28 08:23 08:23:35 France Strasbourg € 145.60 +33 6 78 90 ** ** 198.51.100.22 SolarFlare Audi LinkedIn
#8 Eva Faure Eva Faure 11/11/1992 09:12 31000 eva.faure@example.com 2024-04-10 2024-04-10 16:00 16:00:12 France Toulouse € 1 500.85 +33 6 89 01 ** ** 123.45.67.89 CrimsonDragon Mercedes-Benz Reddit
#9 Antoine Roux Antoine Roux 03/09/1989 14:50 38000 antoine.roux@example.com 2023-09-20 2023-09-20 13:45 13:45:00 France Grenoble € 2 750.75 +33 6 90 12 ** ** 75.42.99.101 WhisperingWillow Volkswagen Wikipedia
#10 Laura Giraud Laura Giraud 25/12/1990 10:20 34000 laura.giraud@example.com 2024-05-12 2024-05-12 09:15 09:15:30 France Montpellier € 1 750.95 +33 6 01 23 ** ** 112.87.54.33 NebulaDream Subaru Netflix
#11 Marie Dubois Marie Dubois 22/06/1990 10:15 75002 marie.dubois@example.com 2024-05-13 2024-05-13 09:45 09:45:00 France Paris € 1 500.80 +33 6 23 45 ** ** 192.168.1.24 GoldenFox Peugeot Bing
#12 Luc Martin Luc Martin 03/03/1988 08:30 69001 luc.martin@example.com 2024-05-14 2024-05-14 08:20 08:20:00 France Lyon € 2 000.00 +33 6 34 56 ** ** 192.168.1.25 ShadowHunter Renault Yahoo
#13 Sophie Leroy Sophie Leroy 18/09/1995 14:45 33000 sophie.leroy@example.com 2024-05-15 2024-05-15 14:30 14:30:00 France Bordeaux € 1 800.50 +33 6 45 67 ** ** 192.168.1.26 NightWolf Citroën DuckDuckGo
#14 Pierre Lefevre Pierre Lefevre 07/12/1982 11:25 75003 pierre.lefevre@example.com 2024-05-16 2024-05-16 11:10 11:10:00 France Paris € 2 250.75 +33 6 56 78 ** ** 192.168.1.27 SilverTiger Fiat Ask
#15 Claire Moreau Claire Moreau 25/11/1987 16:40 75004 claire.moreau@example.com 2024-05-17 2024-05-17 16:30 16:30:00 France Paris € 2 750.60 +33 6 67 89 ** ** 192.168.1.28 RedEagle Opel Ecosia
#16 Nicolas Bernard Nicolas Bernard 13/07/1993 12:50 34000 nicolas.bernard@example.com 2024-05-18 2024-05-18 12:40 12:40:00 France Montpellier € 3 150.20 +33 6 78 90 ** ** 192.168.1.29 BlueHawk BMW StartPage
#17 Emilie Dubois Emilie Dubois 05/05/1991 09:55 69002 emilie.dubois@example.com 2024-05-19 2024-05-19 09:40 09:40:00 France Lyon € 2 950.10 +33 6 89 01 ** ** 192.168.1.30 GoldenLion Audi SearchEncrypt
#18 Antoine Lefevre Antoine Lefevre 29/08/1984 13:20 31000 antoine.lefevre@example.com 2024-05-20 2024-05-20 13:10 13:10:00 France Toulouse € 2 350.55 +33 6 90 12 ** ** 192.168.1.31 ShadowPhoenix Mercedes Qwant
#19 Isabelle Martin Isabelle Martin 12/02/1986 18:35 13000 isabelle.martin@example.com 2024-05-21 2024-05-21 18:25 18:25:00 France Marseille € 3 550.40 +33 6 01 23 ** ** 192.168.1.32 WhiteFalcon Ford WebCrawler
#20 Julie Fournier Julie Fournier 17/10/1992 07:45 76000 julie.fournier@example.com 2024-05-22 2024-05-22 07:30 07:30:00 France Rouen € 2 150.70 +33 6 23 45 ** ** 192.168.1.33 IronWolf Volkswagen Dogpile
Initialize plugin
let table = $('#table');
                
table.table({
    input_search: '#table-search',
    select_rows: '#table-filter',
    pagination: '#table-pagin',
    sorting: [0, 'desc'],
    no_sorting: [1],
    current_page: 1,
    pages_per_nav: 1, 
    rows_per_page: 5,
    saving: true
});
Export datatable to csv string

Export table including search and pagination

$('.btn-csv').on('click', function() {
    let win = window.open(''),
        val = table.tableExport('csv', {
            enclosure: '"',
            delimiter: ';'
        });
    win.document.write(val);            
});    
Export datatable to json string

Export table excluding search and pagination

$('.btn-json').on('click', function() {
    let win = window.open(''),
        val = table.tableExport('json', {
            stringify: true,
            allrows: true
        });
    win.document.write(val);    
});