Simple Database Abstraction for PHP and MySQL

LIVE PREVIEWBUY FOR $9

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

LIVE PREVIEWBUY FOR $9

You might like