PHP Databases

PHP Database Backup Client for MySQL

There are various database clients available in the market, for example, SQLyog, HeidiSQL, phpMyAdmin and more. These are popular database c ...

January 25th, 2018

How to Backup MySQL Database using PHP

Dynamically creating database backup via program will be hand in many a situations. We can schedule the backup process periodically by using ...

January 24th, 2018

How to Import SQL into a Database using PHP

Importing SQL script via programming will be useful when we need to create database structure dynamically. For example, if we provide APP or ...

June 12th, 2017

DataTables Server-side Processing using PHP with MySQL

DataTables is a jQuery library that displays the list of records in an HTML table with an intuitive interface. It includes search, paginatio ...

April 11th, 2017

CRUD with MySQLi Prepared Statement using PHP

In this tutorial, we are going to see how to implement the CRUD operations using MySQLi / prepared statement. Using prepared statement is ad ...

April 5th, 2017

PHP Search and Pagination using PDO

Search is an important functionality of any information-centric application. Pagination is an integral part of the display when voluminous r ...

February 3rd, 2017

PHP PDO CRUD

In this tutorial we are creating an example to do database operations Create, Read, Update and Delete (CRUD) in PHP using PDO connection. In ...

December 30th, 2016

Sorting MySQL Column using PHP

In PHP we can sort database results based on a column field using MySQL order by clause. Previously, we have seen about how to change the My ...

March 9th, 2016

MySQL BLOB using PHP

The BLOB is a kind of MySQL datatype referred to as Binary Large Objects. As its name, it is used to store a huge volume of data as binary s ...

December 30th, 2013

Update/Delete Multiple Rows using PHP

We are well expertise with PHP CRUD operations by accessing MySQL via PHP logic. Yet, we have seen how to update and delete table rows one a ...

September 23rd, 2013

↑ Back to Top