Database Reference
- Database Reference
- Database Query Reference
- Database Configuration
- Getting a Database Instance
- raw($query, $args = array())
- count()
- bulk_insert($records)
- bulk_update($records, $primaryKey = ‘id’)
- delete()
- update($fields = [])
- insert($fields = [])
- last_id()
- table($table_name)
- select($columns)
- select_max($column, $alias = NULL)
- select_min($column, $alias = NULL)
- select_sum($column, $alias = NULL)
- select_count($column = ‘*’, $alias = ‘total’)
- select_avg($column, $alias = NULL)
- select_distinct($columns)
- join($table, $condition, $type = ‘INNER’)
- inner_join($table, $condition)
- left_join($table, $condition)
- right_join($table, $condition)
- full_outer_join($table, $condition)
- where($where, $op = NULL, $val = NULL, $type = ‘’, $andOr = ‘AND’)
- or_where($where, $op = NULL, $val = NULL)
- not_where($where, $op = NULL, $val = NULL)
- or_not_where($where, $op = NULL, $val = NULL)
- like($field, $data, $type = ‘’, $andOr = ‘AND’)
- or_like($field, $data)
- not_like($field, $data)
- or_not_like($field, $data)
- in($field, array $keys, $type = ‘’, $andOr = ‘AND’)
- not_in($field, array $keys)
- or_in($field, array $keys)
- or_not_in($field, array $keys)
- between($field, $value1, $value2, $type = ‘’, $andOr = ‘AND’)
- not_between($field, $value1, $value2)
- or_between($field, $value1, $value2)
- or_not_between($field, $value1, $value2)
- pagination($perPage, $currentPage = 1)
- limit($number)
- offset($number)
- order_by($column, $direction = ‘ASC’)
- group_by($column)
- having($column, $value, $operator = ‘=’)
- grouped(Closure $obj)
- grouped(Closure $obj)
- get()
- get_all()
- transaction()
- rollback()
- Best Practices