Input returns empty query in error

Question

I have a movies website that I want to allow people to search by genre

movies.com/people/action/genre

The Route

Route::get('people/{genre}/genre', array('uses' => 'ActorController@genre', 'as' => 'people.genre'));

The ActorController@genre

public function genre()
{

    $genre=Input::get('genre');
        $actors = $this->actor->allgenre($genre);
            return View::make('Actor.All')->withActors($actors);

}

This grabs all the actors from the db

function allGenre($genre)
{

        return $this->actor->where('genre', 'like', '$genre')->orderBy('views', 'desc')->paginate(24);

}

This is returning no results, when it should be returning results because if I go

function allGenre($genre)
{

        return $this->actor->where('genre', 'like', 'action')->orderBy('views', 'desc')->paginate(24);

}

Results show up

Why you tag it as symfony2 ?

Pawel
– Pawel

2014-02-07 08:48:25 +00:00
Commented Feb 7, 2014 at 8:48 — Pawel
– Pawel, Commented Feb 7, 2014 at 8:48
Sorry cause im using the symfony2 package.

Stephenmelb
– Stephenmelb

2014-02-07 08:54:29 +00:00
Commented Feb 7, 2014 at 8:54 — Stephenmelb
– Stephenmelb, Commented Feb 7, 2014 at 8:54

Community · Accepted Answer · 2017-05-23 10:25:57Z

1

When you use that routing, the $genre variable would be bound the the controller:

public function genre($genre)
{
  $actors = $this->actor->allgenre($genre);
  return View::make('Actor.All')->withActors($actors);
}

While in your previous question you used query strings, so you needed Input::get('key'), now you changed the url, and you don't use resource controllers anymore, so you must go back to the "usual" way

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Feb 7, 2014 at 9:10

Damien Pirsy

25.5k8 gold badges72 silver badges77 bronze badges

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

1 Comment

Stephenmelb Over a year ago

Hi Damien Thanks for sharing , but it is still not returning results when I go movies.com/people/action/genre. How do I check if the $genre variable is getting passed to the allgenre function?

Stephenmelb · Accepted Answer · 2014-02-07 09:22:14Z

0

I got it to work

function allGenre($genre)
{

    return $this->actor->where('genre', 'like', $genre)->orderBy('views', 'desc')->paginate(24);

}

Apparently Laravel doesn't accept '$genre' with the ' around the variable

answered Feb 7, 2014 at 9:22

Stephenmelb

4571 gold badge3 silver badges23 bronze badges

Collectives™ on Stack Overflow

Input returns empty query in error

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related