How to save a tree from mysql to an array in php?

Question

PHP

The database has a table of categories with parents and children. How to display it in php as an array?

Answer 1

For example like this sandbox.onlinephpfunctions.com/code/a3ee3d0e462cda...

Answer 2

If there is not a lot of data, you can do this:
1. Unload into a regular array of hashes with a regular select.
2. Set up a recursive function that receives the id of the tree node, and returns a hash whose keys are the id of the elements of the original table containing this node in the parent field, and the values ​​are links to the result of applying the same function to the key.

Answer 3

For the first pass, I would calculate all the relationships for each element, the entire nesting depth.
By the second pass, I generated the tree itself, decomposing the elements into it.

Answer 4

<?php
$xml = simplexml_load_file('file.xml');
foreach ($xml->WMExchnagerQuerys->query as $query) {
    echo (string) $query['id'], "\t", (string) $query['amountin'], "\t", (string) $query['amountout'], "\n";
}