getting an error in where laravel eloquent

Question

I have on input as amount and also getting the discount price but getting an error in where condition,

Here is my query,

public function getDiscountProducts(Request $request){

        $amount = $request->input('amount');

        $products = DB::table('products')
        ->select(DB::raw('(((mrp - price) * 100) / mrp) AS discount'))
        ->where(DB::raw('(((mrp - price) * 100) / mrp) AS discount'), $amount)
        ->get();

   
        return response()->json([
            'message' => 'All categories Products',
            'code' => 200,
            'data' => $products,
            'status' => 'success'
        ]);
    }

Please check where I am missing,

Error:

"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 'AS discount is null' at line 1 (SQL: select (((mrp - price) * 100) / mrp) AS discount from products where (((mrp - price) * 100) / mrp) AS discount is null)"

what error are you getting? and I assume you are trying to find where 'discount' is $amount? — lagbox
– lagbox, Commented Sep 4, 2020 at 8:52
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 'AS discount is null' at line 1 (SQL: select (((mrp - price) * 100) / mrp) AS discount from products where (((mrp - price) * 100) / mrp) AS discount is null) — Bhawesh Bhakar
– Bhawesh Bhakar, Commented Sep 4, 2020 at 8:53
why are you not doing the where on 'discount'? where('discount', ...) ? — lagbox
– lagbox, Commented Sep 4, 2020 at 8:54
tried, but getting error, Column not found: 1054 Unknown column 'discount' in 'where clause' (SQL: select (((mrp - price) * 100) / mrp) AS discount from products where discount is null) — Bhawesh Bhakar
– Bhawesh Bhakar, Commented Sep 4, 2020 at 8:56

Jayant · Accepted Answer · 2020-09-04 14:17:24Z

1

try to remove AS discount from where condition.

answered Sep 4, 2020 at 14:17

Jayant

3023 silver badges6 bronze badges

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

Comments

martincarlin87 · Accepted Answer · 2020-09-04 09:19:29Z

0

try changing this line

->where(DB::raw('(((mrp - price) * 100) / mrp) AS discount'), $amount)

to

->where(DB::raw('(((mrp - price) * 100) / mrp)'), $amount)

answered Sep 4, 2020 at 9:19

martincarlin87

11.1k24 gold badges104 silver badges148 bronze badges

Collectives™ on Stack Overflow

getting an error in where laravel eloquent

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