Met dataTables csv opslaan.

Door Daniel van Seggelen op 25-08-2023 09:17

2.022 views

Ik heb met datatables via ajax de optie aangezet om JSON data naar ajax te sturen.


$('#dt_startpage_links,#dt_blog_content_links,#dt_blog_sidebar_links,#dt_startpage_articles,#dt_blog-sold,#dt_link-sold').dataTable( {

scrollX: true,
    processing: true,
    serverSide: true,

ajax: {
        url: '<?=HTML_ROOT?>inc/saveAjax.php',
        type: 'GET'
    },
	
		
 dom: 'Bfrtip',
        buttons: [

        { 
            extend: 'excelHtml5',
            text:'Excel', 
            className: 'excelbtn',
            filename: 'Account_details', 
            title: 'Account Details', 
            titleAttr: 'Excel', 
            exportOptions: { columns: [ 0, 1, 2, 3, 4 ] }
        }, { 
            extend: 'pdfHtml5', 
            text:'PSF',
            className: 'pdfbtn',
            filename: 'Account_details', 
            title: 'Account Details', 
            titleAttr: 'PDF', 
            exportOptions: { columns: [ 0, 1, 2, 3, 4 ] }
        }, { 
            extend: 'csv', 
            text:'CSV',
            className: 'csv',
            filename: 'Account_details', 
            title: 'Account Details', 
            titleAttr: 'Reports', 
            exportOptions: { columns: [ 0, 1, 2, 3, 4 ] }
        }
		],
	
 columnDefs: [ {
            className: 'dtr-control',
          orderable: false,
            targets: 0
        } ],
		order: [1, 'asc'],
   		 responsive: {
        details: {
            type: 'column'
        }
    },	
	
	"responsive": false,
	"pageLength": 100
} );

In save ajax krijg ik dit terug

echo json_encode($_GET);


{"draw":"1","columns":[{"data":"0","name":"","searchable":"true","orderable":"false","search":{"value":"","regex":"false"}},{"data":"1","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"2","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"3","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"4","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"5","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"6","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"7","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"8","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"9","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"10","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}},{"data":"11","name":"","searchable":"true","orderable":"true","search":{"value":"","regex":"false"}}],"order":[{"column":"1","dir":"asc"}],"start":"0","length":"100","search":{"value":"","regex":"false"},"_":"1692944175549"}

met print_r krijg ik dit:

Array ( [draw] => 1 [columns] => Array ( [0] => Array ( [data] => 0 [name] => [searchable] => true [orderable] => false [search] => Array ( [value] => [regex] => false ) ) [1] => Array ( [data] => 1 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [2] => Array ( [data] => 2 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [3] => Array ( [data] => 3 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [4] => Array ( [data] => 4 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [5] => Array ( [data] => 5 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [6] => Array ( [data] => 6 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [7] => Array ( [data] => 7 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [8] => Array ( [data] => 8 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [9] => Array ( [data] => 9 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [10] => Array ( [data] => 10 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) [11] => Array ( [data] => 11 [name] => [searchable] => true [orderable] => true [search] => Array ( [value] => [regex] => false ) ) ) [order] => Array ( [0] => Array ( [column] => 1 [dir] => asc ) ) [start] => 0 [length] => 100 [search] => Array ( [value] => [regex] => false ) [_] => 1692944175549 )

De kolomnamen en waarden komen er niet in terug.

De knoppen werken bij het downloaden clientside wel, maar ik wil deze nu op de server hebben via PHP.

Hoop dat iemand me hints kan geven igg bedankt!