Populate an array containing two-element rows while looping over a mysql query resultset

Question

I've a 2-dimensional array and i want to push values to it with a while loop like;

$arr[0][1] = 1. value
$arr[0][2] = 2. value

I've tried

while ($zRow = mysql_fetch_array($zQuery))
{
    $props[]['name'] = $zRow['name'];
    $props[]['photo'] = $zRow['thumbnail'];
}

This loop pushes name to $props[0][name] and thumbnail to $props[1][photo]

I also tried

$j = 0;
while($zRow = mysql_fetch_array($zQuery))
{
    $props[$j]['name'] =$zRow['name'];
    $props[$j]['photo'] =$zRow['thumbnail'];
    $j += 1;
}

That works but with this I when I use foreach loop later, it makes trouble like "Illegal offset type".

Here is my foreach loop:

foreach ($props as $no)
{
    echo $props[$no]['name'];
}

Now my questions:

Are there any other way than while loop with $j variable like array_push() for 2-dimensional arrays?
How can I use foreach loop for 2-dimensional arrays?

drew010 · Accepted Answer · 2012-02-05 22:05:06Z

18

You could change the first loop to the following:

while($zRow = mysql_fetch_array($zQuery))
{
    $row = array();
    $row['name'] = $zRow['name'];
    $row['photo'] = $zRow['thumbnail'];
    $props[] = $row;
}

Your method also works, but you need that extra variable.

In your second loop, what you actually need to be doing is:

foreach($props as $index => $array)
{
    echo $props[$index]['name'];
    // OR
    echo $array['name'];
}

answered Feb 5, 2012 at 22:05

drew010

70.3k11 gold badges144 silver badges174 bronze badges

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

Comments

Andy · Accepted Answer · 2012-02-06 21:23:01Z

4

Pushing anything onto an array with $myArray[] = 'foo' will increment the array's counter.

For multidimensional array, you need to populate the "inner" array, then push it to the "outer" (in your case $props) array.

while($zRow = mysql_fetch_array($zQuery)) {
    $data = array('name' => $zRow['name'], 'photo' => $zRow['thumbnail']);
    $props[] = $data;
}

To iterate over multidimensional arrays whose depth is known:

foreach ($props as $prop) {
    foreach ($prop as $key => $value) {
        echo "{$key} => {$value}" . PHP_EOL;
    }
}

If the depth of the nesting is not known, you may have to use a recursive function to gather the data.

edited Feb 6, 2012 at 21:23

answered Feb 5, 2012 at 22:02

Andy

17.8k9 gold badges55 silver badges70 bronze badges

1 Comment

Malixxl Over a year ago

and how can i use foreach for 2-dimensional arrays?

Collectives™ on Stack Overflow

Populate an array containing two-element rows while looping over a mysql query resultset

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related