query($query6); $Correction = array(); while ($recordinfo = $adb->fetch_array($sql_get_result6)) { $Correction[] = $recordinfo; } $nbr=1; for ($xa = 0; $xa < sizeof($tableau); $xa++) { $index=$tableau[$xa]; $final=$nbr."- ".html_entity_decode($Correction[0][strtolower($index)]); array_push($stack,$final); $nbr=$nbr+1; } $result=implode("
",$stack); }else{$result="";} return $result; } function getContenuLibelleQCM($userId,$heure){ global $adb; //pour affichier la contenu de liste deroulante selon le reseau de candidat et la date debut/fin + heure debut/fin Examen $query3 ="SELECT res_id FROM `vtiger_users` WHERE id=".$userId." "; $result3 = $adb->query($query3); $reseau[] =$adb->fetch_array($result3); $reseau=$reseau[0]['res_id']; if($roleid =="H2"){$var="";}else{$var=" and reseau like '%{$reseau}%'";} $query = "SELECT * FROM `ent_qcm` where date_debut <= ? and date_fin >= ? and heure_debut <= ? and heure_fin > ? ".$var.""; $resultt = $adb->pquery($query, array(date('Y-m-d'),date('Y-m-d'),$heure,$heure)); $libelle = array(); while ($recordinfo = $adb->fetch_array($resultt)) { $libelles[] = $recordinfo; } return $libelles; } function getAllLignesEaxmen($idExamen){ global $adb; $query = "SELECT * FROM `lignes_qcm` where code_ent_qcm= ? ORDER BY ordre ASC;"; $result = $adb->pquery($query, array($idExamen)); $question = array(); while ($recordinfo = $adb->fetch_array($result)) { $questions[] = $recordinfo; } return $questions; } function getExamenInformations($idExamen){ global $adb; //requete pour timer $query5 = "SELECT * FROM `ent_qcm` where code_qcm = '".$idExamen."'"; $result5 =$adb->query($query5); while ($recordinfo = $adb->fetch_array($result5)) { $ExamenInformations[] = $recordinfo; } return $ExamenInformations; } function result($question){ echo ' '.$question['ordre'].' '.html_entity_decode($question['question']).' '; if(strlen($question['correction']) == 6){ echo' '; if ($question['choix1'] != null) echo ' '.html_entity_decode($question['choix1']).' '; if ($question['choix2'] != null) echo ' '.html_entity_decode($question['choix2']).' '; if ($question['choix3'] != null) echo ' '.html_entity_decode($question['choix3']).' '; if ($question['choix4'] != null) echo ' '.html_entity_decode($question['choix4']).' '; if ($question['choix5'] != null) echo ' '.html_entity_decode($question['choix5']).' '; echo ' '; }else{ echo ' '; if ($question['choix1'] != null) echo ' '; if ($question['choix2'] != null) echo ' '; if ($question['choix3'] != null) echo ' '; if ($question['choix4'] != null) echo ' '; if ($question['choix5'] != null) echo ' '; echo '

	'.html_entity_decode($question['choix1']).'
	'.html_entity_decode($question['choix2']).'
	'.html_entity_decode($question['choix3']).'
	'.html_entity_decode($question['choix4']).'
	'.html_entity_decode($question['choix5']).'

'; } echo' '; } //le candidat passe un examen un seul fois function getIdPassage($idExamen,$userId){ global $adb; $queryy = "SELECT * FROM `passage_qcm_ent` where code_ent_qcm= ? and candidat= ?"; $resultt = $adb->pquery($queryy, array($idExamen,$userId)); $ids[] = $adb->fetch_array($resultt); $_SESSION["id_passage_qcm"] =$ids[0]['code_passage_qcm']; } function getPassageInformations($idExamen,$userId){ global $adb; $queryy = "SELECT * FROM `passage_qcm_ent` where candidat= '".$userId."' and code_ent_qcm='".$idExamen."'"; $sql_get_resultt = $adb->query($queryy); while ($recordinfo = $adb->fetch_array($sql_get_resultt)) { $PassageInformations[] = $recordinfo; } return $PassageInformations; } ?>