DataBase Archives - Page 2 of 8

Last updated on August 6th, 2018 by Yogesh Singh

How to add Custom Filter in DataTable – AJAX and 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.

AJAX DataBase JQuery PHP

Last updated on July 23rd, 2018 by Yogesh Singh

Update Multiple Selected Records with 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.

DataBase PHP

Last updated on July 16th, 2018 by Yogesh Singh

Sort Pagination records on Header Click in CodeIgniter

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.

CodeIgniter DataBase PHP

Last updated on July 2nd, 2018 by Yogesh Singh

Insert Update and Delete record with AJAX in Laravel

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.

AJAX DataBase JQuery Laravel PHP

Last updated on May 21st, 2018 by Yogesh Singh

Retain AJAX pagination position after Refresh in CodeIgniter

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.

AJAX CodeIgniter DataBase PHP

Last updated on May 14th, 2018 by Yogesh Singh

Upload and Store video to MySQL Database with PHP

By storing media files to MySQL database make easier to retrieve files uploaded by the user or in the specific category.

For this require storing file to the server and save the reference to the database.

In the tutorial, I show how you can upload and store video to MySQL database table with PHP.

DataBase PHP

Last updated on May 10th, 2018 by Yogesh Singh

Insert Update and Delete record from MySQL in Laravel

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.

DataBase Laravel PHP

Category: DataBase