Commands

Method	Purpose
`insert()`	Insert a record
`update()`	Update a record
`remove()`	Delete a record
`select()`	Select all records, or specific columns, with optional where, limit, offset and order by
`run()`	Run a custom query
`json()`	Return a result as JSON
`last()`	Get the last inserted item
`count()`	Count rows
`sum()`	Sum a column

Insert a record

php

$sde->insert('users', 'name, email, password', ':name, :email, :password', [
    'name'      =>  'John Doe',
    'email'     =>  '[email protected]',
    'password'  =>  '123456',
    'salary'    =>  '10000'
]);

Update a record

php

$sde->update('users', 'email = :email', 'id = :id', [
    'email' =>  '[email protected]',
    'id'    =>  1
]);

Delete a record

php

$sde->remove('users', 'id = :id', [
    'id' => 1
]);

Select records

php

$sde->select('*', 'users');
$sde->select('id, name, email', 'users');
$sde->select('id, name, email', 'users', 'id = :id', false, false, [
    'id' => 1
]);
$sde->select('id, name, email', 'users', 'id = :id', 10, false, [
    'id' => 1
]);
$sde->select('id, name, email', 'users', 'id = :id', '10, 0', 'id DESC', [
    'id' => 1
]);
$sde->select('id, name, email', 'users', 'id = :id', '10', 'id DESC', '15', [
    'id' => 1
]);

Run a custom query

php

$sde->run('SELECT * FROM users WHERE id = 1');

Get JSON output

php

$sde->json($result);

Get the last inserted item

php

$sde->last();

Count rows

php

$sde->count('users', 'id = :id', [
    'id' => 1
]);

Sum a column

php

$sde->sum('users', 'salary', 'id = :id', [
    'id' => 1
]);