chillerlan/php-database

A PHP SQL client and querybuilder for the most common databases, namely: MySQL, PostgreSQL, SQLite3, Microsoft SQL Server (Transact) and Firebird.

Documentation

Requirements

PHP 8.2+
one of the supported databases, set up to work with PHP:
- MySQL (5.5+) / MariaDB via ext-mysqli or ext-pdo_mysql
- PostgreSQL (9.5+) via ext-pgsql or ext-pdo_pgsql
- SQLite3 via ext-pdo_sqlite
- Firebird (2.5+) via ext-pdo_firebird
- Microsoft SQL Server (transact-sql) via ext-sqlsrv or ext-pdo_sqlsrv

Installation

requires composer

composer.json

(note: replace dev-main with a version boundary)

{
	"require": {
		"php": "^8.2",
		"chillerlan/php-database": "dev-main"
	}
}

Profit!