Lightweight
20KB around with only one file.
Easy
Extremely easy to learn and use, friendly construction.
Powerful
Support various common and complex SQL queries.
Compatible
Support various SQL database, including MySQL, MSSQL, SQLite, MariaDB, Oracle, Sybase, PostgreSQL and more.
Security
Prevent SQL injection.
Free
Under MIT license, you can use it anywhere if you want.
Composer require
$ composer require catfan/Medoo
Update
$ composer update
Get Started
- // If you installed via composer, just use this code to requrie autoloader on the top of your projects.
- require 'vendor/autoload.php';
-
- // Or if you just download the medoo.php into directory, and require it with the correct path.
- require_once 'medoo.php';
-
- // Initialize
- $database = new medoo([
- 'database_type' => 'mysql',
- 'database_name' => 'name',
- 'server' => 'localhost',
- 'username' => 'your_username',
- 'password' => 'your_password',
- 'charset' => 'utf8'
- ]);
-
- // Enjoy
- $database->insert('account', [
- 'user_name' => 'foo',
- 'email' => 'foo@bar.com',
- 'age' => 25,
- 'lang' => ['en', 'fr', 'jp', 'cn']
- ]);
Go to main page