catfan/Medoo

PHPmedoo.in

The lightweight PHP database framework to accelerate the development.

phpphp-frameworkdatabasemedoocomposerphp-database-frameworkphp-frameworksmysqlsqlitemssqlpostgresqlsql

主要指標

スター成長

スター

4.9k

フォーク

1.1k

週間成長

—

Issue

2k4k

2023年1月2023年8月2024年3月2024年10月2025年5月2025年12月2026年7月

成果物Packagistcomposer require catfan/medoo

README

The lightweight PHP database framework to accelerate development.

Documentation

Features

Lightweight - A lightweight single-file package that keeps dependencies to a minimum.
Easy - A clean, intuitive API that helps you get started quickly.
Powerful - Designed for complex SQL, data mapping, and prepared statements without sacrificing readability.
Compatible - Works smoothly with MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle, Sybase, and more.
Friendly - Fits naturally into Laravel, CodeIgniter, Yii, Slim, and other PHP frameworks.
Free - Released under the MIT license and free to use in personal or commercial projects.

Requirements

PHP 7.3 or later
PDO extension enabled

Get Started

Install via composer

Add Medoo to the composer.json configuration file.

$ composer require catfan/medoo

Then update Composer

$ composer update

// Load Composer's autoloader.
require 'vendor/autoload.php';

// Import the Medoo namespace.
use Medoo\Medoo;

// Create a database connection.
$database = new Medoo([
    'type' => 'mysql',
    'host' => 'localhost',
    'database' => 'name',
    'username' => 'your_username',
    'password' => 'your_password'
]);

// Insert data.
$database->insert('account', [
    'user_name' => 'foo',
    'email' => 'foo@bar.com'
]);

// Retrieve data.
$data = $database->select('account', [
    'user_name',
    'email'
], [
    'user_id' => 50
]);

echo json_encode($data);

// [{
//    "user_name" : "foo",
//    "email" : "foo@bar.com",
// }]

Contribution Guidelines

Before submitting a pull request, ensure compatibility with multiple database engines and include unit tests when possible.

Testing & Code Style

Run phpunit tests to execute unit tests.
Use php-cs-fixer fix to enforce code style consistency.

Commit Message Format

Each commit should begin with a tag indicating the type of change:

[fix] for bug fixes
[feature] for new features
[update] for improvements

Keep contributions simple and well-documented.

License

Medoo is released under the MIT License.