使用ajax获取数据表数据

Question

I am trying to display dataTable data using ajax but it didn't work.

This is my jquery code :

$('#example').DataTable({
                ajax: {
                    type: 'GET',
                    url: 'data.php',
                    success: function (msg) {
                        $("#tbody_example").html(msg);
                    }
                }
            });

This is my data.php page :

    <?php   echo '<td>Name</td>
            <td>Position</td>
            <td>Office</td>
            <td>Extn.</td>
            <td>Start date</td>
            <td>Salary</td>'; ?>

and This is my dataTable :

 <table id="example" class="display" style="width:100%">
    <thead>
        <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Extn.</th>
            <th>Start date</th>
            <th>Salary</th>
        </tr>
    </thead>
    <tbody id="tbody_example">

    </tbody>
    <tfoot>
        <tr>
            <th>Name</th>
            <th>Position</th>
            <th>Office</th>
            <th>Extn.</th>
            <th>Start date</th>
            <th>Salary</th>
        </tr>
    </tfoot>
</table>

My dataTable still empty and I get MOCK GET: data.php as error. Any one can help me.

Answer 1

Try the below thing, It should work

In php file

$content = "<td>Name</td>
            <td>Position</td>
            <td>Office</td>
            <td>Extn.</td>
            <td>Start date</td>
            <td>Salary</td>";

$return["json"] = json_encode();
echo json_encode($return);

In ajax

ajax: {
         type: 'GET',
         url: 'data.php',
         success: function (msg) {
               $("#tbody_example").html(msg["json"]);
         }
}