尝试使用PHP和MySQL获取节点的路径

I'm trying to build a breadcrumb here and I'm having some trouble doing it. The problem arises from the fact that I have to save category name (in two languages), slug and id.

我正在尝试在这里建立一个面包屑,我在做这件事时遇到了一些麻烦。问题源于我必须保存类别名称(两种语言),slug和id。

My categories table looks like this:

我的类别表如下所示:

CREATE TABLE `categories` (
 `category_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 `category_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `category_slug` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `category_parent` smallint(5) unsigned NOT NULL DEFAULT '0',
 `category_description_ro` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 `category_description_en` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1

Bellow is an example of data in the table:

贝娄是表中数据的一个例子:

category id | category name | category_parent

1            Categoria 1            0        
2            Categoria 2            0        
3            Categoria 3            0        
4            Categoria 1.1          1        
5            Categoria 1.2          1        
6            Categoria 1.3          1        
7            Categoria 1.1.2        4

I have to mention that I can not make any change to the MySQL table.

我必须提到我无法对MySQL表做任何更改。

What I would like to accomplish is to build a breadcrumb like:

我想要完成的是建立一个像以下一样的面包屑:

Home > Categoria 1 > Categoria 1.1 > Categoria 1.1.2

首页>分类1>分类1.1>分类1.1.2

Can anyone provide a small piece of code on how to do this? I already tried that "the path to a node" code from here, but, as I said, I have to include in that array category_name, category_slug, category_description_ro and category_description_en. Thanks in advance guys.

任何人都可以提供一小段代码来解决这个问题吗?我已经从这里尝试了“节点的路径”代码,但是,正如我所说,我必须在该数组中包含category_name,category_slug,category_description_ro和category_description_en。先谢谢你们。

2 个解决方案

#1

In pseudo-code:

$currentID = 7;
do{
    $category = getCategoryByID($currentID);
    $currentID = $category['category_parent'];

    $crumb .= $category['category_name'];
}while($category['category_parent']);

This will just loop back up the category tree, building the crumb until there are no more parents.

这将只是循环备份类别树,构建面包屑,直到没有更多的父母。

2 个解决方案

#1

更多相关文章

随机推荐