Laravel - find by custom column or fail

laravel laravel-4 eloquent laravel-5
Limon Monte picture Limon Monte · Mar 23, 2015 · Viewed 87.3k times · Source

There's findOrFail() method which throws 404 if nothing was found, e.g.:

User::findOrFail(1);

How can I find an entity by custom column or fail, something like this: 

Page::findBySlugOrFail('about');

Answer

Alupotha picture Alupotha · Mar 23, 2015

Try it like this:

Page::where('slug', '=', 'about')->firstOrFail();

Related questions

Laravel Check If Related Model Exists

I have an Eloquent model which has a related model: public function option() { return $this->hasOne('RepairOption', 'repair_item_id'); } public function setOptionArrayAttribute($values) { $this->option->update($values); } When I create the model, it does not necessarily …

Read More
Laravel 4: how to "order by" using Eloquent ORM

Simple question - how do I order by 'id' descending in Laravel 4. The relevant part of my controller looks like this: $posts = $this->post->all() As I understand you use this line: ->orderBy('id', 'DESC'); But …

Read More
Eloquent Collection: Counting and Detect Empty

This may be a trivial question but I am wondering if Laravel recommends a certain way to check whether an Eloquent collection returned from $result = Model::where(...)->get() is empty, as well as counting the number of elements. …

Read More