Projects objSQL

objSQL: PHP5 Database Access Class

objSQL is a PHP5 based database access layer for multiple database types. Primarily designed for small to medium projects, objSQL uses an "Object Based" approach for handling general database queries. Built-in support for transactions, sequences and prepared statements allow for a common interface to all supported database types. Recordset paging is simplified by incorporating the limit and offset binding methods along with prepared statements. Tasks such as escaping/unescaping string data is performed internally and POST numeric string data is treated as numeric data. objSQL is easily extended to create your own unique classes and methods.

objSQL Features:

  • Object based code simplifies hooking into projects and allows for better encapsulation.
  • Prepared queries with parameter binding.
  • Transaction support including rollbacks and savepoints*.
  • Supports sequences and generators.
  • Very small footprint with the entire library approximately 170Kb in size.
  • Requires no third party libraries. See requirements below.
   * SQLite 2 does not support transactional savepoints

Supported Databases:

  • IBM DB2 8.2+
  • Firebird 1.5+
  • Ingres 2006
  • MaxDB
  • MySQL 3+ (4.1+ required for transaction support)
  • Oracle 8i+
  • PostgreSQL 7.4+
  • SQL Server 2000+
  • SQLite 2.8+ (bundled w/PHP5)
  • Sybase ASE 15

objSQL Requirements:

  • PHP5+ (5.2.x recommended)
  • Enabled PHP extension
Version:
  • 2.0.0

License:

  • LGPL

Downloads | Documentation | Support