Monday, May 28, 2012

PHP MySQL Query Builder Library

PHP Scripts - PHP MySQL Query Builder Library - CodeCanyon

PHP MySQL Query Builder Library his title this type of PHPScripts/DatabaseAbstractions This time I will review,made by ser-html, PHPScripts/DatabaseAbstractions is sold at a price of $9 in CodeCanyon.
PHP MySQL Query Builder Library - CodeCanyon Item for Sale
builder // generator // library // mysql // object-oriented // oop // php // query //
Created 11 June 12
Last Update 24 September 12
Software Version PHP 5.x, PHP 5.0 - 5.2, PHP 5.3, MySQL 4.x, MySQL 5.x
Files Included PHP

Burner CMS

Burner CMS allows you to simply define data models and manage data right away. Get it now and save! Note: The Burner CMS API uses an improved version of this library.

PHP MySQL Query Builder Library

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

What people are saying:

“This script is excellent. Simple and amazing for quick and not-so-dirt job.” – internavigare
I’ve just bought it. Playing with it for a while and it’s great, btw, I would love to see the “group by” function as well. Good luck to your sales :) – youngguy
That’s great thanks, great script by the way it has been so useful. – dutchboy2382

Requires PHP version 5.1 or higher, with PDO installed.

Updates

  • September 24, 2012: Fixed a couple small bugs.
  • June 16, 2012: Fixed small method naming error.
  • June 12, 2012: Added support for SUM(), AVG(), and grouping AND/OR clauses (e.g., (w and x) or (y and z)).

No comments:

Post a Comment