How to build Laravel Eloquent for Query String from URL?

0
votes

I am new to Laravel,

the query string from url may be three kind

  1. Both "Filter" and "Status": http://localhost/products?filter=productName&value=Test+Product+1&status=A&action=Filter+Result
  2. "Filter" only and "Status" will be empty: http://localhost/products?filter=productName&value=Test+Product+1&status=&action=Filter+Result
  3. "Status only and "Filter" will be empty: "Filter" and "Status" http://localhost/products?filter=&value=&status=A&action=Filter+Result

Now from Controller i can access the Query string with $inputQ = Request::input()

in normal php i can do easy like below

$sql = 'SELECT * FROM products WHERE 1 = 1';

if(isset($_REQUEST['filter']) && $_REQUEST['filter'] != '' && $_REQUEST['value'] != ''){
$sql .= 'AND `'.$_REQUEST['filter'].'` = "'.addslashes($_REQUEST['value']).'"';
}

if(isset($_REQUEST['status']) && $_REQUEST['status'] != ''){
$sql .= 'AND `status` = "'.addslashes($_REQUEST['status']).'"';
}

$res = mysql_query($sql);

Now i need to build Laravel Eloquent please help me.

1
mysqllaravellaravel-4eloquent
laravel.com/docs/4.2/queries#advanced-wheres – Nabin Kunwar
@nbin i have read that... my question is i need to add WHERE only when the particular parameter found in URL and if the parameter value is not empty. can you give me some sample code? – rkaartikeyan

1 Answers

1
votes

I think you're looking for something like this? I didn't test it but i guess it should work.

$query = DB::table('products')->where(1, '=', 1);

if(Input::has('filter') && Input::has('value')){
    $query->where(Input::get('filter'), '=', Input::get('value'));
}

if(Input::has('status')){
    $query->where('status', '=', Input::get('status'));
}

$res = $query->get();