MaxInterview - ajax jquery datatable display records with pagination in laravel

showing results for - "ajax jquery datatable display records with pagination in laravel"

11 Aug 2019

1<?php
2
3namespace App\Http\Controllers;
4
5use Illuminate\Http\Request;
6use App\Employees;
7
8class EmployeesController extends Controller{
9
10   public function index(){
11      return view('employees.index'); 
12   }
13
14   /*
15   AJAX request
16   */
17   public function getEmployees(Request $request){
18
19     ## Read value
20     $draw = $request->get('draw');
21     $start = $request->get("start");
22     $rowperpage = $request->get("length"); // Rows display per page
23
24     $columnIndex_arr = $request->get('order');
25     $columnName_arr = $request->get('columns');
26     $order_arr = $request->get('order');
27     $search_arr = $request->get('search');
28
29     $columnIndex = $columnIndex_arr[0]['column']; // Column index
30     $columnName = $columnName_arr[$columnIndex]['data']; // Column name
31     $columnSortOrder = $order_arr[0]['dir']; // asc or desc
32     $searchValue = $search_arr['value']; // Search value
33
34     // Total records
35     $totalRecords = Employees::select('count(*) as allcount')->count();
36     $totalRecordswithFilter = Employees::select('count(*) as allcount')->where('name', 'like', '%' .$searchValue . '%')->count();
37
38     // Fetch records
39     $records = Employees::orderBy($columnName,$columnSortOrder)
40       ->where('employees.name', 'like', '%' .$searchValue . '%')
41       ->select('employees.*')
42       ->skip($start)
43       ->take($rowperpage)
44       ->get();
45
46     $data_arr = array();
47     
48     foreach($records as $record){
49        $id = $record->id;
50        $username = $record->username;
51        $name = $record->name;
52        $email = $record->email;
53
54        $data_arr[] = array(
55          "id" => $id,
56          "username" => $username,
57          "name" => $name,
58          "email" => $email
59        );
60     }
61
62     $response = array(
63        "draw" => intval($draw),
64        "iTotalRecords" => $totalRecords,
65        "iTotalDisplayRecords" => $totalRecordswithFilter,
66        "aaData" => $data_arr
67     );
68
69     echo json_encode($response);
70     exit;
71   }
72}

source

similar questions

datatable without pagination datatable sajaxsource get output angularjs datatable example with pagination datatable set page number laravel pagination ajax example set datatable with jquery success return value jquery datatable ajax get data datatables warning 3a table id 3ddatatable ajax error ajax datatable reload paging retained datatable ajax complete change info pagination datatable ajax laravel get data current page number and clicked page number jqery datatables jquery datatable get data array

queries leading to this page

laravel pagination and jquery datatable ajax datatables ajax pagination laravel laravel datatables pagination datatable ajax pagination laravel dynamic pagination in javascript with table data by ajax call example jquery datatable pagination example code laravel yarja datatable style pagination laravel jquery datatable server pagination datatable pagination laravel jquery datatable example with pagination datatable laravel pagination datatable dynamic pagination example how to get data paginate data get by ajax jquery in laravel laravel datatable pagination datatables paginate laravel datatables ajax pagination examples datatable ajax data with pagination search in laravel datatable bootstrap sort laravel laravel datatables model pagination laravel pagination datatables datatable ajax pagination with laravel use jquery datatable with laravel pagination laravel datatables ajax pagination ajax jquery datatable display records with pagination in laravel jquery datatable ajax pagination example laravel datatables dynamic pagination in php laravel data table pagination laravel datatables pagination with ajax in laravel laravel yarja datatable styling pagination sorting in serverside pagination in laravel jquery datatable datatable pagination in laravel datatable ajax laravel pagination in laravel ajax datatables jquery datatable in laravel laravel datatable pagination with ajax sorting the total data table records with pagination laravel datatable with pagination ajax ajax jquery datatable display records with pagination in laravel