Date fetch issue

it not working.

$orders = new Order;

        if($id) {

            $orders->whereSeller_id($id);

        }
        
        $orders->latest()->get();

        dd($orders);

frankielee

5 years ago

Level 29

I assumed the column name is seller_id

By referring to https://laravel.com/docs/7.x/eloquent#retrieving-models=

Single Model

$orders->where('seller_id',$id)->latest()->first();

or 

$orders->whereSellerId($id)->latest()->first();

MichalOravec

5 years ago

Best Answer

Level 75

@mahaveer Use Conditional Clauses

$orders = Order::when($id, function ($query, $id) {
    return $query->where('seller_id', $id);
})->latest()->get();

Docs: https://laravel.com/docs/7.x/queries#conditional-clauses

Please or to participate in this conversation.