NinjaDB

The query below returns the row where id = 3, null if no rows. $row = ninjaDB ->find.
Full Queries $query = ninjaDB ->where for equal you can just use where Get result as array of objects $query->get.
The query below returns the all rows as array of objects where author id = 3, null if no rows. $result = ninjaDB ->findAll.
Get Rows Count, MAX, MIN, AVerage, SUM $query = ninjaDB ->where $count = $query->count $max = $query->max Where `views` is the column name and all these will return integer float $min = $query->min $avg = $query->avg $avg = $query->avg $sum = $query->sum.
ninjaDB ->where ->whereNot -> orWhere whereIn.
ninjaDB ->whereIn ) ->get.
Insert $data = $insertId = ninjaDB ->insert insert method returns the insert id optionally you can pass $format of your data as `->insert ` where `$format` is array of formats to be mapped to each of the in $data.
Batch Insert $data = array, array, ) $insertIds = ninjaDB ->batch insert.
Update $data = ninjaDB ->where ->update.
Read more