29 lines
1.0 KiB
PHP
Executable File
29 lines
1.0 KiB
PHP
Executable File
<?php
|
|
// Préparer la requête avec paramètre sécurisé
|
|
$reqSelect = "SELECT * FROM `calibdyn` WHERE idLg = :lg ORDER BY idLibCa";
|
|
$idTabCaPers = [];
|
|
$libTabCaPers = [];
|
|
$descTabCaPers = [];
|
|
|
|
// echo '<script type="text/javascript">if(document.getElementById(\'lg\')) alert ( \'LG = \' + document.getElementById(\'lg\').value );';
|
|
if (!empty($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug (2, [
|
|
'reqSelect' => $reqSelect,
|
|
'SESSION[lgCouranteCode]' => $_SESSION['lgCouranteCode'],
|
|
'SESSION[lg]' => $_SESSION['lg'],
|
|
'lg' =>$lg
|
|
], 'reqAllCaLib.php'); }
|
|
|
|
$stmt = $idPdo->prepare($reqSelect);
|
|
$stmt->execute([':lg' => $_SESSION['lgCouranteCode']]);
|
|
|
|
if ($stmt->rowCount() > 0) {
|
|
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
|
|
$idTabCaPers[] = $row['idLibCa'];
|
|
$libTabCaPers[] = $row['libelleCaDyn'];
|
|
$descTabCaPers[] = $row['description'];
|
|
}
|
|
} else {
|
|
$admMsg .= "Il est impossible de retrouver les données des libellés dynamiques.";
|
|
$admMsgClass = 'ko';
|
|
}
|
|
?>
|