<?php
	if (!isset($refresh)) $refresh='N';
	if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['refresh' => $refresh],  '20-init.referencement.php');	}
	if (empty($_SESSION['refTitle']) or ($refresh==='Oui')) {
		$i=0;
		$reqSelect="SELECT * FROM `referencement` WHERE language='" .$isoLang. "' ";
		$resConn='';
		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (2, ['reqSelect' => $reqSelect],  '');	}
		$resConn=$idPdo->query($reqSelect);
		if ($resConn) {
			while ($tabResult = $resConn->fetch(PDO::FETCH_ASSOC)) {

				$refTitle[$i]=$tabResult['pageTitle'];
				$refMetaTitle[$i]=$tabResult['title'];
				$rerefMetaKeyWords[$i]=$tabResult['keywords'];
				$refMetaDesc[$i]=$tabResult['description'];
				$refMetaRobots[$i]=$tabResult['robots'];
				$refMetaLastUpdate[$i]=$tabResult['lastUpdated'];
				$refMetaLanguage[$i]=$tabResult['language'];
				$refMetaPageID[$i]=$tabResult['pageID'];
				$refMetaPageName[$i]=$tabResult['pageName'];
				if (isset($debug[10]) && $debug[10] == '1' ) {
				$debugMsg .= monDebug (1, [
					"refMetaTitle[$i]"   => $refMetaTitle[$i],
					"refMetaPageID[$i]"  => $refMetaPageID[$i],
					"refMetaDesc[$i]"    => $refMetaDesc[$i] ],
					'');
				}
				$i++;
			}
			$_SESSION['refTitle']= $refTitle;
			$_SESSION['refMetaTitle']= $refMetaTitle;
			$_SESSION['rerefMetaKeyWords']= $rerefMetaKeyWords;
			$_SESSION['refMetaDesc']= $refMetaDesc;
			$_SESSION['refMetaRobots']= $refMetaRobots;
			$_SESSION['refMetaLastUpdate']= $refMetaLastUpdate;
			$_SESSION['refMetaLanguage']= $refMetaLanguage;
			$_SESSION['refMetaPageID']= $refMetaPageID;
			$_SESSION['refMetaPageName']= $refMetaPageName;
			$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'],'');}
		$refTitle=$_SESSION['refTitle'];
		$refMetaTitle=$_SESSION['refMetaTitle'];
		$rerefMetaKeyWords=$_SESSION['rerefMetaKeyWords'];
		$refMetaDesc=$_SESSION['refMetaDesc'];
		$refMetaRobots=$_SESSION['refMetaRobots'];
		$refMetaLastUpdate=$_SESSION['refMetaLastUpdate'];
		$refMetaLanguage=$_SESSION['refMetaLanguage'];
		$refMetaPageID=$_SESSION['refMetaPageID'];
		$refMetaPageName=$_SESSION['refMetaPageName'];
	}
?>