BaseModel::all
Usage
ModelIterator BaseModel::all([ string $sort_by = 'id' ], [ string $sort_dir = 'asc' ], [ int $limit = '0' ], [ int $offset = '0' ])Description
Get all records from the database table assigned to the model class.Parameters
Parameter | Required | Type | Description |
---|---|---|---|
$sort_by | No | string | The column name to sort by. Defaults to the primary key column of the table. |
$sort_dir | No | string | The direction to sort by. Can be either `asc` or `desc`, and defaults to `asc`. |
$limit | No | int | The total number of records to return. Defaults to no limit, and returns all records. |
$offset | No | int | The offset at which to begin returning records. Defaults to 0. |
Return Value
Returns a `ModelIterator` instance of all models / records that are returned.Examples
Get All Categories Sorted by Name
use App\Demo\Models\Category; // Get all categories sorted by name $cats = Category::all('name'); foreach ($cats as $cat) { print_r($cat->toArray()); }
Get Products Sorted by Price Records 10 - 25
use App\Demo\Models\Product; // Get products 10 - 25 sorted by most expensive $products = Product::all('price', 'desc', 15, 10); foreach ($products as $product) { print_r($product->toArray()); }