There are various database clients available in the market, for example, SQLyog, HeidiSQL, phpMyAdmin and more. These are popular database c ...
January 25th, 2018
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
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 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
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
Search is an important functionality of any information-centric application. Pagination is an integral part of the display when voluminous r ...
February 3rd, 2017
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
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
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
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