Custom query for database in Laravel

Question

First of all I'm wondering if this is even possible in Laravel?

I have this code:

$master_array = $_POST['master_search_array'];

$count = count($master_array);
$master_string = '';

for($i=0; $i<$count; $i++) {
    if($master_array[$i] == "Dining"){
        $master_string .= "where('dining', 'dining')";
    }
    if($master_array[$i] == "Party"){
        $master_string .= "where('party','party')";
    }
    ....ETC you get the point
}

$tours = DB::table('tours')->$master_string->get();

return $tours;

So at the end I should get something like this:

$tours = DB::table('tours')->where('dining', 'dining)->where('party','party')->get();

How can I do this in laravel, it gives me an error, no matter if I pass it as $master_string or {{$master_string}}.

user1669496 · Accepted Answer · 2016-01-07 15:48:09Z

2

There is no need for master string. Just use the query builder how it's meant to be used...

    $master_array = $_POST['master_search_array'];

    $count = count($master_array);
    $query = DB::table('tours');

    for($i=0; $i<$count; $i++) {
        if($master_array[$i] == "Dining"){
            $query->where('dining', 'dining');
        }
        if($master_array[$i] == "Party"){
            $query->where('party', 'party');
        }
    }

    $tours = $query->get();

    return $tours;

answered Jan 7, 2016 at 15:48

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

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

1 Comment

MasterSith Over a year ago

This did not even cross my mind, i always complicate things ^^ thank you

aynber · Accepted Answer · 2016-01-07 15:48:17Z

0

Use the ability to add wheres to the query along the way.

DB::table('tour')->where(function($query) use ($master_array)
{
    foreach($master_array as $k => $v) {

        if($v == "Dining"){
            $query->where('dining','dining');
        }
        if($v == "Party"){
            $query->where('party','party');
        }
    }
})
->get();

answered Jan 7, 2016 at 15:48

aynber

23.2k9 gold badges57 silver badges69 bronze badges

Collectives™ on Stack Overflow

Custom query for database in Laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related