PHP Database Framework to Accelerate Development – Medoo
Medoo is the lightest PHP database framework which definitely accelerate the development by 10x. It’s built up with php and contains only one file of 8kb (kilo bytes) works perfectly with SQL databases.
We call it single-file PHP database Framework just because it contains only one file and compatible with MySQL, PostgreSQL, MSSQL, SQLite (and more databases).
It’s extremely easy to learn and use, friendly construction, supports numerous SQL queries, prevent the SQL injection for more security, and yet its under MIT license, you can use it anywhere if you want.
How to Work with Medoo?
It’s quite easy to install Medoo on your server and get started with it, if you want to know about how? Follow the steps below:
- Download Medoo and put it into any directory you want
- As you may only find one file medoo.php where you have to configure the username and password (Don’t know how to create a username and password?)
/* medoo.php */
class medoo {
protected $database_type = 'mysql';
protected $server = 'localhost';
protected $username = 'your_username';
protected $password = 'your_password';
Now how to use it on your projects… As it’s really easy to use as taking a cup of tea. You can use it on your projects with only 3 step.
// Include Medoo
require_once 'medoo.php';
// Initialize
$database = new medoo('my_database');
// Enjoy
$database->insert('account', [
'user_name' => 'foo'
'email' => '[email protected]',
'age' => 25,
'lang' => ['en', 'fr', 'jp', 'cn']
]);