catfan/Medoo

PHPmedoo.in

전체 #12,725 PHP #267 Databases #371

The lightweight PHP database framework to accelerate the development.

phpphp-frameworkdatabasemedoocomposerphp-database-frameworkphp-frameworksmysqlsqlitemssqlpostgresqlsql

주요 지표

스타 성장

스타

포크

1.1k

주간 성장

이슈

2k4k

2023년 1월2023년 8월2024년 3월2024년 11월2025년 6월2026년 1월2026년 9월

아티팩트Packagist

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.