Create nested array in PHP from array by foreign keys

Question

I am doing MySQL query to get a listing files/directories. Each one has an id, and optionally and "parent_id" that relates each file or directory to it's containing directory. It's a flat array off files and directories though. How can I, using php, build this into a nested array something like this where each "Files" can have multiple child "Files" recursively:

[{"Files":{"id": "1","name":"Parent", "parent_id":"null" "Files":{"id": "2","name":"Child", "parent_id":"1"}}, {"Files":{"id": "3","name":"Another top level dir", "parent_id":"null"}]

Thanks!

See: http://stackoverflow.com/questions/4718058/ordering-a-php-array/4718149#4718149 — Matthew, Jul 10 '12 at 19:16

score 2 · Answer 1 · edited May 23 '17 at 12:04

2

What you need is a recursive function to assemble your nested array. Here are some links that should help you to get started.

edited May 23 '17 at 12:04

Community

1
1

answered Jul 10 '12 at 19:14

curtisdf

4,042
4
29
42

Create nested array in PHP from array by foreign keys

1 Answers1