laravel-sweeter-fetch - fetch for Laravel

Wrapper of PDO.

Procedure oriented, Pre process, As supplement of ORM.

Installation

composer require qdladoooo/laravel-sweeter-fetch

Initialization

use SweeterFetch\LaravelSF;

//take db_connection as parameter 
$sf = new LaravelSF();

Use

Execute none query

//return nothing
$sf->Enq('use candy_shop;');

Execute query

//return [row1, row2, ...]
$sf->Eq($sql);

Execute one row

//return the first row by array
$sf->Eor($sql);

Execute column

//return a column
$sf->Ec($sql);

Execute scalar

//return a number
$sf->Es($sql);

License

The laravel-sweeter-fetch is open-sourced software licensed under the MIT license.