从foreach的第一个元素中获取结果

Question

There are many matching credentials inside the table which are inserted to an foreach loop however I am getting the results only from the first foreach element. How could I fix that?

    foreach($matches as $match)
    {
        $object = $match->object;

        $sales->whereRaw("match (`object`) against (?)", array($object));

        if($match->colourBase == '1')
        {
            $sales->where('colour', '=', 'CC');
            $sales->orWhere('colour', '=', 'CC+DD');

            if($match->maxPrice)
            {
                $sales->where('price', '<=', $match->maxPrice);
            }

            if($match->minPrice)
            {
                $sales->where('price', '>=', $match->minPrice);
            }
        }
    }

    $results = $sales->orderBy('sales.updated_at', 'asc')->get();

@update

This is how I get $matches

 $matches = Match::where('PeopleID', '=', $id)->get();

Answer 1

If you want only one record use first() function. No need to use foreach. :)

$matches = Match::where('PeopleID', '=', $id)->first();