how to display dynamic data in datatable ?

Have you use Datatable js or css library link and check on console.log are you getting data or not

for more information check link

https://keenthemes.com/keen/?page=docs&section=datatable

@himanshurajvanshi yes i have use datatable.js and css library but data can't display message like please wait i use metronic theme

yes already check documentation of metronic theme but i cant understand how to display record

@van-india have you check data on console

@himanshurajvanshi yes i check console.log(data) nothing data in data variable so how can i fetch

now check do you have data on that or not by return $view = Pg::all();

@himanshurajvanshi here is my $view = Pg::all(); output

[{
    "id": 1,
    "user_id": 2,
    "unique_id": "YSJGu4NF",
    "name": "punit",
    "new_name": null,
    "email": "[email protected]",
    "new_email": null,
    "owner": "punit pathak",
    "new_owner": null,
    "contact_no": "1231231231",
    "new_contact_no": null,
    "address": "pune",
    "new_address": null,
    "status": "active",
    "password": "punit",
    "approval": "0",
    "created_at": "2019-11-29 05:39:08",
    "updated_at": "2019-11-29 05:39:08",
    "deleted_at": null
}, {
    "id": 2,
    "user_id": 3,
    "unique_id": "DH60bcRs",
    "name": "remo",
    "new_name": null,
    "email": "[email protected]",
    "new_email": null,
    "owner": "remo dsuza",
    "new_owner": null,
    "contact_no": "1231231231",
    "new_contact_no": null,
    "address": "mumbai",
    "new_address": null,
    "status": "active",
    "password": null,
    "approval": "0",
    "created_at": "2019-11-29 05:39:55",
    "updated_at": "2019-11-29 05:39:55",
    "deleted_at": null
}]

that mean "/pg/display" you are not hiting on that url are you using full path like http://localhost/projects/pg/display do hit or not check on network ctrl+shift+i

@himanshurajvanshi i try this but nothing any response its same blank nothing data fetch

http://localhost/pgmanagment/public/pg/display

and i use php artisan serve so can i use url is right or wrong?

error like

plugins.bundle.js:9837 GET http://localhost/pgmanagment/public/pg/display?pagination%5Bpage%5D=1&pagination%5Bpages%5D=1&pagination%5Bperpage%5D=10&pagination%5Btotal%5D=2&query=&sort%5Bfield%5D=Address&sort%5Bsort%5D=asc 404 (Not Found)

https://github.com/freshbitsweb/laratables

this package has a lot of useful functionality with datatables. i think you can find answer to your question in the examples

@agelios nothing enough for solve my issue give some other references

list-datatable.js:212 Uncaught TypeError: Cannot read property 'class' of undefined 
        at Object.template (list-datatable.js:212)
        at HTMLTableCellElement.<anonymous> (scripts.bundle.js:5764)
        at Function.each (plugins.bundle.js:367)
        at jQuery.fn.init.each (plugins.bundle.js:202)
        at HTMLTableRowElement.<anonymous> (scripts.bundle.js:5749)
        at Function.each (plugins.bundle.js:367)
        at jQuery.fn.init.each (plugins.bundle.js:202)
        at Object.setupTemplateCell (scripts.bundle.js:5709)
        at Object.insertData (scripts.bundle.js:6337)
        at Object.afterGetData (scripts.bundle.js:6227)

It works with my data

let table = $('#kt_table_1').DataTable({
                serverSide: true,
                ajax: "url",
                columns: [
                    {name: 'id'}
                    {name: 'name'}
                ]

@agelios but i have use metronic theme which have some diffrent functionlity so your code is not enough for me

give some other refrerences

Looks like your JSON data file does not contain "meta" data that is required by KTDatatables

@van-india try this

$(document).ready(function() { $('#kt_apps_user_list_datatable').KTDatatable( { "processing": true, "serverSide": true, "ajax": { "url": "http://localhost/pgmanagment/public/pg/display", "type": "POST" success: function(data) { console.log(data); } },

    "columns": [
        { "data": "first_name" },
        { "data": "last_name" },
        ]
} );

} );

Note: write it without controller. your web.php (for laravel 8) or route.php will be like : Route :: get ('datatablelist' , [yourController :: class, 'datalist'])

and your blade view will be having url 'datatablelist' and type 'remote'