title: Yajra DataTable Search-box and pagination not working with Laravel 5.4 on digital ocean online
body: <p>I'm using Laravel 5.4 with Yajra DataTable 8.0, on localhost everything working well and DataTable all ok. However, When I upload my files on "digital ocean" online server, Datatable working but for Pagination not working completely. It shows all records (6420 records) per each slide of pagination. On localhost it shows 10 records per page as normal, but online it shows all records in each slide of pagination.</p>
  
  <p>Another problem which is the search box, which not working at all. It shows processing in every typing for any text inside it. However, no results after typing anything inside it.</p>
  
  <p>Here in my header:</p>
  
  <pre><code>&lt;head&gt;
  
  
      &lt;link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css"&gt;
  
      &lt;link href="https://fonts.googleapis.com/css?family=Dosis:300,400,500,700" rel="stylesheet"&gt;
  
      &lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"&gt;&lt;/script&gt;
      &lt;script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"&gt;&lt;/script&gt;
  
      &lt;link rel="stylesheet" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css"/&gt;
  
  &lt;/head&gt;
  </code></pre>
  
  <p>and this is the table:</p>
  
  <pre><code>&lt;table id="student_table" class="this_testing table table-bordered" style="width:100%"&gt;
          &lt;thead&gt;
          &lt;tr&gt;
              &lt;th&gt;name&lt;/th&gt;
              &lt;th&gt;primary_number&lt;/th&gt;
          &lt;/tr&gt;
          &lt;/thead&gt;
      &lt;/table&gt;
  </code></pre>
  
  <p>This is my JS:</p>
  
  <pre><code>&lt;script&gt;
  
      $(document).ready(function () {
          $('.this_testing').DataTable({
              processing: true,
              serverSide: true,
              ajax: {
                  url: "lead/testing"
  
              },
              columns: [
                  {"data": "id", "name": "id"},
                  {"data": "name", "name": "name"}
              ],
              // bSort: true,
              dom: 'Bfrtip',
              buttons: [
                  'copy', 'csv', 'excel', 'pdf', 'print'
              ]
          });
  
      });
  
  &lt;/script&gt;
  </code></pre>
  
  <p>This is my route:</p>
  
  <pre><code>Route::get('lead/testing', 'LeadController@testing');
  Route::get('lead/testings', 'LeadController@testings');
  </code></pre>
  
  <p>Lastly by Controller to get the Data: </p>
  
  <pre><code>public function testings()
  {
      return view('testing');
  }
  
  public function testing()
  {
      $allClients = Status::select('id','name');
      return DataTables::of($allClients)-&gt;make(true);
  }
  </code></pre>
  
  <p>There is no any Ajax error in Network or Inspect, I got the data correct from Controller, but my problem in showing the DataTable on "digital ocean" server, it keep showing all response records (6320 records) in each slide of pagination, which make the page too long and the pagination need a time to load. I want to make it work as normal, 10 records per page, is there any conflict or library missed.</p>
  
  <p>Another problem, Search box showing processing in every typing, but not working and no results affected.</p>
  
  <p>Any help please,
  I'm using Laravel 5.4 and DataTable ^8.0 on Digital Ocean Server</p>