Category: DataBase

Laravel Excel is a package which simplifies the import and export data in Laravel.

It allows exporting data in various format – xlsx, csv, xml, html, pdf, etc.

Require to create a separate class from where return data and set heading row.

In this tutorial, I am using it to export MySQL data in CSV and Excel format in Laravel project.

Export data in Excel and CSV format with Laravel Excel

DataBase Laravel PHP

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