PDO allows you to work with any database that has a PDO driver available. PDO relies on database-specific drivers, e.g., PDO_MYSQL for MySQL, PDO_PGSQL for PostgreSQL, PDO_OCI for Oracle database, etc., to function properly. Here’s the complete list of PDO drivers<\/a>.<\/p>\n\n\n\n Therefore, to use PDO for a specific database, you need to have a corresponding database driver available.<\/p>\n\n\n\n The following diagram illustrates how PDO works:<\/p>\n\n\n\n PDO makes it easy to deploy PHP applications because it doesn’t require you to manually include any script files in your application like other libraries.<\/p>\n\n\n\n This section shows you step by step how to connect to some relational database management systems, including MySQL and PostgreSQL.<\/p>\n\n\n\n This section illustrates the common database operation, including c<\/strong>reating (insert), r<\/strong>eading(select), u<\/strong>pdating, and d<\/strong>eleting data using PDO. These basic operations are often called CRUD.<\/p>\n\n\n\n This section discusses various fetch* methods and modes in detail.<\/p>\n\n\n\n This section shows you some examples of dealing with stored procedures, including:<\/p>\n\n\n\n PDO provides you with some handy methods, including ![\"php](\"https:\/\/phptutorial.net\/wp-content\/uploads\/2021\/04\/php-pdo.svg\")
<\/figure><\/div>\n\n\n\nSection 1. PDO Quick Start #<\/a><\/h2>\n\n\n\n
Section 2. Creating a sample database #<\/a><\/h2>\n\n\n\n
Section 3. Prepared Statements #<\/a><\/h2>\n\n\n\n
Section 4. CRUD in PDO #<\/a><\/h2>\n\n\n\n
Section 5. Fetching data #<\/a><\/h2>\n\n\n\n
Section 6. Calling Stored Procedures #<\/a><\/h2>\n\n\n\n
Section 6. Managing Transaction in PDO #<\/a><\/h2>\n\n\n\n
beginTransaction()<\/code>, commit()<\/code> and rollBack()<\/code> that handles transactions effectively. This section gives you some examples of handling transactions in your web application.<\/p>\n\n\n\n