How to build Laravel Eloquent for Query String from URL?

Question

I am new to Laravel,

the query string from url may be three kind

Both "Filter" and "Status": http://localhost/products?filter=productName&value=Test+Product+1&status=A&action=Filter+Result
"Filter" only and "Status" will be empty: http://localhost/products?filter=productName&value=Test+Product+1&status=&action=Filter+Result
"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.

@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
– rkaartikeyan, Commented Feb 17, 2015 at 9:32

astroanu · Accepted Answer · 2015-02-17 09:53:39Z

1

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();

answered Feb 17, 2015 at 9:53

astroanu

4,0392 gold badges39 silver badges51 bronze badges

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

2 Comments

rkaartikeyan Over a year ago

Thanks for the code, i have Model called ProductModel if i use $query = ProductModel::where(1, '=', 1); like this it wont works why?

astroanu Over a year ago

Does this code work ? i just translated your original code to laravel query. laravel.com/docs/4.2/queries. ProductModel::where(...) will not work as it will always return an array of objects or an object.

Collectives™ on Stack Overflow

How to build Laravel Eloquent for Query String from URL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related