The Lightweight PHP Database Framework to Accelerate Development

Composer require

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"
// }]

Sponsors

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.