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.