jquery data table features not working with dynamic table

Question

My datatable is working fine, all the features like pagination, sorting, searching are working with static table data content. But when I fetch data from database and render in datatable features like pagination, sorting, searching and other CSS are not working.

My view page code::

$(document).ready(function() {

  $.ajaxSetup({
    headers: {
      'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
    }
  });

  $('#example').DataTable();

  fetchproduct();

  function fetchproduct() {
    $.ajax({
      type: "GET",
      url: "/fetchproducts",
      dataType: "json",
      success: function(response) {
        $('tbody').html("");
        $.each(response.products, function(key, item) {
          $('tbody').append('<tr>\
            <td>' + item.id + '</td>\
            <td>' + item.name + '</td>\
            <td> <img src="images/' + item.image_path + '"> </td>\
            <td><button type="button" value="' + item.id + '" class="btn btn-primary editbtn btn-sm">Edit</button></td>\
            <td><button type="button" value="' + item.id + '" class="btn btn-danger deletebtn btn-sm">Delete</button></td>\
            \</tr>');
        });
      }
    });
  }
});

<div class="table-responsive">
  <table id="example" class="table table-striped table-bordered" style="width:100%">
    <thead>

      <tr>
        <th>Index</th>
        <th>Name</th>
        <th data-orderable="false">Image</th>
        <th data-orderable="false">Edit</th>
        <th data-orderable="false">Delete</th>
      </tr>
    </thead>

    <tbody>
    </tbody>

    <tfoot>
      <tr>
        <th>Index</th>
        <th>Name</th>
        <th>Image</th>
        <th>Edit</th>
        <th>Delete</th>
      </tr>
    </tfoot>
  </table>
</div>

Controller code and route::

public function fetchproduct()
    {
        $products = Product::all();
        return response()->json([
            'products'=>$products,
        ]);
    }
    
// route
Route::get('products', [ProductController::class, 'index'])->name('products.index');
Route::post('products', [ProductController::class, 'store'])->name('products.store');
Route::get('fetchproducts', [ProductController::class, 'fetchproduct']);

When I load the datatable, all the data is rendered at once. Pagination feature is not working. Also sorting and searching are also not working. Why is it so?

Additionally the $each and the escaped newline is very inefficient. For another time this is simpler and faster $('tbody').append(response.products.map(item => `<tr> <td>${item.id}</td> <td>${item.name}</td> <td> <img src="images/${item.image_path}"> </td> <td><button type="button" value="${item.id}" class="btn btn-primary editbtn btn-sm">Edit</button></td> <td> <button type="button" value="${item.id}" class="btn btn-danger deletebtn btn-sm">Delete</button></td> </tr>`).join('')); and then delegate the button clicks from the tbody — mplungjan
– mplungjan, Commented Jul 4 at 8:31

Lajos Arpad · Accepted Answer · 2025-07-04 07:43:52Z

The issue that you have is due to the fact that you directly override the inner structure of the table where the rows are rendered and thusly the event handlers attached to it will automatically reduce. Example of the issue:

document.getElementById("overrider").addEventListener("click", function() {
    document.getElementById("container").innerHTML = `<input type="button" value="no longer works" id="overriden">`;
});

document.getElementById("overriden").addEventListener("click", function() {
    console.log("works");
});

<input type="button" value="override" id="overrider">
<div id="container">
    <input type="button" value="works" id="overriden">
</div>

You can see that upon clicking the second button the event handler works until you click on the first button that replaces the innerHTML of the container inside which the second button is located, which removes the inner contents' event handlers. This is what happened to your data table. You will need to use the library's recommended way of specifying the data-source. An example is given here.

new DataTable('#example', {
    ajax: 'scripts/server_processing.php',
    deferLoading: 57,
    processing: true,
    serverSide: true
});

In your case the ajax field would be '/fetchproducts`'.

Collectives™ on Stack Overflow

jquery data table features not working with dynamic table

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