1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| function SqlCa_code_a ($data) {
$SqlQuerry = '';
$SqlWhere = 'WHERE ca.suppr = 0 ';
$Param = array();
if (is_int($id_gcode)) {
$SqlWhere .= ' AND ca.id_groupe = :id_groupe ';
$Param[':id_groupe'] = $id_gcode;
}
$SqlQuerry .= ' SELECT ca.code,ca.intitule_code ';
$SqlQuerry .= ' FROM table_ca ca ';
$SqlQuerry .= $SqlWhere;
try {
$db = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$Qry = $db->prepare($SqlQuerry);
$Qry->execute($Param);
$Result = $Qry->fetchAll();
$rows = $Qry->rowCount();
$Qry->closeCursor();
return ['nb_ligne' => $rows,
'ca_codes' => $Result];
} catch (PDOException $e) {
echo "Echec de la connexion : " . $e->getMessage();
exit;
}
} |
Partager