PHP Databases

Recent Tutorial

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 a 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 […]
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.

How to Import SQL into a Database using PHP

June 12, 2017
Importing SQL script via programming will be useful when we need to create database structure dynamically. For example, if we provide APP or plugin to download and install from online, the dynamic SQL import will be used to setup the application database at the time of installing the APP or plugin. In this tutorial, we are going […]
This tutorial was added to PHP.

DataTables Server-side Processing using PHP with MySQL

April 11, 2017
DataTables is a jQuery library used to display the list of records in a HTML table with an intuitive interface. It includes features like search, pagination, sort, filter and more. In a previous article, we have seen a custom code for search and pagination for the list of records. Using DataTables we can limit the […]
This tutorial was added to PHP.

↑ Back to Top