laravel how to handle empty json results set from a query

Question

I am very new to the laravel framework and i have what it seems to be a simple question. I have a query like so

 $query['query2']= DB::connection('test')->select(
"select * from cities");
 ...
 ...
 echo json_encode($q);

Sometimes this particular query returns an empty result set. How do I handle this? Lets say I want to add my own json response when its empty. Thanks

JSelser · Accepted Answer · 2015-06-01 22:49:43Z

2

Try the following

 $dataToSend = $q->get(); // $q being your query

 if($dataToSend->isEmpty())
 {
   echo json_encode(['something'=>'else']);
 }
 else
 {
   echo json_encode($dataToSend);
 }

Or in a shorter fashion

 $dataToSend = $q->get(); // $q being your query

 echo json_encode($dataToSend->isEmpty()? ['something'=>'else'] : $dataToSend);

edited Jun 1, 2015 at 22:49

answered Jun 1, 2015 at 19:42

JSelser

3,6501 gold badge22 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel how to handle empty json results set from a query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related