• Drag and Drop Multiple Files Upload with HTML5, jQuery & FormData
• Very precise jQuery/Ajax Star Rating Plugin Tutorial
• jQuery editable grid system tutorial
• jQuery comment system tutorial
• MySQL, PHP, OOP database connection
• Ajax and jQuery autocomplete tutorial
• jQuery infinite category tree management system

Database

PDO tutorial - Connecting MySQL with PDO

PDO is a PHP class designed to allow PHP to communicate with a data server. (PDO: PHP Data Object)

PDO is what we call an abstraction layer, which means that it will allow to communicate with any database server: MySQL, Oracle, Postgresql, etc ... (on simple queries).

PDO will allow (it's his major interest) to secure queries and facilitate code reuse through prepared statement.

In this tutorial you will learn how to connect MySQL database using PDO and PHP.

MySQL, PHP, OOP database connection

In this tutorial I explain how to set up a database connection, using Object-Oriented Programming (OOP), PHP and MySQL. This can be adapted with PDO or MySQLi of course.

This tutorial includes fully working code example, for the SELECT, INSERT INTO and UPDATE Statements.

The construct method receives all the parameters required for creating new instance...check it out.