Data sources สำหรับ DataTable ในการใช้งานร่วมกับ Codeigniter ตอนที่ 2

{
  "data": [
    ["1",''กรุงเทพมหานคร","Bangkok"],
    ["2",''สมุทรปราการ","Samut Prakan"],
    ["3",''นนทบุรี","Nonthaburi"]
  ]
}

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
 
class Ajaxdata extends CI_Controller {
 
    public function __construct()
    {
        parent::__construct();
    }
    public function index(){

		$data = array();
		$query = $this->db->query("SELECT * FROM tbl_provinces");
		foreach ($query->result_array() as $row){
			$data[] = array(
				$row['province_id'],
				$row['province_name'],
				$row['province_name_eng']
			);
		}
		$output = array(
			 "data" => $data
		);
		echo json_encode($output);
		exit();
    }
}

<link rel="stylesheet" href="//cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">  
<script src="//cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>       
 
<table id="table_ajax_id" class="display">
    <thead>
        <tr>
            <th>Province ID</th>
            <th>Province Name TH</th>
            <th>Province Name ENG</th>
        </tr>
    </thead>
</table>
 
<script type="text/javascript">
$(function(){
	$('#table_ajax_id').DataTable( {
		"ajax": '<?=base_url("Ajaxdata")?>'
	} );
});
</script>

<link rel="stylesheet" href="//cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">  
<script src="//cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js"></script>

<table id="table_js_id" class="display" width="100%"></table>
 <br>
<br>
<script type="text/javascript">
var dataSet = [
	[1,"วันจันทร์","Monday"],
	[2,"วันอังคาร","Tuesday"],
	[3,"วันพุธ","Wednesday"],
	[4,"วันพฤหัสบดี","Thursday"],
	[5,"วันศุกร์","Friday"],
	[6,"วันเสาร์","Saturday"],
	[7,"วันอาทิตย์","Sunday"]
];
$(function(){
	$('#table_js_id').DataTable( {
		"data": dataSet,
		"columns": [
			{ title: "Name" },
			{ title: "Name TH" },
			{ title: "Name ENG" }
        ]
	} );
});
</script>