PHP Turn a multidimensional array into nested list

Question

I get results from a MYSQL query, and I'm struggling turning this array into a nested list :

I tried tons of codes, but none can get me this precise output :

<ul>
    <li>Esprit</li>
    <li>GC</li>
    <li>Guess
        <ul>
            <li>Jewels</li>
            <li>Products-shot</li>
            <li>New-collection</li>
        </ul>
    </li>
    <li>Guess-Connect</li>
    <li>Nautica</li>
    <li>Obaku</li>
    <li>Police</li>
    <li>Roamer</li>
    <li>Superdry</li>
    <li>Vulcain</li>
</ul>

I'd really appreciate help ! Thanks in advance

The SQL result structure is wrong. You have nested children, but you want to consider them as childrens of same parent. What is wrong? Your concept, or the database structure? — Nacho M.
– Nacho M., Commented May 30, 2016 at 14:08
Actually I get unnested data from phpMyAdmin. I use a function to build up a new array nesting the children to their parents according to a 'parent_id' column. — Neoweiter
– Neoweiter, Commented May 30, 2016 at 14:23

mega6382 · Accepted Answer · 2017-10-23 08:19:07Z

2

You can only put second level display try this:

function second_level_list( $arr ){
  foreach( $arr as $item ){
     echo '<li>';
     echo $item['post_title'];
     echo '</li>';
     if( isset($item['children']) && is_array($item['children']) ){
       second_level_list( $item['children']);
     }
  }
}

<ul>
   <?php  foreach( $array as $list  ): ?> 
     <li><?php echo $list['post_title'] ?>
     <?php if( isset( $list['children'] ) && is_array($list['children']) ): ?>
       <ul> 
          <?php second_level_list( $list['children'] ); ?>
       </ul> 
      <?php endif; ?>  
     </li>
   <?php endforeach; ?>  
</ul>

Complete results https://3v4l.org/YD0Yc

edited Oct 23, 2017 at 8:19

mega6382

9,39217 gold badges52 silver badges73 bronze badges

answered May 30, 2016 at 15:11

user5200704

1,70911 silver badges10 bronze badges

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

Comments

mega6382 · Accepted Answer · 2016-05-30 14:40:07Z

1

try the following solution:

function htmlList($arr)
{
    $list = '<ul>';
    foreach ($arr as $value)
    {
        $listItem = (is_array($value) ? htmlList($value) : $value);
        $list .= "<li>$listItem</li>";
    }
    $list .= '</ul>';
    return $list;
}
echo htmlList($array);

edited May 30, 2016 at 14:40

answered May 30, 2016 at 14:05

mega6382

9,39217 gold badges52 silver badges73 bronze badges

3 Comments

Rasclatt Over a year ago

Where is ’make_list` defined?

Peter Over a year ago

I think answerer means htmlList(). You need to call the same function for the sublists.

Dumkaaa Over a year ago

htmlList($array) instead of htmlList($arr)

Neoweiter · Accepted Answer · 2016-05-31 06:24:49Z

0

I adapted your PHP code a little bit, and seems to work for me :

function second_level_list( $arr ){
  foreach( $arr as $item ){
     echo '<li>'.$item['post_title'].'</li>';
     if( isset($item['children']) && is_array($item['children']) ){
     echo '<ul>';
       second_level_list( $item['children']);
     echo '</ul>';
     }
  }
}

Thanks mate

answered May 31, 2016 at 6:24

Neoweiter

8942 gold badges10 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP Turn a multidimensional array into nested list

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related