$tab_select_semaine[$d]["type_semaine"] = old_mysql_result($req_semaine, $d, "type_edt_semaine"); echo "<option value='" . $tab_select_semaine[$d]["id_semaine"] . "'>Semaine n° " . $tab_select_semaine[$d]["num_semaine"] . " (" . $tab_select_semaine[$d]["type_semaine"] . ") : " . $tab_select_semaine[$d]["lundis"] . " - " . $tab_select_semaine[$d]["vendredis"] . " </option>\n"; } echo "</select>\n<br />\n<em><font size=\"2\"> * champs obligatoires </font></em>\n"; echo "<input type=\"submit\" name=\"Valider\" value=\"Valider\" />\n<br />\n"; echo "</form>\n"; } if ($auto_aff_2 === 1) { // On reprend les infos sur les horaires demandés $requete_creneaux = mysqli_query($GLOBALS["mysqli"], "SELECT nom_definie_periode, heuredebut_definie_periode, heurefin_definie_periode FROM edt_creneaux WHERE id_definie_periode = '" . $ch_heure . "'"); $reponse_tab_creneaux = mysqli_fetch_array($requete_creneaux); echo "<fieldset>\n<legend>Résultats</legend>\n"; echo "Les salles libres le <font color=\"green\">" . $ch_jour_semaine . "</font> de <font color=\"green\">" . $reponse_tab_creneaux["heuredebut_definie_periode"] . " à " . $reponse_tab_creneaux["heurefin_definie_periode"] . " ( " . $reponse_tab_creneaux["nom_definie_periode"] . " )</font> sont :\n"; echo "<br />\n"; // On cherche les identifiants des salles où l'EdT est vide $salles_libres = aff_salles_vides($ch_heure, $ch_jour_semaine); // On affiche le nom des salles vides foreach ($salles_libres as $tab_salib) { if (nom_salle($tab_salib) == '') { echo "" . numero_salle($tab_salib) . "<br />\n"; } else { echo "" . nom_salle($tab_salib) . "<br />\n"; } } echo "</fieldset>\n"; } echo '</div>'; ?> <div class="cleared"></div> <!-- /article-content -->
/* choix de la semaine $req_semaine = mysql_query("SELECT * FROM edt_semaines"); $rep_semaine = mysql_fetch_array($req_semaine); echo '<SELECT name="semaine">'; echo ('<OPTION value=\'rien\'>Semaine</OPTION>'); $tab_select_semaine = array(); for($d=0;$d<52;$d++) { $tab_select_semaine[$d]["id_semaine"] = old_mysql_result($req_semaine, $d, "id_edt_semaine"); $tab_select_semaine[$d]["num_semaine"] = old_mysql_result($req_semaine, $d, "num_edt_semaine"); $tab_select_semaine[$d]["type_semaine"] = old_mysql_result($req_semaine, $d, "type_edt_semaine"); echo ('<OPTION value=\''.$tab_select_semaine[$d]["id_semaine"].'\'>Semaine n° '.$tab_select_semaine[$d]["num_semaine"].' ('.$tab_select_semaine[$d]["type_semaine"].') </OPTION>'); } echo '</SELECT>';*/ echo ' <input type="submit" name="Valider" value="Valider" /> <br /> <br /> </form> '; } if ($auto_aff_2 === 1) { $salles_libres = aff_salles_vides($_GET["ch_heure"], $_GET["ch_jour_semaine"]); for ($s = 0; $s < count($salles_libres); $s++) { echo "{$salles_libres[$s]}.'<br />'"; } }