How to get data from a database using FOREACH in Laravel?

Question

Please I have a health management system and trying to get data from the database using foreach. The return value is one array result instead of two. Kindly go through my code. I need assistance to display all results.

Controller.php

$result = \DB::table('patient_results')
        ->select('*')
        ->whereIn('test', $arraylistTable)
        ->where('patient_id', $id)
        ->where('specimen_id', $specimen_id)
        ->get();


        $testValue = $result->pluck('test'); //return values [ "KMS", "MLS"]
        
        foreach($testValue as $clinical_data) {

           return $Testdata = \DB::table('tests')
            ->select('*')
            ->where('test_name', $clinical_data)
            ->get();            
           // returns data for only "KMS" Instead of both. There exist a data for both "KMS", "MLS". How do I display them
        }

Manthan Tripathi · Accepted Answer · 2021-01-19 20:36:00Z

1

It shows one record because you have return statement in your loop. It retuns back on the first execution.

Solution

Combine all the records in an array and then return

Better Solution

Apply Join of both the tables or write a Sub-Query. This will reduce your overhead of the Loop.

answered Jan 19, 2021 at 20:36

Manthan Tripathi

1441 silver badge9 bronze badges

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

1 Comment

Adorablegh Over a year ago

please this is the error am recieving Argument 1 passed to Illuminate\Database\Query\Builder::cleanBindings() must be of the type array

aynber · Accepted Answer · 2021-01-19 20:32:46Z

1

where takes a single value. You're looking for whereIn, which will use the array for the search. It translates to where test_name IN ('KMS','MLS')

->whereIn('test_name', $clinical_data)

answered Jan 19, 2021 at 20:32

aynber

23.2k9 gold badges57 silver badges69 bronze badges

Comments

Hari Shankar Singh · Accepted Answer · 2021-01-20 12:05:03Z

0

$testValue = $result->pluck('test'); //return values [ "KMS", "MLS"]
$newArray = [];
array_push($testValue , $newArray);

   
        foreach($newArray as $clinical_data) {

           return $Testdata = \DB::table('tests')
            ->select('*')
            ->whereIn('$clinical_data', $newArray)
            ->get();            
           // returns data for only "KMS" Instead of both. There exist a data for both "KMS", "MLS". How do I display them
        }

answered Jan 20, 2021 at 12:05

Hari Shankar Singh

242 bronze badges

Collectives™ on Stack Overflow

How to get data from a database using FOREACH in Laravel?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related