Support the ongoing development of Laravel.io →
Database Eloquent Views

Hello,

I'm busy learning Laravel.

How can I add an id to a row in a datatable in laravel 5.3?

The id should be the business_type_id from the table.

I looked at [yajra package][1] and installed the demo app but can't understand anything from there, so I'm not using it.

My controller function:

    public function businessTypeData(){
        $result['data'] = DB::table('business_types')
            ->selectRaw("business_type_id,
                business_type_name,
                business_type_slug,
                DATE_FORMAT(created_at, '%d/%m/%Y') as created_at")
            ->get();

        return json_encode($result);
    }

My js call:

    $('#businessTypeTable').DataTable({
                select: false,
                "ajax": {
                    "url": "/api/businessType",
                    "type": "POST",
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content') }
                },
                "columns": [
                    { "data": "business_type_id" },
                    { "data": 'business_type_slug', 'visible': false },
                    { "data": "business_type_name" },
                    { "data": "created_at" },
                    {"defaultContent": "null", "render": function(data,type,row,meta) {
                        return '<a href="/businessTypes/'+row.business_type_id+'/edit">'+ '<button class="btn btn-default btn-sm">Edit</button>' + '</a>'+
                                '<a href="businessTypes/'+row.business_type_id+'/destroy" class="btn btn-danger btn-sm deleteBtn" style="margin-left:10px">Delete</a>';
                    }
                }
            ]
        });

I want my table to look like this:

    <table>
      <tr id="1">...
      <tr id="2">...

[https://github.com/yajra/laravel-datatables-demo] (yajra package)

Can someone please help?

Last updated 2 years ago.
0
Last updated 8 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

SigalZ sigalz Joined 5 May 2016

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.