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' => '[email protected]'
]);
// Retrieve data.
$data = $database->select('account', [
'user_name',
'email'
], [
'user_id' => 50
]);
echo json_encode($data);
// [{
// "user_name" : "foo",
// "email" : "[email protected]",
// }]
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.
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.
Links
[More Products We Build]
Gear Browser - AI Extension Web Browser

评论