13 best PHP SQL Database libraries in 2024
by marketing.admin@openweaver.com 
Updated: Feb 11, 2023
Guide Kit
PHP is a powerful, flexible programming language for web development. It’s easy to learn and use, making it one of the most popular languages on the web. PHP has a number of built-in functions for working with SQL databases. A major part of any web application is the database. PHP is one of the most popular server-side scripting languages. It has a lot of features and libraries that make it easy for developers to create complex websites and applications. PHP allows developers to work with databases either directly or through an abstraction layer called PDO (PHP Data Objects). Database libraries are packages that provide additional functionality to PDO, making it easier for developers to work with relational databases like MySQL or PostgreSQL. Some of the most widely used open source libraries for PHP SQL Database among developers include: php-crud-api - Single file PHP script that adds a REST API to a SQL database; countries-states-cities-database - World countries; php-my-sql-pdo-database-class - A database class for PHP MySQL which utilizes PDO.
php-crud-apiby mevdschee
3341 Version:v2.14.19Single file PHP script that adds a REST API to a SQL database
php-crud-apiby mevdschee
PHP 3341 Version:v2.14.19 License: Permissive (MIT)
countries-states-cities-databaseby dr5hn
5022 Version:v1.9🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
countries-states-cities-databaseby dr5hn
PHP 5022 Version:v1.9 License: Strong Copyleft (ODbL-1.0)
php-my-sql-pdo-database-classby wickyaswal
648 Version:CurrentA database class for PHP MySQL which utilizes PDO.
php-my-sql-pdo-database-classby wickyaswal
PHP 648 Version:Current License: Others (Non-SPDX)
DBDiffby DBDiff
580 Version:v1.0.0Compare MySQL databases & automatically create schema & data change scripts/migrations rapidly (up & down SQL supported) for database version control. Supports *some* migration tools.
DBDiffby DBDiff
PHP 580 Version:v1.0.0 License: Permissive (MIT)
v8-archiveby directus
509 Version:v8.8.1
License: No License (null)Directus Database API — Wraps Custom SQL Databases with a REST/GraphQL API
v8-archiveby directus
PHP 509 Version:v8.8.1 License: No License
cryptdbby CryptDB
422 Version:CurrentA database system that can process SQL queries over encrypted data.
cryptdbby CryptDB
PHP 422 Version:Current License: Others (Non-SPDX)
databy atk4
262 Version:4.0.0Data Access PHP Framework for SQL & high-latency databases
databy atk4
PHP 262 Version:4.0.0 License: Permissive (MIT)
migrationby byjg
145 Version:4.2.3Simple library writen in PHP without framework dependancy for database version control. Supports Sqlite, MySql, Sql Server and Postgres
migrationby byjg
PHP 145 Version:4.2.3 License: Permissive (MIT)
SQLBuilderby c9s
143 Version:4.0.1A powerful, fast, cross-platform SQL Builder for PHP. Convert your structured data into SQL queries with a fluent style interface and targeting on all the mainstream database (MySQL, PostgreSQL, SQLite)
SQLBuilderby c9s
PHP 143 Version:4.0.1 License: Others (Non-SPDX)
laravel-migration-viewsby staudenmeir
97 Version:v1.6.1Laravel database migrations with SQL views
laravel-migration-viewsby staudenmeir
PHP 97 Version:v1.6.1 License: Permissive (MIT)
firebirdwebadminby mariuz
94 Version:3.4.1FirebirdWebAdmin is a web frontend for the Firebird SQL database server written in PHP.
firebirdwebadminby mariuz
PHP 94 Version:3.4.1 License: Strong Copyleft (GPL-2.0)
laminas-dbby laminas
105 Version:2.17.0Database abstraction layer, SQL abstraction, result set abstraction, and RowDataGateway and TableDataGateway implementations
laminas-dbby laminas
PHP 105 Version:2.17.0 License: Permissive (BSD-3-Clause)