PHP MySQL Query Builder Library (Database Abstractions)

A PHP 5 library that allows you to easily create and run both simple and advanced MySQL queries in an object-oriented fashion, without using any SQL and without sacrificing functionality. Query types supported include:

• Select
• Join
• Insert
• Update
• Delete
• Create Table
• Alter Table
• Rename Table
• Truncate Table
• Drop Table

Additional features:

• Uses prepared statements
• Automatically cleans values to prevent SQL injection
• Object-oriented structure makes it easy to extend with custom functionality
• Code is well-commented and has great documentation:
  • http://beakerstudio.com/mysql
  • http://beakerstudio.com/mysql/api/packages/Default.html

Requires PHP version 5.1 or higher, with PDO installed.