36 lines
1.6 KiB
PHP
Executable File
36 lines
1.6 KiB
PHP
Executable File
<?php
|
|
// -----------------------------------------------------
|
|
// Requete libelle dynamique
|
|
// -----------------------------------------------------
|
|
// $reqUpdate="UPDATE `calibdyn` SET ";
|
|
// $reqUpdate .= "libelleCaDyn='" .$nomLibelle. "', ";
|
|
// $reqUpdate .= "description='" .$desc. "' ";
|
|
// $reqUpdate .= " WHERE idLibCa=" .$idCaPers. " and idlg='" .$_SESSION['lgCouranteCode']. "' ;";
|
|
// $resConn=$idPdo->query($reqUpdate);
|
|
|
|
$reqUpdate="UPDATE `calibdyn` SET libelleCaDyn=:nomLibelle, description=:desc WHERE idLibCa=:idCaPers AND idlg=:idlg;";
|
|
$stmt = $idPdo->prepare($reqUpdate);
|
|
$stmt->execute([
|
|
':nomLibelle' => $nomLibelle,
|
|
':desc' => $desc,
|
|
':idCaPers' => $idCaPers,
|
|
':idlg' => $_SESSION['lgCouranteCode']
|
|
]);
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1' ) {
|
|
$reqUpdateDebug=$reqUpdate;
|
|
$reqUpdateDebug=str_replace(':nomLibelle', '\''.$nomLibelle.'\'', $reqUpdateDebug);
|
|
$reqUpdateDebug=str_replace(':desc', '\''.$desc.'\'', $reqUpdateDebug);
|
|
$reqUpdateDebug=str_replace(':idCaPers', $idCaPers, $reqUpdateDebug);
|
|
$reqUpdateDebug=str_replace(':idlg', '\''.$_SESSION['lgCouranteCode'].'\'', $reqUpdateDebug);
|
|
$debugMsg .= monDebug (5, ['reqUpdate' => $reqUpdateDebug], 'reqUpdateLibDyn.php');
|
|
}
|
|
|
|
if ($stmt->execute()) {
|
|
$admMsg .= "Mise à jour du libellé personalisé pour " .$_SESSION['lgCouranteLibelle']. " effectuée avec succès !<br>"; $admMsgClass='ok';
|
|
}
|
|
else
|
|
{$admMsg .= "Echec de la mise à jour du libellé personnalisé pour " .$_SESSION['lgCouranteLibelle']. "."; $admMsgClass='ko';
|
|
$erreurSQL=1;
|
|
}
|
|
?>
|