php print array using nested foreach

Question

I would like to ask how to print out this array with organize way

This is my array

> Array (
>     [item1 under Category_1] => Category_1
>     [item2 under Category_1] => Category_1
>     [item3 under Category_2] => Category_2
>     [item4 under Category_3] => Category_3
>     [item5 under Category_3] => Category_3
>     [item6 under Category_3] => Category_3
>     [item7 under Category_3] => Category_3
>     [item8 under Category_3] => Category_3 )

The output should like this:

Category_1
  item1
  item2
Category_2
  item3
Category_3
  item4
  item5
  item6
  item7
  item8

Is there any way I can do this? or my logic way to arrange my array is wrong?

My database table record is like this

category item
   1       1
   1       2
   2       3
   3       4
   3       5
   3       6
   3       7
   3       8

Anyone can help?

merkuro · Accepted Answer · 2009-06-26 05:25:48Z

4

You probably need to adjust layout and line breaks, but I think you get the idea:

asort($your_array);
foreach($your_array as $key => $value){
  if($key_temp != $key){
    echo $key."\r\n";
  }  
  echo " ".$value."\r\n";  
  $key_temp = $key;
}

answered Jun 26, 2009 at 5:25

merkuro

6,1872 gold badges29 silver badges29 bronze badges

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

Comments

Haim Evgi · Accepted Answer · 2009-06-26 05:25:21Z

1

first the query

$myarray = array();
$result = mysql_query("SELECT category , item FROM mytable order by category , item ");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

$myarray[$row['category'] ][]  = $row['item'];

}

now u get a 2 dimension array

now run on this array in 2 loop (foreach or for) and print the key of the entery and after that the items in this entery

foreach ($array as $key => $val) {
    print "Key $key\n";
    for($i=0;$i<count($val);$i++)
       print "val $val[$i]\n";


}

this is example you can improve it ; i hope the idea is clear

edited Jun 26, 2009 at 5:25

answered Jun 26, 2009 at 5:19

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

1 Comment

Sasha Chedygov Over a year ago

I think he's looking for a way to print it out, not just to store it.

Collectives™ on Stack Overflow

php print array using nested foreach

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related