Jquery Datatable listing json Server side in Php Mysql and Ajax

Jquery Datatable listing json Server side in Php Mysql and Ajax

jQuery Datatable listing Example with JSON Data

In this Post We Will Explain About is Jquery Datatable listing json Server side in Php Mysql and Ajax With Example and Demo.Welcome on Pakainfo.com – Examples, The best For Learn web development Tutorials,Demo with Example! Hi Dear Friends here u can know to Example

In this post we will show you Best way to implement jQuery Datatables Example and Demos Using Rest WebService, hear for jQuery Datatable listing Example with JSON Datawith Download .we will give you demo,Source Code and examples for implement Step By Step Good Luck!.

Inlcude External Lins

<link rel="stylesheet" href="bootstrap.min.css">
<script src="jquery.min.js"></script>
<script src="bootstrap.min.js"></script>
<link rel="stylesheet" type="text/css" href="datatables.min.css"/>
<script type="text/javascript" src="datatables.min.js"></script>

Markup part HTML(index.html)

<table id="mysmarttable">
	<thead>
		<tr>
			<th>Person ID</th>
			<th>Desc - Title</th>
			<th>Data Body</th>
		</tr>
	</thead>
	
</table>

Get ServerSide call using Angularjs Examples

var mylivearray = [];
	$.ajax({
		url: "http://jsonplaceholder.typicode.com/posts",
		async: false,
		dataType: 'json',
		success: function (data) {
			for (var ldata = 0, len = data.length; ldata < len; ldata++) {
				var mydesc = data[ldata].body;
				mylivearray.push([ data[ldata].userId, '<a href="https://www.pakainfo.com" target="_blank">'+data[ldata].title+'</a>', mydesc.substring(0, 12)]);
			}
		mytable(mylivearray);
		}
	});

Passed Simple formatted data to jquery datatables.

	
function mytable(rdata) {	
	//console.log(rdata);
	$('#mysmarttable').DataTable( {
		"aaData": rdata
	} );
}

aaData : This datatables property hold the simple json data for all data fill to table listing

Read Also:  Task Scheduling with Cron Job using Laravel 5/6/7

.

Example 2 : jquery datatables ajax json example

$("#livedatatable").dataTable({
  "bServerSide": true,
  "sAjaxSource": "https://www.pakainfo.com/api/data_source.json",
  "aoColumns": [{
    "mData":"name",
    "sTitle": "your Site name"
  },{
    "mData": "url",
    "mRender": function ( url, type, full )  {
      return  '<a href="'+url+'">' + url + '</a>';
    }
  },{
    "mData": "editor.name"
  },{
    "mData": "editor.phone"
  },{
    "mData":"editor",
    "mRender": function(data){
      return data.email.join("<br>");
    }
  }]
});

Example


I hope you have Got What is jquery datatable Ajax crud server side Examples And how it works.I would Like to have FeadBack From My Blog(Pakainfo.com) readers.Your Valuable FeadBack,Any Question,or any Comments abaout This Article(Pakainfo.com) Are Most Always Welcome.