Laravel - set array just with values

Question

I'm trying to send an email to multiple emails, so I did a query to my users tables but the result is an array with keys that don't work mail->to().

I need an array like this: $owners = ['[email protected]', '[email protected]','[email protected]']; from database.

My query:

$owners = DB::table('users')->select('email')->where('active', 1)->where('userType', 1)->get();

I also try use ->toArray() but comes with keys.

Email:

Mail::send('email-view', $data, function($message) use ($data, $owners)
{
  $message->from('[email protected]' , 'FROM');
  $message->to($owners)->subject('subject');

});

please check my answer. it might be resolve your problem. Thanks. — Darshan Jain
– Darshan Jain, Commented Mar 22, 2018 at 11:47
$query->where([ ['column_1', '=', 'value_1'], ['column_2', '<>', 'value_2'], [COLUMN, OPERATOR, VALUE], ... ]) — Eazy Sam
– Eazy Sam, Commented Mar 22, 2018 at 11:55

Darshan Jain · Accepted Answer · 2018-03-22 12:03:38Z

1

$owners = DB::table('users')->where('active', 1)->where('userType', 1)->pluck('email')->toArray();

edited Mar 22, 2018 at 12:03

answered Mar 22, 2018 at 11:45

Darshan Jain

4972 silver badges10 bronze badges

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

7 Comments

u_mulder Over a year ago

lists is now pluck.

Darshan Jain Over a year ago

Oh! yes Modified it...@u_mulder. Thanks for your suggestion.

user3242861 Over a year ago

returns me Illegal offset type @DarshanJain

Darshan Jain Over a year ago

which laravel version you are using @user3242861 ?

user3242861 Over a year ago

5.4 @DarshanJain

|

Phiter · Accepted Answer · 2018-03-22 11:45:09Z

1

You can use ->pluck(), like this:

$owners = DB::table('users')->select('email')->where('active', 1)->where('userType', 1)->get();
$emailList = $owners->pluck('email');

answered Mar 22, 2018 at 11:45

Phiter

15k14 gold badges52 silver badges87 bronze badges

1 Comment

user3242861 Over a year ago

Returns me Illegal offset type @Phiter

Kuldeep Mishra · Accepted Answer · 2018-03-22 11:54:56Z

0

$owners = DB::table('users')->where('active', 1)->where('userType', 1)->pluck('email');

or

    $owners = User::where('active', 1)->where('userType', 1)->pluck('email');

here User is your model name

answered Mar 22, 2018 at 11:54

Kuldeep Mishra

4,0601 gold badge24 silver badges26 bronze badges

Comments

Eazy Sam · Accepted Answer · 2018-03-22 11:58:33Z

0

First of all, the where condition is not proper in your query builder code. It has to be like:

$query->where([
    ['column_1', '=', 'value_1'],
    ['column_2', '<>', 'value_2'],
    [COLUMN, OPERATOR, VALUE],
    ...
])

You can use pluck() to get the list in Laravel 5.

All collections also serve as iterators, allowing you to loop over them as if they were simple PHP arrays:

    foreach ($owners as $owner) {
        echo $owner->filed_name;
        echo $owner->filed_name;
        ...
    }

There is no restriction for using the core PHP code while using a PHP framework. You may refer the official PHP Arrays Manual page to work with the language construct.

If you need to convert JSON to array, use:

json_decode($owners);

edited Mar 22, 2018 at 11:58

answered Mar 22, 2018 at 11:51

Eazy Sam

3081 gold badge2 silver badges9 bronze badges

Collectives™ on Stack Overflow

Laravel - set array just with values

4 Answers 4

7 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

7 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related