<?php
	if (!isset($refresh)) $refresh='N';
	if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['refresh' => $refresh],  '05-init.navMsgList.php');	}
	if (empty($_SESSION['navMsg']) or ($refresh==='Oui')) {	
		$i=0;
		$reqSelect="SELECT * FROM languenav WHERE variable='nav' order by id;";
		$resConn=$idPdo->query($reqSelect);
		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['reqSelect' => $reqSelect], '');}
		$navStyle=array();
		if ($resConn) {
			while ($tabResult = $resConn->fetch(PDO::FETCH_ASSOC)) {
				$navID[$i]=$tabResult['id'];
				$navDesc[$i]=$tabResult['description'];
				$navAfficher[$i]=$tabResult['afficher'];
				$navMsg[$i]=$tabResult[$lg];
				$navTitle[$i]=$tabResult['title' .$lg];
				$navAlt[$i]=$tabResult['alt' .$lg];
				$navLien[$i]=$tabResult['lien'];
				$navImgPt[$i]=$tabResult['imgPt' .$lg];
				$navClasse[$i]=$tabResult['class'];
				$navStyle[$i]=$tabResult['style'];
				if (isset($debug[14]) && $debug[14] == '1' )	$debugMsg .= monDebug (1,['num' => $i , 'navID' => $navID[$i], 'navDesc' => $navDesc[$i], 'navAfficher' => $navAfficher[$i], 'navMsg' => $navMsg[$i] ],'');
				$i++;
			}

			$_SESSION['navID']= $navID;
			$_SESSION['navDesc']= $navDesc;
			$_SESSION['navAfficher']= $navAfficher;
			$_SESSION['navMsg']= $navMsg;
			$_SESSION['navTitle']= $navTitle;
			$_SESSION['navAlt']= $navAlt;
			$_SESSION['navImgPt']= $navImgPt;
			$_SESSION['navLien']= $navLien;			
			$_SESSION['navClasse']= $navClasse;
			$_SESSION['navStyle']= $navStyle;
			$tabResult='';
			if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session re-chargée' => 'Oui'],'');}
		}
		else {
			echo "&#160;Impossible de récupérer les données de la table";
		}
	}
	else {
		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session déjà chargée' => 'Oui'],'');}
		$navID=$_SESSION['navID'];
		$navDesc=$_SESSION['navDesc'];
		$navAfficher=$_SESSION['navAfficher'];			
		$navMsg=$_SESSION['navMsg'];
		$navTitle=$_SESSION['navTitle'];
		$navAlt=$_SESSION['navAlt'];
		$navImgPt=$_SESSION['navImgPt'];
		$navLien=$_SESSION['navLien'];
		$navClasse=$_SESSION['navClasse'];
		$navStyle=$_SESSION['navStyle'];
	}
?>