mittnett/dbal

A very simple database abstraction layer. Uses PDO under-the-hood and supports mysql/mariadb and postgres.

v1.4.2 2022-10-15 21:10 UTC

This package is auto-updated.

Last update: 2024-10-16 01:50:34 UTC


README

A very simple database abstraction layer. Uses PDO under-the-hood and supports mysql/mariadb and postgres.

Usage

Setup a connection:

<?php

// MySQL:
$db = new \HbLib\DBAL\DatabaseConnection(new PDO('mysql:host=localhost;dbname=app', 'app', 'secret'), new \HbLib\DBAL\Driver\MySQLDriver());

// Postgres:
$db = new \HbLib\DBAL\DatabaseConnection(new PDO('pgsql:host=localhost;dbname=app', 'app', 'secret'), new \HbLib\DBAL\Driver\PostgresDriver());

One can use \HbLib\DBAL\LazyDatabaseConnection which only creates the PDO connection when needed.