repat / laravel-medoo by repat
forked from catfan/Medoo

Laravel Facade and ServiceProvider for The Lightest PHP database framework to accelerate development
246
5
3
database sql mysql sqlite lightweight mssql laravel php framework lumen postgresql oracle mariadb
Github Link
Packagist Link
Package Data
Maintainer Username: repat
Maintainer Contact: angel@catfan.me (Angel Lai)
Package Create Date: 2015-12-14
Package Last Update: 2019-03-26
Home Page: http://medoo.in
Language: PHP
License: MIT
Last Refreshed: 2024-12-11 15:07:18
Package Statistics
Total Downloads: 246
Monthly Downloads: 1
Daily Downloads: 0
Total Stars: 5
Total Watchers: 3
Total Forks: 1
Total Open Issues: 0

laravel-medoo

This package provides a Facade and ServiceProvider for the database framework medoo. It might be useful in Lumen or when you already have existing code that's based on medoo and you would like to port it to Laravel/Lumen instead of rewriting the whole code to use the Query Builder or Eloquent.

It uses the default connection.

Installation

  1. Install the package

composer require repat/laravel-medoo

  1. Add the Service Provider to the providers array in app/config/app.php 
repat\LaravelMedoo\MedooServiceProvider::class,
  1. Add alias in app/config/app.php 
'Medoo' => repat\LaravelMedoo\MedooFacade::class,

Usage

Medoo::select("table", "*");

See official medoo documentation for more.

The Lightest PHP database framework to accelerate development

Features

  • Lightweight - Less than 100 KB, portable with only one file

  • Easy - Extremely easy to learn and use, friendly construction

  • Powerful - Supports various common and complex SQL queries, data mapping, and prevent SQL injection

  • Compatible - Supports all SQL databases, including MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle and more

  • Friendly - Works well with every PHP frameworks, like Laravel, Codeigniter, Yii, Slim, and framework which supports singleton extension or composer

  • Free - Under MIT license, you can use it anywhere whatever you want

Requirement

PHP 5.4+ and PDO extension installed

Get Started

Install via composer

Add Medoo to composer.json configuration file.

$ composer require catfan/Medoo

And update the composer

$ composer update

// If you installed via composer, just use this code to require autoloader on the top of your projects.
require 'vendor/autoload.php';

// Using Medoo namespace
use Medoo\Medoo;

// Initialize
$database = new Medoo([
    'database_type' => 'mysql',
    'database_name' => 'name',
    'server' => 'localhost',
    'username' => 'your_username',
    'password' => 'your_password'
]);

// Enjoy
$database->insert('account', [
    'user_name' => 'foo',
    'email' => 'foo@bar.com'
]);

$data = $database->select('account', [
    'user_name',
    'email'
], [
    'user_id' => 50
]);

echo json_encode($data);

// [
//     {
//         "user_name" : "foo",
//         "email" : "foo@bar.com",
//     }
// ]

Contribution Guides

For most of time, Medoo is using develop branch for adding feature and fixing bug, and the branch will be merged into master branch while releasing a public version. For contribution, submit your code to the develop branch, and start a pull request into it.

On develop branch, each commits are started with [fix], [feature] or [update] tag to indicate the change.

Keep it simple and keep it clear.

License

Medoo is under the MIT license.

Links