Download the PHP package xp-framework/rdbms without Composer
On this page you can find all versions of the php package xp-framework/rdbms. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download xp-framework/rdbms
More information about xp-framework/rdbms
Files in xp-framework/rdbms
Package rdbms
Short Description RDBMS support for the XP Framework
License BSD-3-Clause
Homepage http://xp-framework.net/
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package rdbms
RDBMS support for the XP Framework
RDBMS access APIs, connection manager, reverse engineering, O/R mapping.
The DriverManager model
To retrieve a connection class from the driver manager, you need to use the rdbms.DriverManager class.
The DriverManager class expects a unified connection string (we call it DSN).
Supported drivers
The DriverManager will select an appropriate driver from the DSN string via its name. This will load an implemenation class which is either based on a PHP extension or implements the protocol to communicate with the database system in userland code. For the latter case, you need not do anything to your PHP setup; if there's a hard dependency on a PHP extension, you need to install that before you can use the driver.
| Database system | DSN name | PHP Extensions | Userland driver |
|---|---|---|---|
| MySQL | mysql |
ext/mysql or ext/mysqli | :white_check_mark: |
| PostgreSQL | pgsql |
ext/pgsql | |
| SQLite3 | sqlite |
ext/sqlite3 | |
| Interbase/FireBird | ibase |
ext/interbase | |
| Sybase | sybase |
ext/sybase-ct | :white_check_mark: |
| MSSQL | mssql |
ext/mssql or ext/sqlsrv | :white_check_mark: |
Basics
Once we have fetched a specific database connection class, we can now invoke a number of methods on it.
Selecting
Selecting can be done with the "one-stop" method select() which will return all results into an array. Alternatively, the query() method allows iterative fetching.
Inserting
To "bind" parameters to an SQL query, the query, select, update, delete and insert methods offer a printf style tokenizer and support varargs syntax. These take care of NULL, type handling and proper escaping for you.
Updating
The update() and delete() methods will return the number of affected rows, in case you're interested.
Deleting
Even if your RDBMS requires you to use single quotes (or what-else), the API will take care of rewriting string literals for you.
Exceptions
All of the above methods will throw exceptions for failed SQL queries, syntax errors, connection failure etc. All these exceptions are subclasses of rdbms.SQLException, so to catch all possible errors, use it in the catch clause:
Transactions
To start a transaction, you can use the connection's begin(), commit() and rollback() methods as follows:
Note: Not all database systems support transactions, and of those that do, not all support nested transactions. Be sure to read the manual pages of the RDBMS you are accessing.
All versions of rdbms with dependencies
xp-framework/logging Version ^11.0 | ^10.0 | ^9.0 | ^8.0 | ^7.0
xp-framework/networking Version ^10.0 | ^9.0 | ^8.0 | ^7.0
xp-framework/math Version ^9.0 | ^8.0 | ^7.0
php Version >=7.0.0