public static function printAnnuaire(){ // connexion à la BD $con = connect_db(); //requete de selection $requete = $con->query(" SELECT CONCAT(personnel.nomsPersonnel,' ',personnel.prenomsPersonnel) AS noms, personnel.tutellePersonnel AS tutelle, personnel.corpsPersonnel AS corps, personnel.gradePersonnel AS grade, personnel.fonctionPersonnel AS fonction, personnel.photoPersonnel AS photo, contact.phone_mtn1 AS mtn1, contact.phone_mtn2 AS mtn2, contact.phone_orange1 AS orange1, contact.phone_orange2 AS orange2, contact.phone_nexttel1 AS nexttel1, contact.phone_nexttel2 AS nexttel2, contact.phone_ctphone AS ctphone, contact.phone_bureau AS bureau, contact.phone_avaya AS avaya, contact.indicatif_er AS indicatif_er, service.libelleService AS libelleService, service.tutelleService AS tutelleService FROM personnel, contact, service WHERE personnel.idPersonnel = contact.idPersonnel AND service.idService = personnel.idService ORDER BY service.tutelleService ASC "); $reports ="