Category: DataBase

AJAX DataBase Laravel PHP

In CSV file you can store data in comma-separated string format.

Sometimes require to import existing CSV file data to MySQL database.

For this, you can either directly read the file or upload and then read the file for insert data.

In this tutorial, I show how you can upload and import CSV file data in your MySQL database with Laravel.

Import CSV Data to MySQL database with Laravel

DataBase Laravel PHP

When DataTable is initialized on the HTML table then it generates pagination which has sorting, searching on all columns, change number of records display features.

The default search control mainly uses to finds value on all columns and display filter list. But it can be customized.

Sometimes it requires to add some custom search filters based on the records available like – date filtering, single field search, etc.

In this tutorial, I show how you can add the custom filter to the DataTable and use it with AJAX.

How to add custom filter in DataTable - AJAX and PHP

AJAX DataBase JQuery PHP

Sometimes its require to quickly modify multiple records and save it to the MySQL database table.

It makes easier to update records instead of updating one by one.

With checkboxes, enable multiple records selection from the list.

In this tutorial, I show how you can update multiple selected records to MySQL with PHP.

Update multiple selected records with PHP

DataBase PHP

CodeIgniter DataBase PHP

AJAX DataBase JQuery Laravel PHP

AJAX pagination makes it easier to display the large list of records in multiple pages without refreshing the whole page when navigating.

While navigating pages if you refreshed the webpage then it will load record from 1st instead of page position before the refresh.

E.g. If you are on 5 page then it will again start from 1 when webpage reload.

To retain the position, I am using COOKIE to store the page number and use it after page successfully load to fetch records in CodeIgniter.

Retain AJAX pagination position after Refresh in CodeIgniter

AJAX CodeIgniter DataBase PHP

DataBase PHP