PHP Databases

How to Import SQL into a Database using PHP

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

DataTables Server-side Processing using PHP with MySQL

April 11th, 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 se

CRUD with MySQLi Prepared Statement using PHP

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

PHP Search and Pagination using PDO

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


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

Sorting MySQL Column using PHP

March 9th, 2016
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


December 30th, 2013
BLOB is a kind of MySQL datatype referred as Binary Large Objects. As its name, it is used to store huge volume of data as binary strings as

Update/Delete Multiple Rows using PHP

September 23rd, 2013
We are well expertise with PHP CRUD operations by accessing MySQL via PHP logic. Yet, we have seen about how to update and delete table rows


September 6th, 2013
In this tutorial, we are going to see an example program to learn how to do database CRUD operations using PHP and MySQL. CRUD tends to Crea

PHP MyAdmin

August 5th, 2013
phpMyAdmin is one of the popular client software tools with an extraordinary user interface that helps to perform database handling operatio

↑ Back to Top