Beyond SQL and ORM: Object-oriented MySQL Querying in PHP

With the popularization of open source development frameworks over the past few years, developers all around have started utilizing concepts like Object Relational Mapping (ORM) and Model View Controller (MVC) to help develop MySQL applications faster that are more robust and easier to maintain.

While the ORM in most frameworks have always been able to provide basic Create, Restore, Update and Delete (CRUD) functionality, most PHP developers quickly find themselves needing more than just CRUD.

Concepts in Object-Oriented Querying (OOQ) can take database querying beyond simple CRUD. Building upon commonly used techniques in metadata analysis and code generation, OOQ gives developers a powerful, consistent interface to perform complex queries without needing to code tedious, hard to maintain SQL.

Using live coding demos, we will explain and illustrate these techniques, and we will also discuss how OOQ-methodologies can be used to accelerate new application development or enhance existing PHP/MySQL development project teams.