Our Database tutorials are up to date and well explained step-by-step using examples so you can learn Database manipulation fast.
Sometimes require to show and hide HTML table columns dynamically.
You can easily hide a column using CSS nth-child selector. But with dataTables it not works properly.
DataTables already provided a method for this.
In this tutorial, I show how you can dynamically show and hide multiple columns in DataTables.
Select2 is a widely used jQuery plugin. It makes select element user-friendly.
After initializing it adds style and a search box. Based on the search text it filters the options.
It allows loading data dynamically using jQuery AJAX.
In this tutorial, I show how you can initialize select2 plugin and load data dynamically using AJAX PDO and PHP.
With Autopopulating dropdowns user is restricted to select an option from the dropdown step by step. Based on the dropdown selection next dropdown is autofill with options.
A common example, of this, is country, state, and city dropdowns on a form.
To load data without page refresh need to use jQuery AJAX.
In this tutorial, I show how you can auto-populate the dropdown with PDO and PHP.
DataTables by default comes with a search filter that can be used to search on all fields or specific fields and display records.
Sometimes, require to add the filter for the particular field only like – adding date range filter, country filter, etc.
DataTables allow for passing data that can read at the server-side script.
In this tutorial, I show how you can add a custom search filter and get records using DataTables in CodeIgniter 3.
© 2016-2023 Makitweb, All rights reserved
