60 lines
2.4 KiB
PHP
Executable File
60 lines
2.4 KiB
PHP
Executable File
<?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 " 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'];
|
|
}
|
|
?>
|