PHP Classes

objSQL: Access different databases with the same interface

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 820 All time: 4,211 This week: 206Up
Version License PHP version Categories
objsql 3.9.0Custom (specified...5.5PHP 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
  Performance   Level  
Innovation award
Innovation award
Nominee: 1x

 

Example

 

Details

App: objSQL Version: 3.9.0 Author: MT Jordan <mtjo62@gmail.com> Copyright: 2016 License: zlib/libpng License ********************************************************************************* objSQL: Database Access Class objSQL is a PHP 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 * Batch operations (delete/insert/update) for all supported databases * Very small footprint with the entire library approximately 250KB 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: * Firebird 2.5 * MariaDB 5.1+ * MySQL 5.1+ * Oracle 12 * PostgreSQL 9+ * SQL Server 2012+ (Beta drivers - https://github.com/Azure/msphpsql/releases) * SQLite3 objSQL Requirements: * PHP 5.4+ (5.6+ recommended) * Enabled PHP extensions * Enabled PDO extensions *********************************************************************************

  Files folder image Files (61)  
File Role Description
Files folder imagedrivers (7 directories)
Files folder imageobjSQL_3.9.0_docs (40 files)
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.md Data Auxiliary data
Accessible without login Plain text file readme.txt Doc. readme
Accessible without login HTML file tutorial-examples.html Example objSQL 3.9.0 Example Documentation

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 96%
Total:820
This week:0
All time:4,211
This week:206Up
User Ratings User Comments (1)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:-
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1485
 
exceptional, good work
8 years ago (Alvaro Ramos)
80%StarStarStarStarStar