Category: DataBase

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

AJAX pagination makes it easier to display the large list of records in multiple pages without refreshing the whole page when navigating.

While navigating pages if you refreshed the webpage then it will load record from 1st instead of page position before the refresh.

E.g. If you are on 5 page then it will again start from 1 when webpage reload.

To retain the position, I am using COOKIE to store the page number and use it after page successfully load to fetch records in CodeIgniter.

Retain AJAX pagination position after Refresh in CodeIgniter

AJAX CodeIgniter DataBase PHP

DataBase PHP

If you are using MySQL database in your web project then there is always possibility that you need to insert, update, and delete records instead of just fetching and displaying records.

In this tutorial, I show how you can insert, update, and delete a record from MySQL database table in Laravel.

Insert update and Delete record from MySQL in Laravel

DataBase Laravel PHP

A model is a PHP class where perform data logic and database manipulation like – retrieve data, insert, update, and delete.

In Laravel models classes are stored in app/ directory.

This mainly loads from the controller.

In this tutorial, I show how you create and load Model in the controller and fetch records from MySQL database in Laravel.

How to create and load Model in Laravel

DataBase How To Laravel PHP