dynamic breadcrum in php

[sunil rawat]

hi i have a table in database having Module name and module id.and another table having section name crrosponding to each module.now i want to display the bread crums on my page in php.how can i do this.
i am using Url in My application as follows.MyFolder/crm.php?mod=3&sectionID=22&task=queueCont

according to this url i have to create a dynamic class for breadcrums for my application.please help me..

[nathj]

If that URL has all the information in it to retrieve the breadcrumb from the database then it should be a simple task to query the DB to get the page names/titles and then use a horizontal list to display them.

I would recommend developing a small php function that would do jsut that - take the parameters from the url, query the datbase and return the breadcrumb string for display. This function could then be used whereever you need to display the breadcrumb.

Have a play around with that basic flow and if you get stuck with anything in particular post back here including a code snippet.

Cheers
nathj

[sunil rawat]

how to create this function please provide some demo of this.i am confussed

[nathj]

Hi,

I am happy to help you with your own code, I am not going to simlpy provide the code for you. Here is a rough plan of what should happen:

1. pass the variables from the URL query string to a function as parameters.

2. make a database connection

3. query the database using the parameters to get the page and section titles

4. build a string that is the breadcrumb

5. return the string

6. echo the value to the screen.

Now it's over to you, you have a go at developing that. If you get stuck with any specific code post back the code you have and we will do our best to help you out.

Cheers
nathj

[sunil rawat]

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'/bamko3/includes/config.php');
class BreadCRM
{

function getBreadCrum($model_id,$section_id)
{
$sql="select moduleName from bmk3_modules where moduleId=$model_id"
$breadCrum = <<<PATH

<a href="crm.php?mod_id=$model_id">$row['moduleName']</a>
PATH;
$breadCrum .= " &raquo; ";
$sql="select sectionName,parentSection from bmk3_sections where sectionId=$section_id"
$breadCrum .="<a href='crm.php?mod_id=$model_id&section_id=$section _id'>section name</a>";
$parent_id=section parent section from above result

$sql="select sectionName from bmk3_sections where id=$parent_id"
$breadCrum .= "<a href='crm.php?mod_id=$model_id&section_id=$section _id&task=fetch section name'>section name</a>";
return $breadCrum;
}
}
?>

[nathj]

Hi Sunil,

Good to see you have had a crack at this function. DO you have any specific questions about this? If so post back and I'll do my best to answer them for you.

Cheers
nathj