Import CSV Data to MySQL Database with Laravel 7

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 in Laravel 7 without any package.

Import CSV Data to MySQL database with Laravel

Read more

Update Multiple Selected Records with PHP

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

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

With checkboxes, enable multiple records selected 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

Read more

Sort Pagination records on Header Click in CodeIgniter

Pagination is used to display the large list of records in multiple pages form. This makes easier to access records.

You can make traversing more easier by add sorting on the table.

The table list gets arranged according to the clicked header.

In this tutorial, I show how you can implement pagination sorting on header click in CodeIgniter.

Sort Pagination records on Header Click in CodeIgniter

Read more