PHP Databases

Recent Tutorial

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.

Access MySQL from PHP

April 13, 2013
MySQL has widely used database server for PHP platform. It is very easy to configure MySQL database to access it from PHP. First, we have to create a new database and its tables in MySQL server. I am using PHPMyAdmin client to manage the database. Create and Configure Database Open PHPMyAdmin and click Database tab. […]
This tutorial was added to MySQL.

↑ Back to Top