how to code breadcrumbs (php kohana framework)?

is this good way to code breadcrumbs?

1. cr开发者_如何学运维eate table "categories" using mysql
2. create after neccessary columns "parent_id" column
3. if parent_id column have null value it means that this category is parent and if else this columns parent is a column with id which marked in "parent_id" column
4. recursively query to "parent_id" column starting at current column and print category name.

---

Breadcrumbs are easier if you use other methods of storing hierarchical data.

See my presentation Models for Hierarchical Data with SQL and PHP for examples of alternatives:

• Path Enumeration
• Nested Sets
• Closure Table

---

You want to check out Modified Preorder Tree Traversal modules

• Sprig MPTT github.com/banks/sprig-mptt
• Jelly MPTT github.com/AlexKupreev/jelly-mptt
• v3 ORM MPTT github.com/kiall/kohana3-orm_mptt
• v2 ORM MPTT dev.kohanaframework.org/projects/mptt