Change key in array of objects from Eloquent query

Question

I have an array of objects coming from an Eloquent query:

[
    {
        "id": 1,
        "user_id": 1,
        "name": null,
        "link": "storage/images/foo.png"       
    },
    {
        "id": 2,
        "user_id": 1,
        "name": null,
        "link": "storage/images/foo.png"
    },
    {..}
]

In PHP, what would be the most efficient way to rename the "link" key to "url" in every object in the array? Keeping the same order of elements would be a bonus.

I'm hopeful to achieve this:

[
    {
        "id": 1,
        "user_id": 1,
        "name": null,
        "url": "storage/images/foo.png"       
    },
    {
        "id": 2,
        "user_id": 1,
        "name": null,
        "url": "storage/images/foo.png"
    },
    {..}
]

guessing you are using eloquent to get ur data, like User::all() or something alike, try making it a select query as follow: User::select('id, user_id, link as url')->get(); to have this fixed for you. — killstreet
– killstreet, Commented Jul 31, 2018 at 11:38
It looks like you got this data as json so you could simply str_replace('"link"', '"url"', $json); — Nick
– Nick, Commented Jul 31, 2018 at 11:40
@killstreet All my hard work for nothing! Ha, j/k, you should post your comment as an answer; I would upvote it for the simple fact that you are clearly a mind reader lol. — MonkeyZeus
– MonkeyZeus, Commented Jul 31, 2018 at 11:53

killstreet · Accepted Answer · 2018-07-31 11:57:13Z

7

As my comment seemed to be the correct way, and for sure faster than looping over an already generated array ill post it as an answer here.

guessing you are using eloquent to get ur data

User::all()

or something alike, try making it a select query as follow:

User::select('id, user_id, link as url')->get();

to have this fixed for you

answered Jul 31, 2018 at 11:57

killstreet

1,3402 gold badges16 silver badges39 bronze badges

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

Comments

MonkeyZeus · Accepted Answer · 2018-07-31 12:17:54Z

4

For future visitors.

This answer is based on OP's original request of how to rename object keys using PHP. Upon further clarification, OP mentioned that they have access to change the DB query.

However, this answer is a very viable way to alter keys if you do not have access to the source data such as pulling JSON from someone else's server.

It's quite simple. You need to loop, set, and unset:

// Loop the array and get each object into $v by reference
// Objects pass-by-reference by default since PHP 5.0 so no need for &$v in this situation
foreach( $arr as $v )
{
    // Since $v is an object reference, manipulate it directly by setting a url
    $v->url = $v->link;

    // We can unset link
    unset( $v->link );
}

Because link was last anyways, we are able to simply add url to the end and remove link.

If link was in the middle somewhere then this solution would have been a bit trickier because we would have needed to maintain two arrays.

edited Jul 31, 2018 at 12:17

answered Jul 31, 2018 at 11:38

MonkeyZeus

20.8k4 gold badges41 silver badges83 bronze badges

4 Comments

Friso Hoekstra Over a year ago

I ended up doing it within Eloquent (see killstreet's comment), because I'm not sure how a big array would affect performance, but this also worked well.

killstreet Over a year ago

As your answer will work, this will become quite slow when trying this with too many records. Doing this on database level will save code and time.

MonkeyZeus Over a year ago

@FrisoHoekstra Your concerns are justified. Even though 100,000 iterations takes 0.19 seconds in PHP5 and 0.01 in PHP7 it is definitely better to just have the database alias link into url so that you're not wasting CPU cycles.

MonkeyZeus Over a year ago

@killstreet Agreed, I wasn't aware that this was a DB result. Should have checked the tags!

Collectives™ on Stack Overflow

Change key in array of objects from Eloquent query

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related