objSQL 2.1.0 Documentation

Description
Version: 2.1.0
Author: MT Jordan mtjo62@gmail.com
Link: http://objsql.sourceforge.net/
Copyright: 2004-2010 openSource Partners
License: LGPL

objSQL is a PHP5 based database utility for performing SQL queries. Designed primarily for small to medium projects, objSQL uses an object based approach in supporting multiple database types.


Features
  • Performs connections and SQL queries across multiple database types.
  • Supports SQL Transactions.
  • Supports Sequences and Generators.
  • Returns resultsets as arrays and objects.
  • Very small footprint. The total application package is ~170Kb making it ideal for embedding into small and medium projects or hooking into your own abstraction layer.
  • Classes utilize private members which provides better encapsulation of your controller layers.
  • Helper methods such as $db->select() and $db->delete() to speed up development time.
  • Requires no third party libraries other than the enabled PHP extension for a particular database.

Requirements

PHP: Version 5+ (PHP 5.3.x recommended)


Supported Databases
DB2: Version 8.2+ (tested on DB2 Express 8.2)
Firebird: Version 1.5+ (tested on 2)
Ingres: Version 9.x (tested on 2006 R2)
MaxDB: Version 7.6 (tested on 7.6)
MSSQL: SQL Server 2000+ (tested on SQL Server 2000, SQL Server 2005 Express and SQL Server 2008 Express Beta)
MySQL: Version 3+ (4.1+ required for transaction support - uses mysqli extension)
Oracle: 8i, 9i & 10g (tested on 9i & 10g Express)
PostgreSQL: Version 7.4+ (tested on 8.2)
SQLite: Version 2+ (3.x required for full transaction support - requires PHP 5.3.x)
Sybase ASE: Version 15 (tested on 15)

2.1.0