CodeCanyon

Simple Database Abstraction for PHP and MySQL

Simple Database Abstraction for PHP and MySQL

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

by
by
by
by
by
by