AJAX JSON to Datatables

Question

I'm still learning this but I'm getting an just [Object object] please help. I've tried to follow the documentation in Datatables but still cant get it right. Hope you can help me... thanks

Here's the code

Javascript

 $(document).ready(function() {
        $.ajax({
            url: "includes/view_ajax.php",
            type: "POST",
            cache: false,
            dataType: 'json',
            success: function(dataResult){
                alert( JSON.stringify(dataResult) );
                $('#memberdata').DataTable({
                    "searching": true,
                    "aaData": [dataResult],
                    "aoColumns": [
                      { "sTitle": "PlateNo" },
                      { "sTitle": "Make" },
                      { "sTitle": "Series" }
                    ] 
                });
            }
        });

PHP

<?php

$columns = array( 
// datatable column index  => database column name
    0 => 'PlateNo',
    1 => 'Make',
    2 => 'Series',
);
include 'database.php';
$sql = "SELECT * FROM vehicleinfo";
$res = mysqli_query($conn, $sql) or die("Error: ".mysqli_error($conn));
$dataArray = array();
while( $row = mysqli_fetch_array($res) ) {


                 $PlateNo = $row["PlateNo"];
                 $Make = $row["Make"];
                 $Series = $row["Series"];
                 
                $dataArray [] =  array("PlateNo" => $PlateNo,
                                        "Make" => $Make,
                                        "Series" => $Series);


}

echo json_encode($dataArray);

?>

Are you wrapping your database results in an array twice? First here: $dataArray [] = ... - and then again here: "aaData": [dataResult],. To double-check, you can edit your question to show us the JSON text output from echo json_encode($dataArray);. — andrewJames
– andrewJames, Commented Apr 19, 2021 at 16:45
Also, I do believe the solution noted by @mohammedazar is necessary (it just may not be sufficient). — andrewJames
– andrewJames, Commented Apr 19, 2021 at 16:45

Mohammed Azar · Accepted Answer · 2021-04-19 11:54:45Z

1

$('#memberdata').DataTable({
                    "searching": true,
                    "aaData": [dataResult],
                    "aoColumns": [
                      { "sTitle": "PlateNo" , mData:'PlateNo' },
                      { "sTitle": "Make", mData:'Make' },
                      { "sTitle": "Series", mData:'Series' }
                    ] 
                });

You Need to add mData Property to object of the Column arrays

answered Apr 19, 2021 at 11:54

Mohammed Azar

1016 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

andrewJames Over a year ago

@japs: If something doesn't work, it can be useful to explain what actually happened, and also provide any related error messages. In this case, I do believe the changes are necessary (but they may not be sufficient, on their own, to solve the problem).

Collectives™ on Stack Overflow

AJAX JSON to Datatables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related