PHP Classes
elePHPant
Icontem

objSQL: Access different databases with the same interface

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files Example   View files View files (20)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2015-06-22 (1 month ago) RSS 2.0 feedNot enough user ratingsTotal: 712 This week: 5All time: 4,333 This week: 231Up
Version License PHP version Categories  
objsql 3.7.0Custom (specified...5.4PHP 5, Databases
Description Author  

This package can access multiple database types using a common interface to execute queries on SQL databases.

Currently it can establish connections given a connection string, executing SQL queries using prepared statements, managed transactions, execute SQL Helper methods to SELECT, INSERT, UPDATE and DELETE queries from parameters that define tables, fields, field values and other parameters.

The package provides classes that implement the interface to access databases like CUBRID, Firebird, MariaDB, MySQL, Oracle, PostgreSQL, Microsoft SQL Server and SQLite3 using the standard and PDO drivers.

Picture of Mike Jordan
Name: Mike Jordan <contact>
Classes: 5 packages by
Country: United States United States
Age: 52
All time rank: 1686225 in United States United States
Week rank: 272 Up31 in United States United States Up
Innovation award
Innovation award
Nominee: 1x

Details provided by the author  
App:       objSQL
Version:   3.7.0
Author:    MT Jordan <mtjo62@gmail.com>
Copyright: 2015
License:   zlib/libpng License

*********************************************************************************

objSQL: Database Access Class

objSQL is a PHP5 based database access layer for web centric database servers.
Primarily designed for small to medium projects, objSQL utilizes an "Object Based"
approach for handling database queries with built in helper methods for a common
API.

*********************************************************************************

objSQL Features:

    * Object based code simplifies hooking into projects and allows for better
      encapsulation and exception handling
    * Reusable prepared queries with parameter binding
    * Transaction support including rollbacks and savepoints
    * Helper methods simplify executing queries without writing SQL statements
    * Very small footprint with the entire library approximately 280Kb in size
      unpacked
    * Requires no third party libraries other than enabled database PHP extensions
    * Supports both x86 and x64 builds of PHP 5.6 - See supported databases below
      for exceptions

Supported Databases:

    * CUBRID 9.1+
    * Firebird 2.5
    * MariaDB 5.1+
    * MySQL 5.1+
    * Oracle 11+
    * PostgreSQL 7.4+
    * SQL Server 2005+
    * SQLite3

Supported Databases PHP 5.6 - x86:

    * CUBRID 9.1+ 
    * Firebird 2.5
    * MariaDB 5.1+
    * MySQL 5.1+
    * Oracle 11 (PDO only)
    * Oracle 12
    * PostgreSQL 9+
    * SQL Server 2005+
    * SQLite3

Supported Databases PHP 5.6 - x64:

    * CUBRID 9.1+ 
    * Firebird 2.5 (PHP 5.6.4+)
    * MariaDB 5.1+
    * MySQL 5.1+
    * Oracle 12
    * PostgreSQL 9+
    * SQL Server 2012+
    * SQLite3
    
Supported Databases PHP 7 Alpha - x64:

    * Firebird 2.5 (PDO recommended for transactions)
    * MariaDB 5.1+
    * MySQL 5.1+
    * Oracle 12 (PDO only)
    * PostgreSQL 9+
    * SQLite3    

objSQL Requirements:

    * PHP 5.4+ (5.5+ recommended)
    * Enabled PHP extensions
    * Enabled PDO extensions

*********************************************************************************
  Files folder image Files  
File Role Description
Files folder imagedrivers (7 directories)
Accessible without login Plain text file changelog.txt Data Changelog
Accessible without login Plain text file license.txt Lic. License
Plain text file objSQL.php Class Database class file
Accessible without login Plain text file obj_helper.php Aux. objSQL auxillary helper class
Accessible without login Plain text file readme.txt Doc. readme
Accessible without login HTML file tutorial-examples.html Example objSQL 3.7.0 Example Documentation

  Files folder image Files  /  drivers  
File Role Description
Files folder imagecubrid (2 files)
Files folder imagefirebird (2 files)
Files folder imagemysql (2 files)
Files folder imageoracle (2 files)
Files folder imagepgsql (2 files)
Files folder imagesqlite (2 files)
Files folder imagesqlsrv (2 files)

  Files folder image Files  /  drivers  /  cubrid  
File Role Description
  Plain text file driver.php Class Standard CUBRID Driver
  Plain text file pdo_driver.php Class CUBRID PDO Driver

  Files folder image Files  /  drivers  /  firebird  
File Role Description
  Plain text file driver.php Class Standard Firebird Driver
  Plain text file pdo_driver.php Class Firebird PDO Driver

  Files folder image Files  /  drivers  /  mysql  
File Role Description
  Plain text file driver.php Class Standard MySQL/MariaDB Driver
  Plain text file pdo_driver.php Class MySQL/MariaDB PDO Driver

  Files folder image Files  /  drivers  /  oracle  
File Role Description
  Plain text file driver.php Class Standard Oracle Driver
  Plain text file pdo_driver.php Class Oracle PDO Driver

  Files folder image Files  /  drivers  /  pgsql  
File Role Description
  Plain text file driver.php Class Standard PgSQL Driver
  Plain text file pdo_driver.php Class PgSQL PDO Driver

  Files folder image Files  /  drivers  /  sqlite  
File Role Description
  Plain text file driver.php Class Standard SQLite3 Driver
  Plain text file pdo_driver.php Class SQLite3 PDO Driver

  Files folder image Files  /  drivers  /  sqlsrv  
File Role Description
  Plain text file driver.php Class Standard SQL Server Driver
  Plain text file pdo_driver.php Class SQL Server PDO Driver

 Version Control Unique User Downloads Download Rankings  
 0%Total:712All time:4,333
 This week:5This week:231Up