Recommend this page to a friend! |
Download .zip |
Info | Example | View files (61) | Download .zip | Reputation | Support forum (3) | Blog | Links |
Last Updated | Ratings | Unique User Downloads | Download Rankings | |||||
2016-05-14 (5 months ago) | Not enough user ratings | Total: 771 | All time: 4,217 This week: 941 |
Version | License | PHP version | Categories | |||
objsql 3.9.0 | Custom (specified... | 5.5 | PHP 5, Databases |
Description | Author | |
This package can access multiple database types using a common interface to execute queries on SQL databases. |
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 |
File | Role | Description | ||
---|---|---|---|---|
drivers (7 directories) | ||||
objSQL_3.9.0_docs (40 files) | ||||
changelog.txt | Data | Changelog | ||
license.txt | Lic. | License | ||
objSQL.php | Class | Database class file | ||
obj_helper.php | Aux. | objSQL auxillary helper class | ||
README.md | Data | Auxiliary data | ||
readme.txt | Doc. | readme | ||
tutorial-examples.html | Example | objSQL 3.9.0 Example Documentation |
Files | / | drivers |
Files | / | drivers | / | cubrid |
File | Role | Description |
---|---|---|
driver.php | Class | Standard CUBRID Driver |
pdo_driver.php | Class | CUBRID PDO Driver |
Files | / | drivers | / | firebird |
File | Role | Description |
---|---|---|
driver.php | Class | Standard Firebird Driver |
pdo_driver.php | Class | Firebird PDO Driver |
Files | / | drivers | / | mysql |
File | Role | Description |
---|---|---|
driver.php | Class | Standard MySQL/MariaDB Driver |
pdo_driver.php | Class | MySQL/MariaDB PDO Driver |
Files | / | drivers | / | oracle |
File | Role | Description |
---|---|---|
driver.php | Class | Standard Oracle Driver |
pdo_driver.php | Class | Oracle PDO Driver |
Files | / | drivers | / | pgsql |
File | Role | Description |
---|---|---|
driver.php | Class | Standard PgSQL Driver |
pdo_driver.php | Class | PgSQL PDO Driver |
Files | / | drivers | / | sqlite |
File | Role | Description |
---|---|---|
driver.php | Class | Standard SQLite3 Driver |
pdo_driver.php | Class | SQLite3 PDO Driver |
Files | / | drivers | / | sqlsrv |
File | Role | Description |
---|---|---|
driver.php | Class | Standard SQL Server Driver |
pdo_driver.php | Class | SQL Server PDO Driver |
Files | / | objSQL_3.9.0_docs |
File | Role | Description |
---|---|---|
index.html | Doc. | Documentation |
obj_affected_rows.html | Doc. | Documentation |
obj_batch_data.html | Doc. | Documentation |
obj_bind.html | Doc. | Documentation |
obj_close.html | Doc. | Documentation |
obj_close_statement.html | Doc. | Documentation |
obj_cols.html | Doc. | Documentation |
obj_commit.html | Doc. | Documentation |
obj_data.html | Doc. | Documentation |
obj_delete.html | Doc. | Documentation |
obj_error.html | Doc. | Documentation |
obj_error_msg.html | Doc. | Documentation |
obj_escape.html | Doc. | Documentation |
obj_execute.html | Doc. | Documentation |
obj_fetch_assoc.html | Doc. | Documentation |
obj_fetch_num.html | Doc. | Documentation |
obj_fetch_object.html | Doc. | Documentation |
obj_field.html | Doc. | Documentation |
obj_free_result.html | Doc. | Documentation |
obj_free_statement.html | Doc. | Documentation |
obj_info.html | Doc. | Documentation |
obj_insert.html | Doc. | Documentation |
obj_limit.html | Doc. | Documentation |
obj_num_fields.html | Doc. | Documentation |
obj_num_rows.html | Doc. | Documentation |
obj_offset.html | Doc. | Documentation |
obj_order_by.html | Doc. | Documentation |
obj_paging.html | Doc. | Documentation |
obj_prepare_statement.html | Doc. | Documentation |
obj_query.html | Doc. | Documentation |
obj_rollback.html | Doc. | Documentation |
obj_row_count.html | Doc. | Documentation |
obj_savepoint.html | Doc. | Documentation |
obj_select.html | Doc. | Documentation |
obj_sort_order.html | Doc. | Documentation |
obj_style.css | Data | Auxiliary data |
obj_table.html | Doc. | Documentation |
obj_transaction.html | Doc. | Documentation |
obj_update.html | Doc. | Documentation |
obj_where.html | Doc. | Documentation |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
96% |
|
|
User Comments (1) | |||||
|
Applications that use this package |
If you know an application of this package, send a message to the author to add a link here.
Related pages |
objSQL 3.9.0 Docs objSQL 3.9.0 Online Documentation |