page naviagation

[thoand]

Hi I am trying to create an navigation system using PHP and MySQL.

I want to create new pages with subpages
Like:

-MainCat1(Top level)
-- SubCat1
-- SubCat2
--- SubCat2.1
---- SubCat2.2.1
---- SubCat2.2.2
---- SubCat2.2.3
-- SubCat3

Hope this was understandable 🙂

How can I do design the database here?

regards Thomas A,

[lastuser]

Hi!

It is pretty simple. Just do two table fro Example main_link_naem (id,link_name,main_id) and then create sub_link (id,sub_link_name,sub_id).

Now just when coding pages do tho loops inside. First you searc main_links and the sub_links where sub_id is same than main_id.

If you did not understand ask for more!

[thoand]

But can this go on and on?

Top
sub1
sub2
sub2.1
sub2.2
sub2.3

sub3
sub4

...

[immot]

You don't need two tables to do this. You can make just one table and use id and parent_id columns to build the menu structure. Then you can use recursion in your php-code to extract the data from this table.

Example:

id=1, parent_id=null, text='maincat1'
id=2, parent_id=1, text='subcat1.1'
id=3, parent_id=1, text='subcat1.2'
id=4, parent_id=null, text='maincat2'
id=5, parent_id=2, text='subcat1.1.1'
...

• immot

[thoand]

That was what I started out with

two columns from the table:

pid (auto_increment)
nparent (stores the pid, 0 if toplevel)

but I can't figure out the code yes, please help going insane soon 😉

regards thomas

[immot]

Here's some code you might find useful:

<?php
function printMenu( $parent_id, $db_link )
{
	$links_array = menuData($parent_id, $db_link);
	foreach ($links_array as $key => $var)
	{
		echo "$var[text]<br>";
		printMenu( $var[id], $db_link);
     }
	return;
}

function menuData($parent_id = 0, $db_link)
{
  	$query = "select id, text from YourMenu where parent_id = $parent_id";
	$result = mysql_query($query, $db_link);
     $links_array = array();
	while ($line = mysql_fetch_row($result))
     {
         	$data = array("id"=>$line[0], "text"=>$line[1]);
		array_push($links_array, $data);
	}
	return $links_array;
}


$db_link = mysql_connect("localhost", "user", "passwd");
mysql_select_db("YourDB", $db_link);

printMenu(0, $db_link);

?>

Of course you can add some additional information to the table, like a url.

• immot