The Lightest PHP Database Framework to Accelerate Development

Version: 1.4.3
download Fork me on GitHub
Lightweight

32KB around with only one file.

Easy

Extremely easy to learn and use, friendly construction.

Powerful

Supports various common and complex SQL queries, data mapping, and prevent SQL injection.

Compatible

Supports various SQL database, including MySQL, MSSQL, SQLite, MariaDB, Oracle, Sybase, PostgreSQL and more.

Friendly

Work well with every PHP frameworks, like Laravel, Codeigniter, Yii, Slim, and framework which supports singleton extension.

Free

Under MIT license, you can use it anywhere if you want.

Love Medoo?

Get Started

Composer require

$ composer require catfan/Medoo

Update

$ composer update
// If you installed via composer, just use this code to requrie autoloader on the top of your projects.
require 'vendor/autoload.php';

// Using Medoo namespace
use Medoo\Medoo;

// Initialize
$database = new Medoo([
    'database_type' => 'mysql',
    'database_name' => 'name',
    'server' => 'localhost',
    'username' => 'your_username',
    'password' => 'your_password'
]);

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

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

echo json_encode($data);

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