PHP Databases

Column Search in DataTables using Server-side Processing

September 18, 2018
DataTables is a feature-packed jQuery plugin used to display results in a tabular form. It provides a rich interface with effective sorting, search, pagination like features to manage a list of records. Using this we can list both static and dynamic results. In a previous article, we have seen how to show dynamic results with DataTables using […]
This tutorial was added to PHP.

Ajax Pagination with Tabular Records using PHP and jQuery

June 30, 2018
Pagination feature is for limiting the number of results instead of loading all in a list page. Loading multiple records with pagination will increase efficiency to load result page by page. We have seen several examples for PHP pagination with database results. For the pagination functionality, a perpage result count will be configured. This configured […]
This tutorial was added to PHP.

Multi-Select Dropdown Filter in PHP with Database Search

May 17, 2018
Filters are used to narrow down the results based on particular criteria. We have already created a PHP filter for a list page to shortlist the database results based on the selected filter options. Search filter with a combo field will allow multi-select. So, we can create a search to filter data based on the […]
This tutorial was added to PHP.

PHP Responsive Image Gallery using CSS Media Queries

April 13, 2018
Gallery is a great way to showcase data in a grid view so that its appealing to the users. Its one of the nicest way to present your products. Your gallery can contain image, video or a collection of text data in a card. In the last post, I have created a gallery to show […]
This tutorial was added to PHP.

Object-Oriented CRUD System using PHP PDO and MySQL

April 10, 2018
Database CRUD is one of a common functional pack that is required to manage and manipulate data of an entity based application. We have already seen basic CRUD example using PHP and MySQL. In this example, I have used the object-oriented method for implementing CRUD functionalities. I have created a card-like list view to display all the records […]
This tutorial was added to PHP.

Import Excel File into MySQL Database using PHP

March 14, 2018
Database backup and restore is the most important thing in maintaining software. Periodical automatic backup is a must for any project. If in case, there is an unknown security flaw and that affects your system, then your backup is the holy grail to save you. Exporting database into a backup file may be used in […]
This tutorial was added to PHP.

Import CSV File into MySQL using PHP

February 24, 2018
In this tutorial, I will walk you through PHP code to import CSV file into MySQL database by parsing the comma-separated data. The input CSV file is sent via a HTML form. There are various ways to read the CSV data and check my previous linked article for a different option. I used fgetcsv() function to read the database table column […]
This tutorial was added to PHP.

Restore MySQL Database using PHP

February 19, 2018
Restoring database via a program can be used in an application where dynamic loading is required. It can also be used to build a custom MySQL client application. I have already written about taking backup of a database through code, in the article How to Backup MySQL Database using PHP and you can download the code and […]
This tutorial was added to PHP.

PHP Database Backup Client for MySQL

January 25, 2018
There are various database clients available in the market, for example, SQLyog, HeidiSQL, phpMyAdmin and more. These are popular database clients. In this tutorial, we are going to create our own client interface for taking database backup. This will be a series of articles and in future, I will be enhancing it and eventually building […]
This tutorial was added to PHP.

How to Backup MySQL Database using PHP

January 24, 2018
Dynamically creating database backup via program will be hand in many a situations. We can schedule the backup process periodically by using CRON jobs. Taking the database backup using PHP programming is easy. In this tutorial, we are going to learn how to backup MySQL database with a simple core PHP code. First, I get the […]
This tutorial was added to PHP.

↑ Back to Top