Dynamic Multi Dimensional Array

Question

I have been trying to fureout how to create a dynamic multi dimensional array.

The reason for this is that I want to create a dropdown menu that will be created dynamically from the mysql

Sample database

|id|menu_name|menu_parent_id|

|1 |top menu1|      0       |

|2 |top menu2|      0       |

|3 |top menu3|      0       |

|4 |top menu4|      0       |

|5 |sub menu |      2       |

|6 |sub menu |      2       |

|7 |sub menu |      5       |

|8 |sub menu |      6       |

|9 |top menu |      0       |

I thought of starting from getting the menu with no parent then put it on an array

$parentIDs[0]=0;
$tempParentIDs = array();
$childIDs = array();
$menus = array();
$rows = 0;

$rows=0;
foreach($parentIDs AS $value){
$sql = mysql_query("SELECT * FROM service WHERE service_parent_id=$value");
while($temp = mysql_fetch_array($sql)){

    //$tempParentIDs[] = $temp['service_id'];

    //check if parent have child
    $sql2 = mysql_query("SELECT * FROM service WHERE  service_parent_id=$temp[service_id]") or die(mysql_error());
    $rows = mysql_num_rows($sql2);
    if($rows >= 1){
        //This means there is a child
        while($temp2 = mysql_fetch_array($sql2)){
            $childIDs[] = $temp2['service_id'];
        }

        $tempParentIDs[$temp['service_id']] = $childIDs;
        unset($childIDs);
    } else {
        //This means there is no child
    }
}
}

echo "<pre>";
print_r($tempParentIDs);
echo "</pre>";

but after then I'm stuck.

what you need additional in your multidimensional array?

Vijay Verma
– Vijay Verma

2013-11-16 05:54:14 +00:00
Commented Nov 16, 2013 at 5:54 — Vijay Verma
– Vijay Verma, Commented Nov 16, 2013 at 5:54
@VijayVerma, I just want to create a menu from the mysql

Keith Varias
– Keith Varias

2013-11-16 08:16:32 +00:00
Commented Nov 16, 2013 at 8:16 — Keith Varias
– Keith Varias, Commented Nov 16, 2013 at 8:16

Vijay Verma · Accepted Answer · 2013-11-16 08:27:50Z

1

I think you are looking for this:

$parentIDs[0]=0;
$tempParentIDs = array();
$childIDs = array();
$menus = array();
$rows = 0;
$multiDimensionalArray = NULL; //here I made change - vijay

$rows=0;
foreach($parentIDs AS $value){
$sql = mysql_query("SELECT * FROM service WHERE service_parent_id=$value");
while($temp = mysql_fetch_array($sql)){

    $tempParentIDs = $temp['service_id']; //here I made change - vijay

    //check if parent have child
    $sql2 = mysql_query("SELECT * FROM service WHERE  service_parent_id=$temp[service_id]") or die(mysql_error());
    $rows = mysql_num_rows($sql2);
    if($rows >= 1){
        //This means there is a child
        while($temp2 = mysql_fetch_array($sql2)){
            $multiDimensionalArray[$tempParentIDs][] = $temp2['service_id']; //here I made change - vijay
        }

       // $tempParentIDs[$temp['service_id']] = $childIDs; //here I made change - vijay
       // unset($childIDs); //here I made change - vijay
    } else {
        //This means there is no child
    }
}
}

echo "<pre>";
print_r($multiDimensionalArray); //here I made change - vijay
echo "</pre>";

answered Nov 16, 2013 at 8:27

Vijay Verma

3,7082 gold badges21 silver badges27 bronze badges

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

3 Comments

Keith Varias Over a year ago

Thanks @Vijay, however this only reaches until level two of the array.. If you take a look at it you can see that one of the record is actually under a sub menu |8 |sub menu | 6 |

Vijay Verma Over a year ago

It is not possible easily in loop, you need recursion for that.

Keith Varias Over a year ago

I see. So instead of searching for loop? THank you for pointin me on the right direction!

Rahul K · Accepted Answer · 2013-11-16 05:50:47Z

0

You should store array in php like this way : This will maybe work for you

$next = 0;

$level = 0;

$sql = mysql_query("SELECT * FROM service WHERE service_parent_id=$next");

$temps = array();

while($temp = mysql_fetch_array($sql))
{
$temps[] = $temp;
}

foreach($temps as $temp)
{
echo $temp['service_id'];
}

answered Nov 16, 2013 at 5:50

Rahul K

4133 silver badges11 bronze badges

Collectives™ on Stack Overflow

Dynamic Multi Dimensional Array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest