alpha_full/admin/SEO/ref/ref.reqSelect.php
2026-04-06 22:58:51 +02:00

37 lines
1.3 KiB
PHP
Executable File

<?php
$nomFicAppelant = basename(__FILE__);
$tabIdRefMeta=array();
$tabTitleMeta=array();
$tabKeywordsMeta=array();
$tabDescMeta=array();
$tabRobotsMeta=array();
$tabIdPageMeta=array();
$tabPageNameMeta=array();
$tabPageTitle=array();
$reqSelect="SELECT * FROM `referencement` WHERE `language`='" .$dbLG. "' AND pageID=" .$pageID. ";";
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['QUERY select by REF' => $reqSelect, ' lg' => $lg], 'ref.reqSelect.php');}
$resRef=$idPdo->query($reqSelect);
if ($resRef) {
// si la requête a fonctionnée
$b=0;
if ($resConn) {
while($tabRef=$resRef->fetch(PDO::FETCH_ASSOC)) {
$tabIdRefMeta[$b]=$tabRef['idRef'];
$tabTitleMeta[$b]=$tabRef['title'];
$tabKeywordsMeta[$b]=$tabRef['keywords'];
$tabDescMeta[$b]=$tabRef['description'];
$tabRobotsMeta[$b]=$tabRef['robots'];
$tabIdPageMeta[$b]=$tabRef['pageID'];
$tabPageNameMeta[$b]=$tabRef['pageName'];
$tabPageTitle[$b]=$tabRef['pageTitle'];
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['tabIdRefMeta[' => $b, ']=' => $tabIdRefMeta[$b]], '');}
$b++;
}
}
else {
$admMsg .= "Il est impossible de retrouver les données (ref.reqSelect.php). Requete =>" .$reqSelect; $admMsgClass='ko';
}
}
?>