How to select or sort using order by array in Laravel - PeakU

0

292

Views

How to select or sort using order by array in Laravel

$return=DB::table('products')
                ->select('products.*', 'images.address')
                ->leftJoin("images",function($join){
                            $join->on('products.id', '=', 'images.product_id');
                            $join->where('images.default','1');
                        })
                ->whereIn('products.id',session("idcompare"))
                ->get();

session('idcompare') has values (1,4,2)
When this is selected, the result set for products.id is in order 1,2,4
How to select or order by my session?

over 4 years ago · Santiago Trujillo

2 answers

Answer question

0

Another way, put this line before your get

->orderByRaw('FIELD(products.id,session("idcompare"))')

over 4 years ago · Santiago Trujillo Report

0

        $arr=[];
        foreach(session("idcompare") as $i){
            foreach($return as $j) {
                if ($i == $j->id) {
                    $arr[] = $j;
                }
            }
        }
        return $arr;

Ohh this is easy

over 4 years ago · Santiago Trujillo Report

Answer question

Find remote jobs