Convert php array into a comma separated list of strings

Question

I have the following array:

$arr = [
    0 => 'value1',
    1 => 'value2',
    2 => 'value3'
];

The select function of my db class takes arguments in the following format:

DB::table('users')->select('value1', 'value2', 'value3')

How can I convert my array to pass those values in my select function?

I tried implode(',', $arr) and it gives one string with comma separated values, but what I want is not a single string, it's a list of comma separated strings like in the example above.

Thanks for any help.

Perhaps DB::table('users')->select(...$arr) if you're using a modern version of PHP; or simply DB::table('users')->select($arr), as the select method will accept an array of arguments — Mark Baker
– Mark Baker, Commented Aug 29, 2016 at 14:31
one solution: DB::table('users')->select("'".implode("','",$array)."'") — devpro
– devpro, Commented Aug 29, 2016 at 14:35

Alexey Mezenin · Accepted Answer · 2016-08-29 14:38:28Z

3

select() can accept an array, so try:

DB::table('users')->select($arr);

This is source code of select() method:

public function select($select = null)
{
    ....

    // In this line Laravel checks if $select is an array. If not, it creates an array from arguments.
    $selects = is_array($select) ? $select : func_get_args();

edited Aug 29, 2016 at 14:38

answered Aug 29, 2016 at 14:34

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

1 Comment

Rocco Milluzzo Over a year ago

It actually "prefers" an array, great!

owliber · Accepted Answer · 2019-06-18 11:18:29Z

0

You can do this in Laravel 5.8 as follows:

DB::table('users')->select('username')->pluck('username')->unique()->flatten();

Hope this helps.

answered Jun 18, 2019 at 11:18

owliber

1

Collectives™ on Stack Overflow

Convert php array into a comma separated list of strings

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related