Query single column and return comma separated Laravel PHP

Question

 $getStrain = DB::connection('mysql')->select('
    SELECT
        
       b.yeast_class_id
    FROM 
        yeast_classes AS a
    LEFT JOIN
        classes_per_yeast AS b 
    ON 
        a.id = b.yeast_class_id
    WHERE
        b.yeast_id = "'.$id.'"
    GROUP BY
        b.yeast_class_id
');

dd($getStrain);

and it returns something like this

But what I want to do is get a response something like this

1,4,5,6,7

where all yeast_class_id will be combined together

lagbox · Accepted Answer · 2020-11-12 06:17:04Z

4

From that array of objects you have you could pluck the field you want from them into an array:

Illuminate\Support\Arr::pluck($getStrain, 'yeast_class_id')

Or put the array into a Collection and use the pluck method on the Collection:

collect($getStrain)->pluck('yeast_class_id')->all()

If you want a comma separated string of the list:

collect($getStrain)->pluck('yeast_class_id')->join(',')

Laravel 8.x Docs - Helpers - Array & Objects - Arr::pluck

Laravel 8.x Docs - Helpers - Miscellaneous - collect

Laravel 8.x Docs - Collections - Available Methods - pluck

Laravel 8.x Docs - Collections - Available Methods - all

Laravel 8.x Docs - Collections - Available Methods - join

edited Nov 12, 2020 at 6:17

answered Nov 12, 2020 at 5:57

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

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

Comments

bhucho · Accepted Answer · 2020-11-12 05:57:14Z

1

Check the helper values()

$getStrainValues = $getStrain->values();

answered Nov 12, 2020 at 5:57

bhucho

3,4303 gold badges19 silver badges37 bronze badges

Collectives™ on Stack Overflow

Query single column and return comma separated Laravel PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related