Misc.

How to load data in datatables from ajax?

Load data in Datatables from Ajax

I was working on a project in which I had to show results in datatables with search and load data in datatable in real-time like whenever record inserted, it will show in datatables right away without refreshing page. This can be done via ajax. I achieved this requirement by following code. I am skipping table html.

var recordsTable;

recordsTable = $('#datatable-fixed-header').DataTable({
                   ajax: {
                       "url":"liveRecs.php",
                       "dataSrc": ""
                   }
            });

setInterval( function () {
    recordsTable.ajax.reload( null, true ); 
}, 10000 );

That’s it. Hope this will help.

websourceblog

ReactJs, NodeJs, Amazon Web Services, Symfony, Laravel, CodeIgniter, Zend Framework, WordPress, Drupal, Magento, Angular

Recent Posts

Centralizing Email Logging in Laravel with a Custom EmailLogChannel

When building real-world Laravel applications, email handling quickly becomes scattered. You send emails from controllers,…

2 days ago

Clean, Powerful API Filtering with Spatie Query Builder

Build flexible, readable, and secure query filters across multiple Laravel models — no more bloated…

2 months ago

AI Prompt Engineering Bible (7 Books in 1) – Master ChatGPT & Generative AI

Artificial Intelligence is transforming how we work, create, and earn. But most people get stuck…

8 months ago

How Digital Transformation Services Drive Business Growth

In today’s fast-paced world, businesses can no longer rely solely on traditional methods to stay…

8 months ago

How to Add an Addon Domain in GoDaddy with Web Hosting Deluxe

Add an Addon Domain in GoDaddy with Web Hosting Deluxe (Step-by-Step Guide). If you are…

9 months ago

Developing a RESTful API with Node.js, Express.js, MongoDB, and TypeScript

The ability to create reliable APIs is essential in today's web development environment. I'll show…

12 months ago