Find more libraries on PHP Database Operations

Sends your logs to files, sockets, inboxes, databases and various web services

Powerful DataBase Abstraction Layer with many features for database schema introspection and schema management. 

A MongoDB based Eloquent model and Query builder for Laravel (Moloquent)

This package adds functionalities to the Eloquent model and Query builder for MongoDB, using the original Laravel API. This library extends the original Laravel classes, so it uses exactly the same methods. Install the package via Composer:. 

The lightweight PHP database framework to accelerate the development.

The lightweight PHP database framework to accelerate development. Lightweight - Portable with only one file. Easy - Easy to learn and use, friendly construction. Powerful - Supports various common and complex SQL queries, data mapping and prevents SQL injection. Compatible - Supports MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle, and more. Friendly - Works well with every PHP framework, like Laravel, Codeigniter, Yii, Slim, and framework that are supporting singleton extension or composer. Free - Under the MIT license, you can use it anywhere, whatever you want. 

Write database migrations using database agnostic PHP code. Migrate up and down. Migrate on deployment. Seed data after database creation. Get going in less than 5 minutes. Stop worrying about the state of your database. Take advantage of SCM features such as branching. Integrate with any app. 

Laravel 5 - Repositories to abstract the database layer

The Config component helps you find, load, combine, autofill and validate configuration values of any kind, whatever their source may be (YAML, XML, INI files, or for instance a database).

The Config component helps find, load, combine, autofill and validate configuration values of any kind, whatever their source may be (YAML, XML, INI files, or for instance a database). 

This script was made to aid the process of migrating PHP and MySQL based websites. Works with most common CMSes.

This script was made to aid the process of migrating PHP and MySQL based websites. Works with most common CMSes. If you find a problem let us know in the issues area and if you can improve the code then please fork the repository and send us a pull request :). 

Laravel Migrations Generator: Automatically generate your migrations from an existing database schema.

Generate Laravel Migrations from an existing database, including indexes and foreign keys!. 

Easily build Eloquent queries from API requests

Single file PHP script that adds a REST API to a SQL database

Single file PHP script that adds a REST API to a SQL databaseComposer install or single PHP file, easy to deploy. Very little code, easy to adapt and maintain Supports POST variables as input (x-www-form-urlencoded) Supports a JSON object as input Supports a JSON array as input (batch insert) Sanitize and validate input using type rules and callbacks Permission system for databases, tables, columns and records Multi-tenant single and multi database layouts are supported Multi-domain CORS support for cross-domain requests Support for reading joined results from multiple tables Search support on multiple criteria Pagination, sorting, top N list and column selection Relation detection with nested results (belongsTo, hasMany and HABTM) Atomic increment support via PATCH (for counters) Binary fields supported with base64 encoding Spatial/GIS fields and filters supported with WKT and GeoJSON Generate API documentation using OpenAPI tools Authentication via API key, JWT token or username/password Database connection parameters may depend on authentication Support for reading database structure in JSON Support for modifying database structure using REST endpoint Security enhancing middleware is included Standard compliant: PSR-4, PSR-7, PSR-12, PSR-15 and PSR-17 

Wrapper for a PHP MySQL class, which utilizes MySQLi and prepared statements. 

MysqliDb -- Simple MySQLi wrapper and object mapper with prepared statements. 

Simple web interface to manage Redis databases.

A powerful yet easy-to-use PHP micro-framework designed to help you build dynamic and robust Web applications - fast!

Our first example wasn't too hard to swallow, was it? If you like a little more flavor in your Fat-Free soup, insert another route before the $f3-&gt;run() command:-. You don't want to clutter the global namespace with function names? Fat-Free recognizes different ways of mapping route handlers to OOP classes and methods:-. HTTP requests can also be routed to static class methods:-. 

A high-performance backend cache system.  It is intended for use in speeding up dynamic web applications by alleviating database load.  Well implemented, it can drops the database load to almost nothing, yielding faster page load times for users, better resource utilization.  It is simple yet powerful. 

As the V9 is relatively not compatible with previous versions, please read carefully the migration guide to ensure you the smoothest migration possible. One of the biggest change is the configuration system which is now an object that replace the primitive array that we used to implement back then. Also, please note that the V9 requires at least PHP 8 or higher to works properly. 

A lightweight nearly-zero-configuration object-relational mapper and fluent query builder for PHP5.

A lightweight nearly-zero-configuration object-relational mapper and fluent query builder for PHP5.Makes simple queries and simple CRUD operations completely painless. Gets out of the way when more complex SQL is required. Built on top of PDO. Uses prepared statements throughout to protect against SQL injection attacks. Requires no model classes, no XML configuration and no code generation: works out of the box, given only a connection string. Consists of one main class called ORM. Additional classes are prefixed with Idiorm. Minimal global namespace pollution. Database agnostic. Currently supports SQLite, MySQL, Firebird and PostgreSQL. May support others, please give it a try! Supports collections of models with method chaining to filter or apply actions to multiple results at once. Multiple connections supported PSR-1 compliant methods (any method can be called in camelCase instead of underscores eg. find_many() becomes findMany()) - you'll need PHP 5.3+ 

PHP version of mysqldump cli that comes with MySQL

Requirements | Installing | Getting started | API | Settings | PDO Settings | TODO | License | Credits. This is a php version of mysqldump cli that comes with MySQL, without dependencies, output compression and sane defaults. Out of the box, MySQLDump-PHP supports backing up table structures, the data itself, views, triggers and events. output binary blobs as hex. resolves view dependencies (using Stand-In tables). output compared against original mysqldump. Linked to travis-ci testing system (testing from php 5.3 to 7.3 &amp; hhvm) dumps stored routines (functions and procedures). dumps events. does extended-insert and/or complete-insert. supports virtual columns from MySQL 5.7. does insert-ignore, like a REPLACE but ignoring errors if a duplicate key exists. modifying data from database on-the-fly when dumping, using hooks. can save directly to google cloud storage over a compressed stream wrapper (GZIPSTREAM). 

Cycle is PHP DataMapper, ORM and Data Modelling engine designed to safely work in classic and daemonized PHP applications (like RoadRunner). The ORM provides flexible configuration options to model datasets, powerful query builder and supports dynamic mapping schema. The engine can work with plain PHP objects, support annotation declarations, and proxies via extensions. Website and Documentation | Comparison with Eloquent and Doctrine. ORM with has-one, has-many, many-through-many and polymorphic relations Plain Old PHP objects, AR, Custom objects or same entity type for multiple repositories eager and lazy loading, query builder with multiple fetch strategies embedded entities, lazy/eager loaded embedded partials runtime configuration with/without code-generation column-to-field mapping, single table inheritance, value objects support hackable: persist strategies, mappers, relations, transactions works with directed graphs and cyclic graphs using command chains designed to work in long-running applications: immutable service core, disposable UoW supports MySQL, MariaDB, PostgresSQL, SQLServer, SQLite schema scaffolding, introspection, migrations and debugging supports global query scopes, UUIDs as PK, soft deletes, auto timestamps and macros custom column types, FKs to non-primary columns use with or without annotations, proxy classes, and auto-migrations compatible with Doctrine Collections, Illuminate Collections and custom collections compatible with Doctrine Annotations, PHP8 attributes 

NotORM - PHP library for simple reading data from the database

PHP class to make interacting with a database ridiculusly easy

This is Version 5 which will break users of version 4. Version 4 has many modern programming practices in which will break users of version 3. Version 3 broke version 2.1.7 in one major way, it required PHP 5.6. Which drop mysql extension support, other than that, nothing as far using the library was changed, only additional features. This library has an Database class, an combination of the Factory pattern with an Dependency Injection container hosting. This library now is following many OOP principles, one in which, the methods properties public access has been removed. This library also following PSR-2, PSR-4, PSR-11 conventions, and mostly PSR-1, that's still an work in progress. For an full overview see documentation Wiki, which is not completely finish. The use of namespace in the global functions ezFunctions.php file. Usage of the global functions will require the user to begin a .php file something like: use function ezsql\functions\where;
// Or
use function ezsql\functions\{
    getInstance,
    selecting,
    inserting,
}; Class properties that was accessible by magic methods get/set, now PSR 1 camelCase. Renamed select of ez_mysqli to dbSelect. Renamed class method and behavior of selecting to select. selecting, and new inserting methods, can be called without table name, only the other necessary parameters:  The table name with prefix, can be preset/stored with methods tableSetup(name, prefix), or setTable(name), setPrefix(append), if called without presetting, false is returned. This feature will be added to all database CRUD access methods , each method name will have an ing ending added. Removed global functions where table name passed in, use functions using preset table names ending with ing. renamed cleanInput to clean_string renamed createCertificate to create_certificate added global get_results to return result sets in different formats More Todo... 