Vreau sa implementez in site-ul meu categorii si subcategorii
Am facut tabelul mysql
CREATE TABLE `category` (
`id` int(11) NOT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
$categoryIDs = $Database->query(sprintf('SELECT id FROM %s ORDER BY id ASC', Category\Attribute::TABLE));
foreach($categoryIDs->fetchAll($Database::FETCH_COLUMN) as $categoryID) {
$Category = Category\Factory::build($categoryID);
$categoryAttributes[] = [
'ID' => $Category->attr('id'),
'NAME' => $Category->attr('name'),
'PARENT_ID' => $Category->attr('parent_id'),
];
}
$FormTemplate->set('FORM', [ 'CATEGORY_LIST' => $categoryAttributes ?? [] ]);
Am afisat toate categoriile
<?php foreach($FORM['CATEGORY_LIST'] as $category): ?>
<option value="<?=$category['ID']?>"><?=escapeHTML($category['ID'])?> [<?=$category['NAME']?>]</option>
<?php endforeach; ?>
Categoriile si subcategoriile sunt afisate in lista simpla
Cum as putea afisa in acest mod?
-Categorie
–sub categorie
—sub categorie
----sub categorie
-----sub categorie
-Categorie