Adding elements to an associative array during a loop

Question

I have this loop:

foreach ($tables as $table => $queries) {
                    foreach ($queries as $query) {
                        $insert = array($query['column'] => $query['value']);
                    }

The $insert associative array should be incremented of new elements each loop, so that the logical result woud be:

 $insert = array($query['column'] => $query['value'], $query['column'] => $query['value'] ...etc);

I tried using $insert[] and $insert .= and $insert += but none of these give the expected result

Thanks for any help

you should also declare your $insert = array(); on the top. so we don't look like bunch of lazy php developers who don't declare our variables before we use them. — DevZer0
– DevZer0, Commented Jul 11, 2013 at 15:17

Zevi Sternlicht · Accepted Answer · 2013-07-11 15:05:29Z

5

You are looking for this

$insert[] =

answered Jul 11, 2013 at 15:05

Zevi Sternlicht

5,39921 silver badges31 bronze badges

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

4 Comments

Zevi Sternlicht Over a year ago

@DevZer0 he should continue with trying $insert[], but add the equals to it, $insert[] =

DevZer0 Over a year ago

ok so we think he didn't put the = sign for assignment, anyway +1

user2426701 Over a year ago

This is returning child arrays and as stated in my question this is not what I am looking for. Thanks anyway

Zevi Sternlicht Over a year ago

@DevZer0 ;) anyway half is deserved anyway!

Harshveer Singh · Accepted Answer · 2013-07-11 15:15:07Z

2

To insert in array use:

$insert[] = array($query['column'] => $query['value']);

edited Jul 11, 2013 at 15:15

answered Jul 11, 2013 at 15:06

Harshveer Singh

4,2277 gold badges40 silver badges46 bronze badges

Comments

Marc B · Accepted Answer · 2013-07-11 15:17:48Z

1

Once the array's been defined, you have to use

$insert[$query['column']] = $query['value']; // sample #1

to specify a new key/value pair within the $insert array.

If you use

$insert[] = array(...); // sample #2

you'll just be inserting a new child array that contains a single key/value pair.

e.g. $insert before

$insert = array(
   'foo' => 'bar'
);

$insert after sample #1

$insert = array(
    'foo' => 'bar',
    'baz' => 'qux'
);

$insert after sample #2:

$insert = array(
   'foo' => 'bar'
   0 => array(
        'baz' => 'qux'
   )
);

answered Jul 11, 2013 at 15:17

Marc B

362k44 gold badges433 silver badges508 bronze badges

3 Comments

DevZer0 Over a year ago

insert after sample 2 is messed up don't you think?

DevZer0 Over a year ago

you have baz inside another array. i am confused where u getting that structure from

Marc B Over a year ago

baz/qux are the two bits of $query, basically.

Pez · Accepted Answer · 2013-07-11 15:24:55Z

0

$insert = array();

foreach ($tables as $table => $queries) 
{

    foreach ($queries as $query) 
    {
            $insert[$query['column']] = $query['value'];      
    }

}

answered Jul 11, 2013 at 15:24

Pez

312 bronze badges

Collectives™ on Stack Overflow

Adding elements to an associative array during a loop

4 Answers 4

4 Comments

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related