In this section, you will learn how to interact with MySQL using the PHP Data Objects or PDO.
The PDO is a data-access abstraction layer. It is a PHP extension that provides a lightweight and consistent interface for interacting with any databases including MySQL.
Connecting to MySQL Database – this tutorial shows you how to connect to MySQL database server using PHP PDO object.
Creating A New Table – this tutorial shows you step by step how to create a table by using PHP PDO object.
Querying Data from Database – you will learn how to query data from MySQL database by using PHP PDO and use PDO prepared statement to select data securely.
Inserting Data Into a Table – this tutorial shows you how to use PHP to insert data into MySQL a table.
Updating Data – this tutorial shows you how to update data in a MySQL table using PHP PDO prepared statement.
Deleting Data – in this tutorial, you are going to learn how to delete data from the MySQL database table using PHP PDO.
Calling MySQL Stored Procedures – this tutorial shows you how to call MySQL stored procedures using PHP PDO. It guides you on how to call stored procedures that return result sets and stored procedures that accept input/output parameters.
Dealing with transactions – in this tutorial, we will show you how to handle MySQL transactions in PHP to ensure data integrity of databases. In addition, we will give you an example of the money transfer transaction between two bank accounts for the demonstration.
Manipulating BLOB – in this tutorial, you will learn how to handle BLOB data using PDO. We will show you how to insert, update and select BLOB data from the MySQL database.