Version: 2.2.0
Lightweight
Single-file framework with minimal dependencies.
Easy
Simple and intuitive API for quick integration.
Powerful
Supports complex SQL queries, data mapping, and SQL injection prevention.
Compatible
Works with MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle, Sybase, and more.
Friendly
Integrates seamlessly with Laravel, CodeIgniter, Yii, Slim, and other PHP frameworks.
Free
Licensed under MIT, free to use for any purpose.
Composer require
$ composer require catfan/medoo
Update
$ composer update
// Require Composer's autoloader
require 'vendor/autoload.php';
// Import Medoo namespace
use Medoo\Medoo;
// Initialize 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"
// }]
Medoo is an open-source project licensed under MIT and will always remain free to use. However, ongoing development requires monthly funding to sustain the project. Your sponsorship helps us improve Medoo for PHP developers worldwide, and as a token of appreciation, we will feature your company logo on our homepage.
