Make Autocomplete search using jQuery UI in Laravel 7

Autocomplete is a user-friendly way to display a large list of data on a page.

It shows suggestions based on the input and a user can select an option from the list.

In this tutorial, I show how you add jQuery UI autocomplete to an input field in the Laravel 7 project.

Make Autocomplete search using jQuery UI in Laravel 7

Read more

Export Data in Excel and CSV format with Laravel Excel

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

Read more

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