Building function call through a loop

Question

I'm trying to build search functionality for a reality website. I want to be able to search by multiple parameters at a time, similar to what you would see on almost any retail website. I'm using Laravel on my project and I want to be able to make use of the Query Builder so I can use it's built in pagination.

If I try something like:

$listing = DB::select('select * from listings where city = 'Chicago');

I can't paginate the results.

The other approach would be to do this:

$listing = DB::table('listings')->where('city', 'Chicago')->get();

But the problem is that I don't know how many parameters a user might enter into the search. So how would I build a function call that could look like:

$listing = DB::table('listings')->where('city', 'Chicago')->where('askingPrice', '>', 50000)->where('bedrooms', '>', 3)->get();

TheFrost · Accepted Answer · 2013-07-29 02:11:22Z

1

Let's say you have this parameters:

<?php
$parameters = array(
    'one' => 'a',
    'two' => 'b',
    'three' => 'c'
);

Create object:

<?php
$listing = DB::table('listings');

And then, loop:

<?php
foreach ($parameters as $key => $value) {
    $listing = $listing->where($key, $value);
}

Of course you have to improve it to handle > and others. But I think you get it, right?

At last:

<?php
$listing = $listing->get();

answered Jul 29, 2013 at 2:11

TheFrost

1,2852 gold badges15 silver badges30 bronze badges

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

4 Comments

vikingsfan19 Over a year ago

Does this query the database multiple times or only when you use get()?

TheFrost Over a year ago

Only when get() is used. where() returns \Illuminate\Database\Query\Builder not executing query.

vikingsfan19 Over a year ago

When I do this I can't paginate. I thought I would be able to substitute $listing->get(); with $listing->paginate(20);

vikingsfan19 Over a year ago

Not sure what I had done before but I am getting my pagination links now.

Collectives™ on Stack Overflow

Building function call through a loop

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related