StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Maybe easier with OOP. Just sort the query by parentId</p> <p>Note: The listChildren method and the printout at the bottom is just there to show it is listed correctly. I did not interpret the question that the display was important.</p> <pre><code>class Element { public $id; public $name; public $parent = null; public $children = array(); public function __construct($id, $name) { $this->id = $id; $this->name = $name; } public function addChild($element) { $this->children[$element->id] = $element; $element->setParent($this); } public function setParent($element) { $this->parent = $element; } public function hasChildren() { return !empty($this->children); } public function listChildren() { if (empty($this->children)) { return null; } $out = array(); foreach ($this->children as $child) { $data = $child->id . ':' . $child->name; $subChildren = $child->listChildren(); if ($subChildren !== null) { $data .= '[' . $subChildren . ']'; } $out[] = $data; } return implode(',', $out); } } $elements = array(); $noParents = array(); while ($row = $connector->fetchArray($result)) { $elements[$row['id']] = $element = new Element($row['id'], $row['name']); if (isset($elements[$row['parent']])) { $elements[$row['parent']]->addChild($element); } else { $noParents[] = $element; } } foreach ($noParents as $element) { if ($element->hasChildren()) { echo "Element {$element->id} has children {$element->listChildren()}.\n"; } else { echo "Element {$element->id} has no children.\n"; } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload