52 lines
2.2 KiB
PHP
Executable File
52 lines
2.2 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
// ---------------------------------------------------
|
|
// Mettre à jour languenav
|
|
// ---------------------------------------------------
|
|
if ($theAff != '' && isset($idLanguenav)) {
|
|
$theAff = rtrim($theAff);
|
|
$theAff = (int)$theAff;
|
|
$idLanguenav = (int)$idLanguenav;
|
|
|
|
$reqUpdate="UPDATE `languenav` SET afficher = :theAff WHERE id = :id ;";
|
|
$stmt = $idPdo->prepare($reqUpdate);
|
|
$resConn = $stmt->execute([
|
|
':theAff' => $theAff,
|
|
':id' => $idLanguenav
|
|
]);
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['QUERY AFF' => $reqUpdate, 'theAff' => $theAff, 'id' => $idLanguenav], 'contenu.reqUpdateLnAff.php');}
|
|
|
|
if ($resConn)
|
|
{ $admMsg .= "Mise à jour de l'affichage " .$idLanguenav. " ok"; $admMsgClass='ok';}
|
|
else
|
|
{ $admMsg .= "Il est impossible de mettre à jour l'affichage " .$idLanguenav. " ."; $admMsgClass='ko';}
|
|
}
|
|
else
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $admMsg .= "theAff ou idLanguenav vide."; $admMsgClass='ko';}
|
|
|
|
// ---------------------------------------------------
|
|
// Cas partculier : menuAccueil (70) est à la fois dans languenav et param...
|
|
// ---------------------------------------------------
|
|
if ($theAff != '' && isset($idLanguenav) && $idLanguenav == 70) {
|
|
$theAff = rtrim($theAff);
|
|
$theAff = (int)$theAff;
|
|
$idLanguenav = (int)$idLanguenav;
|
|
|
|
$reqUpdate="UPDATE `thmParam` SET val = :theAff WHERE idTheme = :idTheme ANd id = :id ;";
|
|
$stmt = $idPdo->prepare($reqUpdate);
|
|
$resConn = $stmt->execute([
|
|
':theAff' => $theAff,
|
|
':id' => '22',
|
|
':idTheme' => $_SESSION['idTheme']
|
|
]);
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['QUERY AFF 2' => $reqUpdate, 'theAff' => $theAff, 'idTheme' => $_SESSION['idTheme'] , 'id' => '22' ], 'contenu.reqUpdateLnAff.php');}
|
|
|
|
if ($resConn)
|
|
{ if (isset($debug[2]) && $debug[2] == '1') $admMsg .= "Mise à jour de l'affichage " .$idLanguenav. " ok"; $admMsgClass='ok';}
|
|
else
|
|
{ $admMsg .= "Il est impossible de mettre à jour l'affichage " .$idLanguenav. " ."; $admMsgClass='ko';}
|
|
}
|
|
else
|
|
if (isset($debug[2]) && $debug[2] == '1' ) { $admMsg .= "theAff ou idLanguenav vide."; $admMsgClass='ko';}
|
|
?>
|