Push values into an empty array from foreach

Question

I have a collection of object retrieved from the database such that the output is [{"id":"5"},{"id":"76"},{"id":"33"}]. I want the output to be: [5, 76, 33].

I tried doing this using the code below but no luck. Working in laravel.

$UserNot = [2,3];
$allverified = array();
$verified = App\Models\User::whereNotIn('id', $UserNot)->select('id')->where('role', 'verified')->get()->take(5);

foreach ($verified as $veribadge) {
    $king = $veribadge->id;
    $allverified[] = $king;
}

"no luck" is not descriptive enough. What is the issue you're encountering ? is the query even returning any user ids ? or you have an error message ? — N69S
– N69S, Commented Apr 13, 2022 at 13:26
You are right, will add more detail in the future. Thanks for your help! — myJourney
– myJourney, Commented Apr 13, 2022 at 14:01

N69S · Accepted Answer · 2022-04-13 13:25:21Z

4

You can do it directly from database using pluck without having to initiate a collection of User instances and looping it.

$UserNot = [2,3];
$allverified = App\Models\User::query()
    ->whereNotIn('id', $UserNot)
    ->where('role', 'verified')
    ->pluck('id')
    ->toArray();

answered Apr 13, 2022 at 13:25

N69S

17.3k4 gold badges25 silver badges41 bronze badges

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

Comments

AlirezaAhmadi · Accepted Answer · 2022-04-14 11:42:06Z

1

I suggest using the namespace first: ‌

use App\Models\User;

For cleaner coding it is better: delete $UserNot and put the relevant code directly in the query:

$verifiedUsers = User::query()
    ->whereNotIn('id', [2,3])
    ->where('role', 'verified')
    ->pluck('id')
    ->toArray();

answered Apr 14, 2022 at 11:42

AlirezaAhmadi

721 silver badge11 bronze badges

Collectives™ on Stack Overflow

Push values into an empty array from foreach

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