Awesome

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!