What is the best way to check if an Eloquent query returns no answer?

Question

I'm using Laravel 4. Say I have an Eloquent model (Patient) and I want to get a patient with the name Bob, I would do this:

$patient = Patient::where('name', '=', 'Bob'); 

What is the best way to check to see if $patient is a valid record?

Answer 1

If the database query does not find any matching results, it returns null. Therefore...

$patient = Patient::where('name','=','Bob')->first();  if ( is_null($patient) ) {   App::abort(404); } 

(Note: in your original question you forgot ->first() (or ->get()) in your query. Don't forget that or else you will get an Eloquent object instead of a result.)

Answer 2

use this:

$patient = Patient::where('name', '=', 'Bob')->firstOrFail(); 

it will return Eulqouent model on success or throw ModelNotFoundException upon failure.