Geen tekst in beeld

<?
error_reporting(E_ALL); 
class clsHoofdMenuList 
{
	var $m_nID;
	var $m_sTekst;
	var $m_sSubMenuTitel;
		
	// Contructor
	function __construct() 
	{
		$this->m_nID = 0;
		$this->m_sTekst = "";
		$this->m_sSubMenuTitel = "";

	}	
	public function loadTekstSubMenu($p_nID,$p_sSubMenuTitel) 
	{
		$objDB = clsDBSingleton::Instantiate();
		
		$this->m_sTekst = "";
		$this->m_nID = $p_nID;
		$this->m_sSubMenuTitel = $p_sSubMenuTitel;
		$sSQL = "SELECT tekst from submenu where menuid=\"" .$p_nID . "\" and titel=\"" . $p_sSubMenuTitel . "\"";
		try 
		{			echo "{sql}$sSQL{/sql}";

			if ($objDB->executeSQL($sSQL)) 
			{			
				if (!$objDB->eof()) 
				{
					$rs = $objDB->fetchArray();
					$this->m_sTekst	= $rs["tekst"];
				}
				$this->m_sTekst = $this->m_sTekst;
				$objDB->dbClose();
			}
		} 
		catch (Exception $e) 
		{
			// iets ging fout, database exception
			throw new Exception ("clsHoofdMenuList::loadTekstSubMenu\n".$e->getMessage(), $e->getCode());
		}
		  return $this->m_sTekst;
	}
}?>

<?
error_reporting(E_ALL); 
class clsHoofdMenuList 
{
	var $m_nID;
	var $m_sTekst;
	var $m_sSubMenuTitel;
 
	// Contructor
	function __construct() 
	{
		$this->m_nID = 0;
		$this->m_sTekst = "";
		$this->m_sSubMenuTitel = "";
 
	}	
	public function loadTekstSubMenu($p_nID,$p_sSubMenuTitel) 
	{
		$objDB = clsDBSingleton::Instantiate();
 
		$this->m_sTekst = "";
		$this->m_nID = $p_nID;
		$this->m_sSubMenuTitel = $p_sSubMenuTitel;
		$sSQL = "SELECT tekst from submenu where menuid=\"" .$p_nID . "\" and titel=\"" . $p_sSubMenuTitel . "\"";
		try 
		{			echo "{sql}$sSQL{/sql}";
 
			if ($objDB->executeSQL($sSQL)) 
			{			
				if (!$objDB->eof()) 
				{
					$rs = $objDB->fetchArray();
					$this->m_sTekst	= $rs["tekst"];
				}
				$this->m_sTekst = $this->m_sTekst;
				$objDB->dbClose();
			}
		} 
		catch (Exception $e) 
		{
			// iets ging fout, database exception
			throw new Exception ("clsHoofdMenuList::loadTekstSubMenu\n".$e->getMessage(), $e->getCode());
		}
		  return $this->m_sTekst;
	}
}?>

<?echo "<a href=submenu.php?page=5&module=blaat>Testertje</a>";?>

<?echo "<a href=submenu.php?page=5&module=blaat>Testertje</a>";?>

<?if(isset($_GET["page"]))
{
	if($_GET['page'])
	{
		if(isset($_GET["module"]))
		{
			if($_GET["module"])
			{
				try 
				{
					$objMenuList = new clsHoofdMenuList(); 
					$sloadTekstSubMenu = $objMenuList->loadTekstSubMenu($_GET['page'],$_GET["module"]); 
					echo $sloadTekstSubMenu["tekst"];
				}
				catch (Exception $e) 
				{
					$e->getMessage();
					$e->getCode();
				}
						
			}
		}
	}
}?>

<?if(isset($_GET["page"]))
{
	if($_GET['page'])
	{
		if(isset($_GET["module"]))
		{
			if($_GET["module"])
			{
				try 
				{
					$objMenuList = new clsHoofdMenuList(); 
					$sloadTekstSubMenu = $objMenuList->loadTekstSubMenu($_GET['page'],$_GET["module"]); 
					echo $sloadTekstSubMenu["tekst"];
				}
				catch (Exception $e) 
				{
					$e->getMessage();
					$e->getCode();
				}
 
			}
		}
	}
}?>

<?return $this->m_sTekst?>

<?return $this->m_sTekst?>

<? echo $this->m_sTekst;?>

<? echo $this->m_sTekst;?>