categorii si subcategorii
Last Updated: Oct 27 2019 22:06, Started by
bunicu9
, Oct 27 2019 16:11
·
0
#1
Posted 27 October 2019 - 16:11
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; $category_recs = R::findAll('category', 'order by name'); $categories = []; foreach($category_recs as $rec) { if(is_null($category_id)){ $category_id = $rec->id; } $categories[$rec->id] = $rec->name; } $data = ['categories' => $categories ]; $smarty->assign( $data ); $smarty->display("addproduct.tpl"); <tr> <th>category:</th> <td> <select name="category_id"> {html_options options=$categories selected=$category_id} </select> </td> </tr> Cum pot afisa categoriile si subcategoriile in modul asta? Categorie 1 -subcategorie 1 --subcategorie 2 ---subcategorie 3 Categorie 2 |
#2
Posted 27 October 2019 - 20:16
numeri categoriile parinte in forul ala pana dai de 0
foreach($category_recs as $rec) { .... $level = 0; $parent = (int)$rec->parent_id; while($parent !== 0){ $level++; foreach($category_recs as $v){ if((int)$v->id === $parent){ $parent = (int)$v->parent_id; break; } } } $categories[$rec->id] = str_repeat('-', $level) . $rec->name; } mai bine bagi nivelu in baza de date ca sa nu mai iterezi aiurea, ca sigur o sa mai ai nevoie de el Edited by alx42, 27 October 2019 - 20:16. |
#3
Posted 27 October 2019 - 20:49
Cum le pot ordona dupa nume dar subcategoriile sa fie afisate dupa categoria principala?
acum e ceva de genul: categorie -subcategorie ---subcategorie categorie2 ----subcategorie Edited by bunicu9, 27 October 2019 - 20:50. |
#4
Posted 27 October 2019 - 22:06
le iei ordonate din baza de date
ORDER BY parent_id, name ASC daca vrei in php vezi usort(). si tot asa, ordonezi dupa parent_id, apoi dupa name daca au acelasi parent_id |
Anunturi
Bun venit pe Forumul Softpedia!
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users