I recently created a Datatable which is pulling data from a .txt file with AJAX. However I am quite new to AJAX, Datatables etc. And I feel like using a .txt file or using internal data is probably not best practice.
I am curious as to which other methods can be used to make this more effective, as this .txt file is going to get quite large, and does not seem to be the optimum way to add date.
I have looked into the use of SQL, but not sure how youd get from having Data within an SQL table, and then adding that to a datatable.
This is not my area of expertise, but I am wanting to expand my skillset.
Code for the script pulling the data from .txt.
$(document).ready(function() {
var table = $('#dt_example').DataTable( {
dom: 'C<"clear">lfrtip',
"ajax": "objects.txt",
"columns": [
{
"className": 'details-control',
"orderable": false,
"data": null,
"defaultContent": ''
},
{ "data": "name" },
{ "data": "position" },
{ "data": "contractor" },
{ "data": "section" },
{ "data": "project" }
],
"order": [[1, 'asc']],
} );
} );