how should I concatenate query when using Laravel(MVC) framework?

Question

static function getall($input) {
$where = [];
$params = [];
$sql = 'SELECT * FROM radio_city';
if (isset($input['city']) && $input['city']) {
$where[] = ' city = ?'; // Subsequent additions to $where should specify AND/OR conditional
$params[] = $input['city']; 
}
$sql .= implode(' ', $where); 
$sql .= " GROUP BY city";
return DB::select($sql, $where, $params); 
}
}

Here I am using the Laravel(MVC) framework. I am redirecting input form from controller so how should i concatenate query with that input. So is this code works or need any modification?

Maybe laravel.com/docs/queries#selects can help

CSᵠ
– CSᵠ

2014-05-04 11:50:49 +00:00
Commented May 4, 2014 at 11:50 — CSᵠ
– CSᵠ, Commented May 4, 2014 at 11:50

The Alpha · Accepted Answer · 2014-05-04 12:00:02Z

1

You may try something like this:

public static function getAll() {
     $query = DB::table('radio_city');
     if($city = Input::get('city')) {
         $query->where('city', $city);
     }
     return $query->groupBy('city')->get();
}

Read more on the documentation. Also look at the Eloquent ORM and Scope as well. You should read the documentation first, everything is given there.

edited May 4, 2014 at 12:00

answered May 4, 2014 at 11:54

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

Comments

score 0 · Accepted Answer · 2016-09-27 20:06:23Z

0

The most like is http://laravel.com/docs/queries#joins because Lavarel use a wrapper for the query, it don't use ORM, if you use a framework with ORM (for example Django) or a ORM for PHP (for example Doctrine http://www.doctrine-project.org/ that it is use in Symfony) you can make query more advanced without SQL, but with Laravel you need make it with SQL maked with wrapper of Laravel.

edited Sep 27, 2016 at 20:06

answered May 4, 2014 at 11:57

user2006656

Collectives™ on Stack Overflow

how should I concatenate query when using Laravel(MVC) framework?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related