query sql in controller laravel

Question

Error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '&& product_price > ?' at line 1 (SQL: select * from table_products where && product_price > 0)

my code:

public function faq(Request $request) {

    $pro = Product::all();
    $p_1  = Product::where('product_price', '>', 0,'&&', 'product_price','<', 250)->get();
    return view('fontend.errors.faq', compact('pro', 'p_1'));
}

thank you, bug in this old post I had fixed. Can you help me query mysql — Honda hoda
– Honda hoda, Commented Dec 21, 2017 at 13:56
Tag properly!!!!! It's either MySQL or SQL Server, can't be both. — Eric
– Eric, Commented Dec 21, 2017 at 17:35

M Khalid Junaid · Accepted Answer · 2017-12-21 14:14:22Z

1

You could add another where() to your query to apply filter

$p_1  = Product::where('product_price', '>', 0)
               ->where('product_price','<', 250)
               ->get();

this will produce a query like

select * from table_products where product_price > 0 and product_price < 250

or you could use ->whereBetween()

$p_1  = Product::whereBetween('product_price', [0, 250])
               ->get();

answered Dec 21, 2017 at 14:14

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

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

Collectives™ on Stack Overflow

query sql in controller laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related