Database abstraction with PHP & Doctrine 2

Interact with a relational database thanks to PHP and the PDO extension

• Introduction to PDO (DSN, prepared statements, transactions…)
• Establishing a MySQL or SQLite connection with PDO
• Executing a SQL query on the database
• Securing critical SQL statements with a transaction
• Refactoring the business logic into model classes

Introduction to the Doctrine 2 PHP library

• Introduction to the Doctrine2 library
• Installing Doctrine2 from Git and PEAR
• Discovering database abstraction pros and cons
• Exploring the Doctrine2 architecture (Common / DBAL / ORM)

Databases abstraction with the Doctrine 2 DBAL component

• Introduction to the database abstraction principle
• Connectiong to a MySQL or SQLite databases
• Selecting records from a database table
• Inserting new records in a database table
• Updating some database records
• Deleting records from the database
• Executing SQL queries in a transaction to ensure security
• Manipulating a database schema (tables, columns, indexes…)

Object relational mapping with the Doctrine 2 ORM component

• Discovering the object relational mapping principle
• Designing a database schema by defining PHP classes
• Adding relations between models (1-n, m-n, 1-1…)
• Adding table indexes
• Persisting business objects to the database
• Querying a database thanks to the QueryBuilder object
• Overloading business objects with custom methods
• Detaching objects from their persistence manager
• Executing batch SQL queries
• Writing abstract SQL queries thanks to the DQL language

Migrating a database schema thanks to the Migrations component

• Introduction to the Doctrine 2 Migrations component
• Creating migration classes by hand
• Generating migration classes from an existing database schema
• Automating migration procedures from the command line interface