You-are-here site navigation ...

[Anon]

Hello!!!

I have a tree database structured and I use this function below to get a "you-are-here" site navigation model.

eg:

http://Home > http://Sports > http://Soccer

function get_category_tree($id=0) {
/* returns a tree of the categories, starting from the top to the
 * category specified by $id */

$qid = mysql_query("SELECT parent_id, name FROM categories WHERE id = $id");
if ($qid) {
	list($parent, $name) = mysql_fetch_row($qid);
	$name = "<a href=catteste.php?id=$id>$name</a>";
} else {
	$parent = 1;
	$name = "";
}

if ($parent > 1) {
	return print_category_tree($parent) . ": " . $name;

} elseif ($id > 1) {
	return "<a href=catteste.php>Home</a>: " . $name;

} elseif ($id == 0) {
	return "<a href=catteste.php>Home</a>";
}
}

It works perfectly but I would like that the current category haven't a link and the you-are-here should must be thus:

http://Home > http://Sports > Soccer

Any ideas ???

Best Regards,

marcoBR

btw: sorry 4 my english ...

[Anon]

Here is some code that I use. It does not print a bread crumb trail, but rather returns the complete trail as a string.

Note how it works:

1. It uses the specified $id to get the necessary data from the database.

2. It compares the current context ($roomid) to the specified $id. IF they match, THEN the string is set to the retrieved title (without a hypertext anchor); ELSE (no match) a linkset is constructed from the title and a URL mask and the result is prepended -- glued to the BEGINNING of the bread crumb trail.

3. If the parent id is not zero, the function calls itself with the parent ID as an argument.

This assumes that an object with a parent id of 0 is a root object.

Basically what we're doing here is building the bread crumb trail from right to left. When we're done, we will be able to print it (left to right, naturally):

echo breadcrumbs($roomid);

Here is the function definition:

function breadcrumbs($id)
{
global $roomid; // current context
global $db; // database handle
global $prattle_rooms; // table name
global $breadcrumbtrail; // string we build
$result = mysql_db_query($db, "select * from $prattle_rooms where
roomid='$id'");
$room = mysql_fetch_object($result);
if ($id == $roomid)
$breadcrumbtrail = $room->title;
else
$breadcrumbtrail = "<a href=\"prattle.php?roomid=$room->roomid\">$room->title</a> > $breadcrumbtrail";

    if ($room->roomparent) breadcrumbs($room->roomparent);

    return $breadcrumbtrail;
    }