how to implement CRUD using jquery datatable in laravel 5.3

Question

i am using data-table plugins in my Laravel 5.3 project i can show my all data but can't implement edit and delete how implement that.

<script>
$.noConflict();
jQuery(document).ready(function() {
    $('#myTable').DataTable({
        processing : true,
        serverSide : true,
        ajax       : '{{URL::asset('data')}}',
        columns    :[
            {data:'id',name:'id'},
            {data:'prizebond_number',name:'prizebond_number'},
            {data:'prizebond_location',name:'prizebond_location'},

            {
                mRender: function (data, type, row) {
                    var linkEdit='<a href="{{url('user_prizebonds.edit')}}" class="btn btn-warning btn-sm glyphicon glyphicon-edit" data-id="' + row['id'] + '">EDIT</a>';
                    var linkDelete='<a href="{{url('user_prizebonds.destroy')}}" class="editor_remove btn btn-danger btn-sm glyphicon glyphicon-trash" data-id="' + row["data:id"] + '">DELETE</a>';
                    return  linkEdit + "  " + linkDelete;
                }
            }

        ]
    });
} );

//mycontroller code

public function data(){
    $current_user_id=Auth::id();
    $user_prizebonds=UserPrizebond::where('user_id', "$current_user_id")->get();
   return Datatables::of($user_prizebonds)->make(true);

}

Jakir Hossain · Accepted Answer · 2017-01-03 02:45:01Z

1

Write into your controller function. like this

return Datatables::of($user_prizebonds)->addColumn('action', function ($user_prizebonds) {
    return = '<button type="button" class="btn btn-default">Default</button>';
})->make(true);

and js code

{data: 'action', name: 'action', orderable: false, searchable: false}

answered Jan 3, 2017 at 2:45

Jakir Hossain

2,51720 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

how to implement CRUD using jquery datatable in laravel 5.3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related