libraty sweeter-fetch

qdladoooo/sweeter-fetch

Sweeter-fetch, a wrapper of PDO. Procedure oriented, pre process, as supplement of ORM.

Sweeter-fetch - a database fetching library

Wrapper for PDO., _(*1)

Procedure oriented, Pre process, As supplement of ORM., _(*2)

, _(*3)

Installation

composer require qdladoooo/sweeter-fetch

Initialization

require "../vendor/autoload.php";
use SweeterFetch\SweeterFetch;

$sf = new SweeterFetch('host', 'username', 'password');

Use

Execute none query, _(*4)

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

Execute query, _(*5)

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

Execute one row, _(*6)

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

Execute column, _(*7)

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

Execute scalar, _(*8)

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

License

The Sweeter-fetch is open-sourced software licensed under the MIT license., _(*9)