3703887-Simple Database Abstraction for PHP and MySQL.zip

Manipulate with your data using simple methods
Powerful actions in simple Active Record style. No any SQL writing. Fast and low-memory usage, compact and cleaner resulting code

Features

• Simple insert, update and delete
• Batch inserts and updates
• Where conditions and fulltext search
• Sorting and grouping
• Joins of multiple tables
• Foreign keys updating
• Checking the uniqueness of records
• Concatenation and group concatenation
• Min, max, sum and total
• Increments and decrements
• You do not need to remember about tildes and quotes

System Requirements

• PHP5
• MySQL5
• MySQLi extention

Changelog

v.1.0.6

• Concat() fixed.

v.1.0.5

• Insert() fixed.

v.1.0.4

• Minor fixes in where() method.
• Added new methods open_sub() and close_sub() – creating sub-conditions between where() parts.

v.1.0.3

• ‘Like’ methods fixed.
• Added order_by() method (alias of sort_by()).

v.1.0.2

• New methods get_list() and get_single().
• Added ‘alias’ parameter in join methods.
• Random fixed. Other minor bugs fixed.

v.1.0.1

• get_one() and fields() methods fixed.
• Added new method distinct().

Suggestions and comments are welcome.

Documentation