Download the PHP package bentools/simple-dbal without Composer
On this page you can find all versions of the php package bentools/simple-dbal. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
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 simple-dbal
SimpleDBAL
A modern wrapper on top of PDO and Mysqli, written in PHP7.1. It aims at exposing the same API regardless of the one your project uses.
Introduction
PHP offers 2 different APIs to connect to a SQL database: PDO and mysqli (we won't talk about mysql_* functions since they're deprecated). Both do more or less the same thing, but:
- Their API are completely different (different method names and signatures)
- They both have their own pros and cons.
- Some features of one are missing in the other.
This library exposes an API that can be used by any of them, transparently, in a more modern approach (OOP, iterators, return types, etc).
This also means you can switch from PDO to mysqli and vice-versa without having to rewrite your whole code.
From my personnal experience, I was used to PDO and was forced to deal with mysqli in another project and it was really messy.
Overview
Additionnal features
- On-the-fly parameter binding for prepared statements (simply pass an array of arguments after the query)
DateTimeInterfaceobjects automatic binding (formats to YYYY-MM-DD HH:ii:ss)- Asynchronous queries (Promises)
- Parallel queries
- Support for named parameters in prepared statements for
mysqli(polyfill with regexps - experimental feature) - Can silently reconnect after a lost connection
The Result object
Every query sent to the adapter will return a BenTools\SimpleDBAL\Contract\ResultInterface object.
For SELECT queries, use the following methods:
$result->asArray()to fetch an array containing the whole resultset$result->asRow()to fetch the 1st row of the resultset, as an associative array$result->asList()to fetch the 1st column of the resultset, as a sequential array$result->asValue()to fetch a single value (i.e the 1st column of the 1st row)foreach ($result as $row)to iterate over the resultset (uses lazy-loading)count($result)to return the number of rows of the resultset.
For INSERT / UPDATE / DELETE queries, use the following methods:
count($result)to return the number of affected rows$result->getLastInsertId()to get the id of the last inserted row or sequence value.
Installation
Tests
Documentation
Getting started
Configuring auto-reconnect
Asynchronous and parallel queries
Connection pools
Known Issues
