echo_debug_itop("{$sql}<br />"); $res_ele = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res_ele) > 0) { $temoin_eleve_associe = "y"; $cpt_ele = 0; while ($lig_ele = mysqli_fetch_object($res_ele)) { if ($cpt_ele > 0) { echo "<br />"; } echo $lig_ele->nom . " " . $lig_ele->prenom; $tab_classe = get_class_from_ele_login($lig_ele->login); if (isset($tab_classe['liste_nbsp'])) { echo " (<em>" . $tab_classe['liste_nbsp'] . "</em>)"; } $sql = "SELECT rp.*, r.resp_legal FROM resp_pers rp, responsables2 r WHERE r.pers_id=rp.pers_id AND r.ele_id='{$lig_ele->ele_id}' AND rp.nom='" . mysqli_real_escape_string($GLOBALS["mysqli"], $nom_courant) . "' AND rp.prenom='" . mysqli_real_escape_string($GLOBALS["mysqli"], $prenom_courant) . "' AND rp.login!='';"; echo_debug_itop("{$sql}<br />"); $res_resp = mysqli_query($GLOBALS["mysqli"], $sql); if (mysqli_num_rows($res_resp) > 0) { while ($lig_resp = mysqli_fetch_object($res_resp)) { if (!in_array($lig_resp->login, $tab_resp_login)) { $tab_resp_login[] = $lig_resp->login; $tab_resp[$cpt_resp]['login'] = $lig_resp->login; $tab_resp[$cpt_resp]['civilite'] = $lig_resp->civilite; $tab_resp[$cpt_resp]['nom'] = $lig_resp->nom; $tab_resp[$cpt_resp]['prenom'] = $lig_resp->prenom; $tab_resp[$cpt_resp]['resp_legal'] = $lig_resp->resp_legal; $tab_resp[$cpt_resp]['info'] = $lig_resp->civilite . " " . casse_mot($lig_resp->nom, 'maj') . " " . casse_mot($lig_resp->prenom, 'majf2'); $tab_resp[$cpt_resp]['info'] .= " (N° " . $lig_resp->pers_id . ")"; $tab_resp[$cpt_resp]['info'] .= " (Légal " . $lig_resp->resp_legal . ")"; $cpt_resp++; }
// Si la chaine est vide, proposer un champ TEXT if($chaine!="") { $sql="SELECT e.* FROM eleves e, sso_table_correspondance s WHERE ($chaine) AND e.login=s.login_gepi ORDER BY e.nom, e.prenom;"; echo_debug_itop("$sql<br />"); $res_ele=mysqli_query($GLOBALS["mysqli"], $sql); if(mysqli_num_rows($res_ele)>0) { $temoin_eleve_associe="y"; $cpt_ele=0; while($lig_ele=mysqli_fetch_object($res_ele)) { if($cpt_ele>0) {echo "<br />";} echo $lig_ele->nom." ".$lig_ele->prenom; $tab_classe=get_class_from_ele_login($lig_ele->login); if(isset($tab_classe['liste_nbsp'])) {echo " (<em>".$tab_classe['liste_nbsp']."</em>)";} $sql="SELECT rp.*, r.resp_legal FROM resp_pers rp, responsables2 r WHERE r.pers_id=rp.pers_id AND r.ele_id='$lig_ele->ele_id' AND rp.nom='".mysqli_real_escape_string($GLOBALS["mysqli"], $nom_courant)."' AND rp.prenom='".mysqli_real_escape_string($GLOBALS["mysqli"], $prenom_courant)."' AND rp.login!='';"; echo_debug_itop("$sql<br />"); $res_resp=mysqli_query($GLOBALS["mysqli"], $sql); if(mysqli_num_rows($res_resp)>0) { while($lig_resp=mysqli_fetch_object($res_resp)) { if(!in_array($lig_resp->login, $tab_resp_login)) { $tab_resp_login[]=$lig_resp->login; $tab_resp[$cpt_resp]['login']=$lig_resp->login; $tab_resp[$cpt_resp]['civilite']=$lig_resp->civilite; $tab_resp[$cpt_resp]['nom']=$lig_resp->nom; $tab_resp[$cpt_resp]['prenom']=$lig_resp->prenom; $tab_resp[$cpt_resp]['resp_legal']=$lig_resp->resp_legal; $tab_resp[$cpt_resp]['info']=$lig_resp->civilite." ".casse_mot($lig_resp->nom,'maj')." ".casse_mot($lig_resp->prenom,'majf2'); $tab_resp[$cpt_resp]['info'].=" (N° ".$lig_resp->pers_id.")"; $tab_resp[$cpt_resp]['info'].=" (Légal ".$lig_resp->resp_legal.")"; $cpt_resp++;