Using DB Method in Laravel project got DataTables error

Question

I got the error in Laravel project, want to using DB method to call a database table. How to solve this?

Error: DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Here is codes of controller

    public function index(Request $request)
{

    $title = 'Video Category List';

    if ($request->ajax()) {



        //$data = Category::where('type', 'Favourite')->get();
        $data = DB::table('action_status')
        ->where('type', 'Favourite')
        ->get(); 

        

        return Datatables::of($data)
            ->addIndexColumn()
            ->addColumn('name', function ($row) {
                return $row->name ?? '';
            })

            ->addColumn('image_path', function ($row) {
                return $row->image_path ?? '';
            })


            ->addColumn('status', function ($row) {
                if ($row->status == 1) {
                    return 'Active';
                } else {
                    return 'Inactive';
                }
            })

            ->addColumn('action', function ($row) {
                $btn = '<button type="button"   onclick="selectid2(' . $row->id . ')"
                class="btn btn-success waves-effect waves-light"style="margin-right:10px"   data-toggle="modal" data-target="#updatecategory">
                <i class="fa fa-edit"></i>

                </button> ';
                $btn2 = '<button type="button"   onclick="delete(' . $row->id . ')"
                 class="btn btn-danger waves-effect waves-light"style="margin-right:10px"   data-toggle="modal" data-target="#">
                 <i class="fa fa-trash"></i>
                 </button>';
                return  $btn . '' . $btn2;

                // <i class="bx bx-pencil  font-size-16 align-right "   ></i>
            })


            ->rawColumns(['action'])
            ->make(true);
    }

    return view('admin/videocategory/category', compact('title'));
}

you need to check network tab to get more information about the error — Kamlesh Paul
– Kamlesh Paul, Commented Nov 25, 2021 at 6:37
ok, I already go network tab, what I want to copy and paste here? — Sam
– Sam, Commented Nov 25, 2021 at 6:44

Germeloper · Accepted Answer · 2021-11-25 06:42:57Z

1

You should start using Models in Laravel, and since you are using DataTables use jquery paired with ajax instead. Your approach is a bit complicated.

Also it is hard to debug the issue without other information from the network tab and a good test case scenario for this would be nice.

answered Nov 25, 2021 at 6:42

Germeloper

719 bronze badges

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

4 Comments

Sam Over a year ago

from the network tab what information should I provide here, sorry I new in Laravel

Germeloper Over a year ago

could you send a screenshot of the network tab? Maybe which of your route/s has the public function index(Request $request) ?

Germeloper Over a year ago

Seeing your source code, I believe it has something to do with a column header mismatch. Meaning from your controller you added a column using the addColumn(), where the column header name does on exist nor matches to your html table headers.

Leena Patel Over a year ago

Add some more information like links of docs for OP to understand properly.

Collectives™ on Stack Overflow

Using DB Method in Laravel project got DataTables error

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related