How do I get array format instead of object array returned?

Question

I have Laravel 6 code below displays the array with the object format. So I like to display instead of object-based array, just array as I have mentioned below.

 $ins_affiliations =   DB::table('ins_affiliations as af')
                ->select('af.id','af.name')               
                ->where(['af.ins_category_id' => $ins_category_type[0]->category_id])
                ->get()->toArray();

my code shows

  Array
(
    [0] => stdClass Object
        (
            [id] => 12
            [name] => NSDC
        )

    [1] => stdClass Object
        (
            [id] => 13
            [name] => NCVT
        )

    [2] => stdClass Object
        (
            [id] => 14
            [name] => AICTE
        )

    [3] => stdClass Object
        (
            [id] => 15
            [name] => Others
        )

)

what I need

Array
(    
    [12] => NSDC
    [5] => NCVT
    [8] => AICTE
    [11] => Others   
)

How can I achieve this?

You can use pluck('name', 'id') instead get() to execute your query — porloscerros Ψ
– porloscerros Ψ, Commented Oct 28, 2020 at 17:51

Osta · Accepted Answer · 2020-10-28 17:56:50Z

1

You can remove ->toArray() when you retrieve data and then use mapWithKeys which is collection method

$ins_affiliations->mapWithKeys(function ($item) { return [$item->id => $item->name]; })

Then you can use ->all() if you want to get plain array

answered Oct 28, 2020 at 17:56

Osta

1778 bronze badges

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

Collectives™ on Stack Overflow

How do I get array format instead of object array returned?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related