DB layer 2.0

Objectives

• Switch to prepared statements - using placeholders and preparing statements protects against sql injection
• Remove the need for data to be add/strip slashed all over the place in the code.
• Make it so that the database object can be subclassed - this means for unit tests that want to test database access, the test framework can override necessary methods

Ideas

• Object Relational Mapping style
• There are already some PHP ORM tools:
  • Doctrine
  • PHP Object Generator
  • Propel