CRUD Interface

Describes CRUD interface.

table

Return an instance with crud table.

$sql = $sql->table($table_name);

select

Retrieve result for select query command.

$records = $sql->select($field, $filter = array(), $group = array(), $order = array(), $limit = 0, $offset = 0, $sensitive_case = false);

record

Retrieve single row record for select query command.

$record = $sql->record($field, $filter = array(), $group = array(), $order = array(), $offset = 0, $sensitive_case = false);

insert

Return an instance with insert new record.

$sql = $sql->insert($data);

update

Return an instance with updated record.

$sql = $sql->update($data, $filter = array(), $limit = 0, $sensitive_case = false);

delete

Return an instance with deleted record.

$sql = $sql->delete($filter = array(), $limit = 0, $sensitive_case = false);

count

Count existing record.

$record_count = $sql->count($filter = array(), $sensitive_case = false);