Convert MySQL table with relation to multi-dimensional array

Question

I have a menu table:

id, slug, label, parent

Parent has a relation to id so if you had:

1, 'foo-bar', 'Foo Bar', NULL

This would be a root item whereas:

2, 'foo', 'Foo ', 1

Would belong to 'foo-bar'. Then you could have items belonging to foo and so on.

How can I turn this into a multi-dimensional menu array in PHP? So I can do things like:

<?= $menu['foo-bar']['foo'] // echos 'Foo' ?>

My requirements are very similar to How to convert DB table with parent son relation to multi-dimensional array but the answer there doesn't work; it isn't recursive.

pr0metheus · Accepted Answer · 2016-03-24 12:41:19Z

1

Here is example of foreach (non-tested) that can do something that you want.

<?php
// $results is your data from database
$menu = array();

foreach($results as $k => $result) {
  $key = $result['id'];  
  $parent = $result['parent'];
  if(!empty($parent)){
   array_push($menu[$parent]['parents'], $result);
  } else {
    unset($results[$k]['parent'];
    $menu[$key] = $result;
  }
}

var_dump($menu);

answered Mar 24, 2016 at 12:41

pr0metheus

4886 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Convert MySQL table with relation to multi-dimensional array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related