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.
Autopopulating values require when need to load records on child element based on parent element value.
Element values replace with new items whenever parent element value changes.
In this tutorial, I show how you can auto-populate dropdown with jQuery AJAX in Laravel.
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.
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.
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.
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.
AJAX is use to communicate with the server and perform action like – database manipulation, file upload, etc. without the need to refresh whole page.
In this tutorial, I show how you can use jQuery AJAX to insert, update, and delete records in Laravel.
© 2016-2019 Makitweb, All rights reserved