Error handling on a query not working in controller laravel

Question

I am trying to simple error handling whereby if a query doesn't return anything I want to redirect the user to a 404 page, but for now I just echoing a message to see if it triggers, here is my code

public function show($user_id, $username) {

    $user = User::where('id', $user_id)->where('name', $username)->get();

    if (count($user = 0)) {
        echo "REEEEEEE";
    }
    else 
    {
        $user->load('comments.users', 'posts.users');

        return $user;
    }
    //return view ('users.show', compact('user'));

}

This only echos the message and doesn't load the relationships or return the user if the query returns something, am I doing something wrong?

Marco Santarossa · Accepted Answer · 2016-09-05 20:08:25Z

1

Change your code like this:

$userCount = User::where('id', $user_id)->where('name', $username)->count();

if ($userCount == 0)

In your code you have a wrong if statement:

if (count($user = 0)) becomes if (count(0))

edited Sep 5, 2016 at 20:08

answered Sep 5, 2016 at 19:56

Marco Santarossa

4,0662 gold badges31 silver badges50 bronze badges

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

2 Comments

user6073700 Over a year ago

It works nice one boss, any idea why my code doesn't work? Incorrect syntax?

Marco Santarossa Over a year ago

@user6073700 you mistyped, count($user = 0) is not a correct statement. You assign user to 0 and then if (count(0)). If it helped mark my answer as right, thanks

Collectives™ on Stack Overflow

Error handling on a query not working in controller laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related