Adding item to an associative array in php at index 0

Question

$result=mysql_query("SELECT * FROM users where id=1");
print_r($result);

Here is the result data from mysql query.

Array
(
    [0] => stdClass Object
        (
            [firstname] => "John"
            [middleinitial] => "A."
            [lastname] => "Doe"
        )
)

I want to add address: "USA" after the lastname that will result like this:

Array
(
    [0] => stdClass Object
        (
            [firstname] => "John"
            [middleinitial] => "A."
            [lastname] => "Doe"
            [address] => "USA"
        )
)

How can I append that to $result variable in php? Help would much appreciated. Tnx :)

Or SELECT *,'USA' as address FROM users where id=1 Then it will be in the array without needing to add it — RiggsFolly
– RiggsFolly, Commented Feb 18, 2017 at 16:18
Or better still amend the table to have a column to hold that data — RiggsFolly
– RiggsFolly, Commented Feb 18, 2017 at 16:18

Rahul · Accepted Answer · 2017-02-18 16:20:21Z

2

This will work in one/more than one element case

$result = array_map(function ($v) {
    $v->address = "USA";
    return $v;
}, $result);

Give it a try. This should work.

answered Feb 18, 2017 at 16:20

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

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

Comments

Niklesh Raut · Accepted Answer · 2017-02-18 16:15:31Z

1

This will work

  $result[0]->address = "USA";

answered Feb 18, 2017 at 16:15

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

Comments

wogsland · Accepted Answer · 2017-02-18 17:10:11Z

1

You simply need to add a property to the object contained in the first index of your array,

$result[0]->address = 'USA';

Furthermore, if your array has multiple indices and you want to iterate through them all and add an address then you can do the following:

foreach ($result as &$row) {
    $row->address = 'USA';
}

where the & is to pass the $row variable into the loop by reference so that you can modify it.

answered Feb 18, 2017 at 17:10

wogsland

9,53121 gold badges63 silver badges99 bronze badges

Collectives™ on Stack Overflow

Adding item to an associative array in php at index 0

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related