PHP Classes

objSQL: Access different databases with the same interface

Recommend this page to a friend!
  Info   View files Example   View files View files (61)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 820 All time: 4,207 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  
Name: Mike Jordan <contact>
Classes: 5 packages by
Country: United States United States
Age: 61
All time rank: 1460218 in United States United States
Week rank: 360 Up38 in United States United States Up
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  
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

  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

  Files folder image Files  /  objSQL_3.9.0_docs  
File Role Description
  Accessible without login HTML file index.html Doc. Documentation
  Accessible without login HTML file obj_affected_rows.html Doc. Documentation
  Accessible without login HTML file obj_batch_data.html Doc. Documentation
  Accessible without login HTML file obj_bind.html Doc. Documentation
  Accessible without login HTML file obj_close.html Doc. Documentation
  Accessible without login HTML file obj_close_statement.html Doc. Documentation
  Accessible without login HTML file obj_cols.html Doc. Documentation
  Accessible without login HTML file obj_commit.html Doc. Documentation
  Accessible without login HTML file obj_data.html Doc. Documentation
  Accessible without login HTML file obj_delete.html Doc. Documentation
  Accessible without login HTML file obj_error.html Doc. Documentation
  Accessible without login HTML file obj_error_msg.html Doc. Documentation
  Accessible without login HTML file obj_escape.html Doc. Documentation
  Accessible without login HTML file obj_execute.html Doc. Documentation
  Accessible without login HTML file obj_fetch_assoc.html Doc. Documentation
  Accessible without login HTML file obj_fetch_num.html Doc. Documentation
  Accessible without login HTML file obj_fetch_object.html Doc. Documentation
  Accessible without login HTML file obj_field.html Doc. Documentation
  Accessible without login HTML file obj_free_result.html Doc. Documentation
  Accessible without login HTML file obj_free_statement.html Doc. Documentation
  Accessible without login HTML file obj_info.html Doc. Documentation
  Accessible without login HTML file obj_insert.html Doc. Documentation
  Accessible without login HTML file obj_limit.html Doc. Documentation
  Accessible without login HTML file obj_num_fields.html Doc. Documentation
  Accessible without login HTML file obj_num_rows.html Doc. Documentation
  Accessible without login HTML file obj_offset.html Doc. Documentation
  Accessible without login HTML file obj_order_by.html Doc. Documentation
  Accessible without login HTML file obj_paging.html Doc. Documentation
  Accessible without login HTML file obj_prepare_statement.html Doc. Documentation
  Accessible without login HTML file obj_query.html Doc. Documentation
  Accessible without login HTML file obj_rollback.html Doc. Documentation
  Accessible without login HTML file obj_row_count.html Doc. Documentation
  Accessible without login HTML file obj_savepoint.html Doc. Documentation
  Accessible without login HTML file obj_select.html Doc. Documentation
  Accessible without login HTML file obj_sort_order.html Doc. Documentation
  Accessible without login Plain text file obj_style.css Data Auxiliary data
  Accessible without login HTML file obj_table.html Doc. Documentation
  Accessible without login HTML file obj_transaction.html Doc. Documentation
  Accessible without login HTML file obj_update.html Doc. Documentation
  Accessible without login HTML file obj_where.html Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 96%
Total:820
This week:0
All time:4,207
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:1492
 
exceptional, good work
7 years ago (Alvaro Ramos)
80%StarStarStarStarStar