The Lightweight PHP Database Framework to Accelerate Development

Version: 1.7.10
download Fork me on GitHub
Total Downloads Latest Stable Version License Backers on Open Collective Sponsors on Open Collective

Less than 100 KB, portable with only one file


Extremely easy to learn and use, friendly construction


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


Supports all SQL databases, including MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle and more


Works well with every PHP frameworks, like Laravel, Codeigniter, Yii, Slim, and framework which supports singleton extension or composer


Under MIT license, you can use it anywhere whatever you want

Love Medoo?

Get Started

Composer require

$ composer require catfan/medoo


$ composer update
// If you installed via composer, just use this code to require 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' => ''

$data = $database->select('account', [
], [
    'user_id' => 50

echo json_encode($data);

// [
//     {
//         "user_name" : "foo",
//         "email" : ""
//     }
// ]


Mask Forex In Thai
Medoo is an open-source project under MIT license and will always be free to use. However, the project needs some funding every month to sustain. Any sponsorship for the project will be greatly helpful for us to build Medoo better toward all PHP developers in the world, and we will put your company logo on homepage and about page as appreciation.