\Anax\DatabaseActiveRecordModel

setDb()

setDb(\Anax\Database\DatabaseQueryBuilder  $db) : void

Set the database object to use for accessing storage.

Parameters

find()

find(string  $column, mixed  $value) : \Anax\Database\this

Find and return first object found by search criteria and use its data to populate this instance.

Parameters

Returns

findById()

findById(integer  $id = null) : \Anax\Database\this

Find and return first object by its tableIdColumn and use its data to populate this instance.

Parameters

Returns

findWhere()

findWhere(string  $where, mixed  $value) : \Anax\Database\this

Find and return first object found by search criteria and use its data to populate this instance.

The search criteria $where of can be set up like this: id = ? id1 = ? and id2 = ?

The $value can be a single value or an array of values.

Parameters

Returns

findAll()

findAll() : array

Find and return all.

Returns

of object of this class

findAllWhere()

findAllWhere(string  $where, mixed  $value) : array

Find and return all matching the search criteria.

The search criteria $where of can be set up like this: id = ? id IN [?, ?]

The $value can be a single value or an array of values.

Parameters

Returns

of object of this class

save()

save() : void

Save current object/row, insert if id is missing and do an update if the id exists.

saveWhere()

saveWhere(string  $where, mixed  $value) : void

Save/update current object/row using a custom where-statement.

The criteria $where of can be set up like this: id = ? id1 = ? AND id2 = ?

The $value can be a single value or an array of values.

Parameters

delete()

delete(integer  $id = null) : void

Update row using $tableIdColumn as where and clear value of `$tableIdColumn`.

Parameters

deleteWhere()

deleteWhere(string  $where, mixed  $value) : void

Delete row using a custom where-statement and leave value of `$tableIdColumn` as it is.

The criteria $where of can be set up like this: id = ? id1 = ? AND id2 = ? id IN (?, ?)

The $value can be a single value or an array of values.

Parameters

checkDb()

checkDb() : void

Check if database is injected or throw an exception.

Throws

\Anax\Database\Exception\ActiveRecordException

when database is not set.

getProperties()

getProperties() : array

Get essential object properties.

Returns

with object properties.

create()

create() : void

Create new row.

update()

update() : void

Update row using $tableIdColumn as where.

updateWhere()

updateWhere(string  $where, mixed  $value) : void

Update row using a custom where-statement.

The criteria $where of can be set up like this: id = ? id1 = ? AND id2 = ? id IN (?, ?)

The $value can be a single value or an array of values.

Parameters