How to build a 2d array with static and dynamic data while looping? [duplicate]

Question

I'm using a foreach loop to create an array from database values like so:

foreach ($query->result_array() as $row) {
   array(
      'user_id'  => $user_id,
      'post_id'  => $row['id'],
      'time'     => '0',
      'platform' => $platform
   );
}

Let's say I pull 2 rows, I need to make this foreach create a multidimensional array in the following format:

$data = array(
    array(
       'user_id'  => '12', 
       'post_id'  => '37822', 
       'time'     => '0',
       'platform' => 'email'
    ),
    array(
       'user_id'  => '12', 
       'post_id'  => '48319', 
       'time'     => '0',
       'platform' => 'email'
    ),
);

$data[]=array(what you already have);

user557846
– user557846

2011-07-23 06:20:32 +00:00
Commented Jul 23, 2011 at 6:20 — user557846
– user557846, Commented Jul 23, 2011 at 6:20

Pascal MARTIN · Accepted Answer · 2011-07-23 06:20:35Z

4

You can first declare an empty array :

$results = array();

then, each time you have a new row, add it to that array :

$results[] = $row;

Or, anyway, to add anything into that array :

$results[] = array( something here );

In your specific case, you'd probably use something like this :

$results = array();
foreach ($query->result_array() as $row) {
    $results[] = array(
                    'user_id' => $user_id, 
                    'post_id' => $row['id'], 
                    'time' => '0', 
                    'platform' => $platform
                );
}

As a reference, the corresponding section of the PHP manual : Creating/modifying with square bracket syntax.

answered Jul 23, 2011 at 6:20

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

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

Collectives™ on Stack Overflow

How to build a 2d array with static and dynamic data while looping? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related