Store values in multidimensional array using php

Question

I am using a while loop

      $i = 0;
      $arr = array();
      while($get_key1 = mysql_fetch_assoc($get_key))
      {
        $busid = $get_key1['busid'];
        $get_key2 = mysql_query("select * from `route` where `busid`='$busid'") or die(mysql_error());

        while($get_key3 = mysql_fetch_assoc($get_key2))
        {
            $arr[$i] = $get_key3['routid'];
            echo "<pre>";
            print_r($arr);
        }
        echo "<hr/>";
        $i++;
      }

This inner loop gives three values, 1,3,4 and when itereates again then it gives values 1,4 I want to create a multi dimensional array as

array(array(1,3,4),array(1,4))

but the above code gives the result as :

Array
(
    [0] => 1
)

Array
(
    [0] => 1
    [1] => 3
)

Array
(
    [0] => 1
    [1] => 3
    [2] => 4
)

Array
(
    [0] => 1
    [1] => 3
    [2] => 4
    [3] => 1
)

Array
(
    [0] => 1
    [1] => 3
    [2] => 4
    [3] => 1
    [4] => 4
)

How can I store the values through while loop in multi dimensional array

change $arr[$i] to $arr[$i][]

Chetan Ameta
– Chetan Ameta

2015-12-16 05:05:09 +00:00
Commented Dec 16, 2015 at 5:05 — Chetan Ameta
– Chetan Ameta, Commented Dec 16, 2015 at 5:05

Disha V. · Accepted Answer · 2015-12-16 05:06:08Z

3

You need to use $i as outer array and let create index of inner array itself.

while($get_key3 = mysql_fetch_assoc($get_key2))
{
    $arr[$i][] = $get_key3['routid']; // simple change
    echo "<pre>";
    print_r($arr);
}

answered Dec 16, 2015 at 5:06

Disha V.

1,8641 gold badge13 silver badges21 bronze badges

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

1 Comment

Rohitashv Singhal Over a year ago

Thanks Disha it saved me

Collectives™ on Stack Overflow

Store values in multidimensional array using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related