问DataTable填充Ajax

EN

  $(document).ready(function()
    {
        $.ajax({
            type : 'POST',
            url  : 'view/list/clients_1.php',
            dataType: 'json',
            cache: false,
            success :  function(result)
            {
                //pass data to datatable

                console.log(result); // just to see I'm getting the correct data.
                $('#my_table').DataTable({
                    "searching": false, //this is disabled because I have a custom search.
                    "bAutoWidth": false,
                    "bFilter": true,
                    "bLengthChange": false,
                    "responsive": true,
                    "aaData": [result], //here we get the array data from the ajax call.
                    "aoColumns": [
                        { "sTitle": "#" },
                        { "sTitle": "Name" },
                        { "sTitle": "Work" }
                     ]
                });
            }
        });

    $clients_sql = 
    "
        SELECT
            *
        FROM
            client
    ";

    $result = mysqli_query($mysqli, $clients_sql);
    $dataArray = array();
    while( $row = mysqli_fetch_array($result) )
    {
        $dataArray[] = $row["client_id"];
        $dataArray[] = $row["client_name"];
        $dataArray[] = $row["client_work"];
    }
    echo json_encode($dataArray);