<?php
class A1 {
public function rows() {
$a = array();
$a[] = array('parent_id' => 10, 'category_id' => 13, 'name' => 'id13');
$a[] = array('parent_id' => 8, 'category_id' => 12, 'name' => 'id12');
$a[] = array('parent_id' => 7, 'category_id' => 11, 'name' => 'id11');
$a[] = array('parent_id' => 7, 'category_id' => 10, 'name' => 'id10');
$a[] = array('parent_id' => 0, 'category_id' => 9, 'name' => 'id9');
$a[] = array('parent_id' => 0, 'category_id' => 8, 'name' => 'id8');
$a[] = array('parent_id' => 0, 'category_id' => 7, 'name' => 'id7');
return $a;
}
}
$query = new A1;
$categoryArray = array();
foreach($query->rows() as $row) {
if(isset($categoryArray[$row['category_id']])) {
$categoryArray[$row['parent_id']][$row['category_id']]['name'] = $row['name'];
$categoryArray[$row['parent_id']][$row['category_id']]['elements'] = $categoryArray[$row['category_id']];
unset($categoryArray[$row['category_id']]);
} else {
$categoryArray[$row['parent_id']][$row['category_id']]['name'] = $row['name'];
}
}
echo "first stage \n";
print_r($categoryArray);
// second stage
echo "\n\n";
getCategory($categoryArray[0]);
function getCategory($array){
foreach($array as $row){
print_r($row);
/*
if(isset($row['elements'])) {
echo('<li>'.$row['name'].'<ul>');
getCategory($row['elements']);
echo('</ul></li>');
} else {
echo('<li>'.$row['name'].'</li>');
}
*/
}
}
preferences:
54.02 ms | 402 KiB | 5 Q