Simple Database Abstraction for PHP and MySQL

Simple Database Abstraction for PHP and MySQL - CodeCanyon Item for Sale

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