kreoton web development

$menu = array(
	'Home' => $base.'/',
	'Videos' => array (
		'_link' => $base.'/videos/',
		'_submenu' => array (
			'Categories' => array (
				'_link' => $base.'/videos/categories',
				'_submenu' => array (
					'Fun videos' => $base.'/videos/categories/fun_videos',
					'Home videos' => $base.'/videos/categories/home_videos',
				),
			),
			'Popular' => $base.'/videos/popular',
			'Best rated' => $base.'/videos/best-rated',
		),
	),
	'Articles' => array (
		'_link' => $base.'/articles',
		'_submenu' => array (
			'Newest' => $base.'/articles/newest',
			'Archive' => $base.'/articles/archive',
		),
	),
	'Contact Us'=> $base.'/contact_us'
);

$base = 'http://www.example.com';

function formatMenu ($menu)
{
	// check if given segment is array if not there is nothing to do
	if (!is_array($menu))
		return false;
	//opening base url formating element ul if you like you can applay here style you use for your menu
	$html = '<ul>';
 
	//now we must format each array element
	foreach ($menu as $item => $link)
	{
		//how you see every element witch has submenu has property _link witch hold link base of page section and
		// property _submenu holds submenu links
		if ($item != '_link')
		{
			$html .= '<li>';
			//if element is array, it is a submenu too :)
			if (is_array($link))
			{
				if ($item != '_submenu')
					$html .= '<a href="'.$link['_link'].'">'.$item.'</a>';
				//colling same function where we are (recursive)
				$html .= formatMenu($link['_submenu']);
			}
			else
				$html .= '<a href="'.$link.'">'.$item.'</a>';
			$html .= '</li>';
		}
	}
 
	$html .= '</ul>';
	// at the end we close all opened tags and return what this function has made
	return $html;
}

echo formatMenu ($menu);

CREATE TABLE `menu` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) collate latin1_general_ci NOT NULL,
  `link` varchar(255) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`)
);
 
INSERT INTO `menu` (`id`, `parent_id`, `title`, `link`) VALUES 
(1, 0, 'Home', '/'),
(2, 0, 'Videos', '/videos/'),
(3, 2, 'Categories', '/videos/categories/'),
(4, 3, 'Fun Videos', '/videos/categories/fun_videos'),
(5, 3, 'Home videos', '/videos/categories/home_videos'),
(6, 2, 'Popular', '/videos/popular'),
(7, 2, 'Best rated', '/videos/best_rated'),
(8, 0, 'Articles', '/articles/'),
(9, 8, 'Newest', '/articles/newest'),
(10, 8, 'Archive', '/articles/archive'),
(11, 0, 'Contact us', '/contact_us');

$link = false;
global $link; //we should define to avoid establish new connection when one is open
 
function getRows ($sql)
{
	global $link;
	if ($link == false)
	{
		$link = mysql_connect('localhost', 'root', '') or die(mysql_error());
		mysql_select_db('test', $link) or die(mysql_error());
	}
 
	$res = mysql_query($sql) or die(mysql_error());
	if (mysql_num_rows($res) > 0)
	{
		while ($row = mysql_fetch_assoc($res))
		{
			$data[] = $row;
		}
	}
 
	return $data;
}

function formatSQLMenu ($parent = 0)
{
	//execute query witch will return us part of our menu
	$menu = getRows("SELECT * FROM menu WHERE parent_id = ".(int)$parent);
	if (!is_array($menu))
		return false;
 
	$html = '<ul>';
 
	foreach ($menu as $item)
	{
		$html .= '<li>';
		$html .= '<a href="'.$item['link'].'">'.$item['title'].'</a>';
		//colling same function where we are (recursive) to check if menu item has submenu
		$html .= formatSQLMenu($item['id']);
		$html .= '</li>';
	}
 
	$html .= '</ul>';
	return $html;
}