Hello How To Apply This Query In Laravel

Can you show an example of a line from your database you would expect to get with this query?

Something like?

price_before | price_after
0             | 0                         <-should not be found
22            | 0                         <- should be found

@RESIN -

I'm Appreciate your time 
I need show 
price_before | price_after
0               |  1
1               | 0
1               | 1

But I dont need to show only if
price_before | price_after
0 | 0

My query in the question show only if 
price_before | price_after
1 | 1

That should work. Can you try this and post the result

dd(Product::where('price_before','!=',0)
                            ->where('price_after','!=',0)
                        ->toSql());

okey

@RESIN - Here

"select * from `products` where `price_before` != ? and `price_after` != ?"

i dont know why it isnt work

Can you open you database directly (in heidisql or dbeaver etc) and copy/paste that query in?

select * from `products` where `price_before` != 0 and `price_after` != 0

Does it return any rows?

@RESIN - Okey Sir Really Appercite your time

@RESIN - Give Me only product 1 | 1

Try this instead

$products = Product::where('price_before','!=',0)
                            ->orWhere('price_after','!=',0)
                        ->get();
return ProductResource::collection($products);

Thanks So Much sir For your time it's worked But Why ?

The problem is that is says price_before AND price_after should both not be 0. So when one is 0 it fails The new one makes the following query

select * from `products` where `price_before` != 0 or `price_after` != 0

Notice that is says OR instead of AND. This implies that just one of them must be true to return a row

Thanks So much sir foryour help