Category: DataBase

CodeIgniter already has a library for pagination.

Which is easier to implement on the page. But you need to customize it to add extra functionality like – search, sorting, rows per page.

Datatables is a jQuery library which comes with all basic functionality which requires for pagination.

Need to handle the request and return the response in the specified format.

In this tutorial, I show how you can implement Datatables pagination in CodeIgniter.

DataTables AJAX Pagination with Search and Sort in CodeIgniter

AJAX CodeIgniter DataBase JQuery PHP

CodeIgniter DataBase How To JQuery PHP

Taking the backup of the database is necessary whether it small or large project. You can easily revert the database if something went wrong.

Using phpMyAdmin you can easily export your MySQL database.

You can also Command Line to export selected MySQL database.

In this tutorial, I am using XAMPP in windows.

How to export MySQL database using Command Line

DataBase

phpMyAdmin allows importing file to the selected MySQL database but it takes time to import according to the file size.

If a file is too large then it will give Timeout error if it exceeds the time.

With the use of the Command Line, you can easily import your SQL file in less time.

In this tutorial, I am using XAMPP in Windows.

How to import SQL file to MySQL using Command Line

DataBase

In infinite page scroll pagination data load dynamically and append at the end of existing content when the user reaches to the bottom while scrolling.

The user doesn’t have to click any button.

I am using ngInfiniteScroll directive for implementing with AngularJS.

With this directive detect page scroll and send AJAX request to get content.

Also, need to include the jQuery library for using it.

In this tutorial, I show how you can load content on page scroll using the ngInfiniteScroll directive in AngularJS.

Load content on Page scroll with AngularJS and PHP

AJAX AngularJS DataBase PHP

One by One record deletion from the list is time-consuming and frustrating when need to delete many records.

With the use of the checkboxes on the list, you can allow selecting multiple records. Only required to add a single delete button.

In this tutorial, I show how you can delete multiple records using jQuery AJAX in CodeIgniter.

Delete multiple selected records with jQuery AJAX in CodeIgniter

CodeIgniter DataBase PHP

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