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

Architecture and Technology, LAMP, PHP and MySQL
Location: Ballroom A Level: Intermediate

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.

Photo of Mike Ho

Mike Ho

Quasidea Development

When he is not skiing in Lake Tahoe or playing cards with friends from church, Mike Ho is working at Quasidea Development, an idea incubator. He has over 8 years of software development and IT consulting experience, with a client list that includes NASA, Stanford University, Microsoft and Lockheed Martin. His past work includes working on the original Microsoft ASP.NET Starter Kits, and currently he is the lead developer of the Qcodo Development Framework for PHP. He holds a B.A. in Computer Science from Northwestern University…Go Cats!

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.