PHP download

Download the PHP package eclipxe/engineworks-dbal without Composer

On this page you can find all versions of the php package eclipxe/engineworks-dbal. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download eclipxe/engineworks-dbal
More information about eclipxe/engineworks-dbal
Files in eclipxe/engineworks-dbal

Vendor eclipxe
Package engineworks-dbal
Short Description PHP Database Abstraction Layer
License MIT
Homepage https://github.com/eclipxe13/engineworks-dbal

Keywords dbal sql sqlite3 mssql recordset mysqli reader sqlsrv database abstraction layer

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

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 PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

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.

Please rate this library. Is it a good library?

Informations about the package engineworks-dbal

eclipxe/engineworks-dbal - Database Abstraction Layer

I create this library to abstract the interactions with a relational database. At the time it was created the PDO extension did not exist. If possible try to use PDO instead of this library, mostly because prepared statements.

I'm maintaining this library because I have several applications depending on it, and I had shared this to other people, so they can also maintain their own projects.

Installation

To install this library you can use:

Objects

EngineWorks\DBAL\DBAL

Main connection object, has several query methods to get the results just as needed. It also contains sql methods to translate SQL Dialects from different drivers.

EngineWorks\DBAL\Recordset

The Recordset class mimics the main methods of the recordset:

Open the recordset using an SQL Statement.
Walk the recordset using the current cursor.
Access values using the values array, stores original values.
Use of magic methods Update and Delete.
Convert from/to database types to common types.

Some drivers do not know how to get the primary keys on a query, in that case you can specify the entity to affect and also the primary keys.

Mysql driver support this feature, it will check for primary keys, auto incrementing fields or unique indexes.

EngineWorks\DBAL\Pager

The Pager class uses Recordset to access a limited page of a query, it does not load all the records but only the requested ones

About drivers

This library supports Mysqli, Mssql, Sqlsrv and Sqlite3 drivers, you are free to create your own and (please) share it with me.

Mysqli

This is the most tested driver on production.

Sqlsrv

This driver uses Microsoft PHP Driver for SQL Server.
Result does not know the entity or primary keys of the query. Use overrideEntity and overrideKeys when create a Recordset for update or delete.

Sqlite3

Result does not know the entity or primary keys of the query. Use overrideEntity and overrideKeys when create a Recordset for update or delete.
When a result is empty (nothing to fetch) it is not possible to know the type of the fields, this make this driver unstable to update using Recordset.
The method SQLite3Result::fetchArray put the cursor in the first position when called after end of list. This behavior has been corrected on Result and fetch returns always false.

Mssql

This driver uses PDO dblib, you will need FreeTDS.
Result does not know the entity or primary keys of the query. Use overrideEntity and overrideKeys when create a Recordset for update or delete.
The function to quote (PDO::quote) fail with multibyte strings, we are using simple replacements of ' to ''
This driver is not really compatible with PHP 7, use Sqlsrv instead

Compatibility

This class will be compatible according to PHP Supported versions.

Contributing

Contributions are welcome! Please read CONTRIBUTING for details and don't forget to take a look in the files TODO and CHANGELOG.

License

All versions of engineworks-dbal with dependencies

PHP Build Version

Package Version

Version v2.3.5 Release 29. Apr 2024
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of engineworks-dbal from vendor eclipxe

Requires php Version >=7.3
ext-ctype Version *
psr/log Version ^1.1|^2.0|^3.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package eclipxe/engineworks-dbal contains the following files

Loading the files please wait ....