PHP Databases

Recent Tutorial

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.

CRUD with MySQLi Prepared Statement using PHP

April 5, 2017
In this tutorial, we are going to see how to implement the CRUD operations using MySQLi / prepared statement. Using prepared statement is advantageous from many fronts like, performance and security. Using this method the query is compiled for the first time and the resource will be created and stored in a prepared statement. This […]
This tutorial was added to PHP.

PHP Search and Pagination using PDO

February 3, 2017
Search is an important functionality of any information-centric application. Pagination is an integral part of the display when voluminous records are displayed. In this tutorial, we are going implement search and pagination for a list page using PDO. In a previous tutorial, we have already learned how to do database CRUD using PDO. In this […]
This tutorial was added to PHP.

PHP PDO CRUD

December 30, 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 a previous tutorial, we have already learned about how to do database CRUD using MySQLi In this example, we have taken a posts table to do CRUD via PDO. The SQL script […]
This tutorial was added to PHP.

Sorting MySQL Column using PHP

March 9, 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 MySQL row order using jQuery. Now, we are going to see an example to sort UI results by clicking on the column name in the header. We have a […]
This tutorial was added to PHP.

MySQL BLOB using PHP

December 30, 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 similar as MYSQL BINARY and VARBINARY types. Classification of MySQL BLOB MySQL BLOB Types Maximum Storage Length (in bytes) TINYBLOB ((2^8)-1) BLOB ((2^16)-1) MEDIUMBLOB ((2^24)-1) LONGBLOB ((2^32)-1) […]
This tutorial was added to PHP.

Update/Delete Multiple Rows using PHP

September 23, 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 one at a time. This article deals with selecting multiple rows for applying update/delete operations. For selecting multiple rows, we are going to use checkbox input for submitting selected […]
This tutorial was added to PHP.

PHP CRUD with MySQL

September 6, 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 Create, Read, Update and Delete operations with database table records. In the previous tutorial, we have seen how to access MySQL database via PHP. In this example, we are […]
This tutorial was added to PHP.

PHP MyAdmin

August 5, 2013
phpMyAdmin is one of the popular client software tools with an extraordinary user interface that helps to perform database handling operations effectively. This tool will reduce our burden on having such user interface to perform some simple and basic database operations directly, instead of writing queries for obtaining them. We can also write queries using […]
This tutorial was added to MySQL.

Loading List box Dynamically

July 12, 2013
We have seen the various type of HTML form elements while discussing accessing form data. Among them, HTML list boxes which contains list of values are added by HTML <select> tags containing <option> tags for each entry. And, while interacting with the form, the user is limited to select the value within these list of […]
This tutorial was added to PHP.

MySQL Fetch using PHP

June 14, 2013
PHP provides a huge list of MySQL functions to access the database from the front end. Among those functions, we are going to discuss some of them that are used to fetch data from the database. Such functions differ with the type of results they are expected to return. In PHP, MySQL fetches results can […]
This tutorial was added to MySQL.

PHP Pagination

June 7, 2013
In this article, we are going to discuss how to paginate set of items retrieved from the database by using PHP script. PHP pagination cause with a limited number of results per page and have links to see pages that exist before and after the current page. By providing pagination feature for the user on […]
This tutorial was added to PHP.

Filtering MySQL Results by Applying PHP Conditions

May 22, 2013
In this article, we are going to discuss how to filter selected database rows based on the conditions applied using PHP. Let us have an example to deal with this conditional filtering process. For that, We can take student admission program to shortlist students who had applied before six months at least. Following steps are […]
This tutorial was added to PHP.

PHP Input Filtering

May 18, 2013
PHP is one of the easy handling languages which makes developers be comfortable to work with. On the other hand, it is easy to hack the code from outside. Since web applications accept data from outsiders spread among the world, we need to validate such data, before allowing it to our PHP application, for security […]
This tutorial was added to PHP.

↑ Back to Top