$rubrique="form"; $rubrique2="calend"; // // Connexion a la base de donnees // include ("../script/admin/connect.php"); $query = "SELECT form.ID, form.type, form.titre, form.titre0, form.titre2, "; $query.= "form.duree, form.facultatif , form.dates, "; $query.= "date.ID, date.type, date.ville, date.date1, date.date2, "; $query.= "date.date3, date.date4, date.date5 "; $query.= " FROM tbl_formation form, tbl_date date"; $query.= " WHERE form.dates = date.ID"; if ($edit=="1") { $query.= " AND (form.publi='prev' OR form.publi='publi')"; $query.= " AND (date.publi='prev' OR date.publi='publi')"; } else { $query.= " AND form.publi='publi'"; $query.= " AND date.publi='publi'"; } $query.= " ORDER BY date1"; $mysql_result = mysql_query($query); $nbFormation = mysql_num_rows($mysql_result); $cpt = 0; while ($cpt < $nbFormation) { // classement des formations mysql_data_seek($mysql_result, $cpt); $row = mysql_fetch_array($mysql_result); $formation_ID[$cpt] = $row["ID"]; $formation_type[$cpt] = $row["type"]; $formation_titre[$cpt] = $row["titre"]; $formation_titre0[$cpt] = $row["titre0"]; $formation_titre2[$cpt] = $row["titre2"]; $formation_duree[$cpt] = $row["duree"]; $formation_facultatif[$cpt] = $row["facultatif"]; $date_ville[$cpt] = $row["ville"]; $date_date[1][$cpt] = date_convert_mysql2classic($row["date1"]); $date_date[2][$cpt] = date_convert_mysql2classic($row["date2"]); $date_date[3][$cpt] = date_convert_mysql2classic($row["date3"]); $date_date[4][$cpt] = date_convert_mysql2classic($row["date4"]); $date_date[5][$cpt] = date_convert_mysql2classic($row["date5"]); $nb_date_date = 5; $cpt2 = 1; while ($cpt2 <= $nb_date_date) { // classement des dates de formation $jour[$cpt2][$cpt] = strtok($date_date[$cpt2][$cpt], "/"); $mois[$cpt2][$cpt] = strtok("/"); $annee[$cpt2][$cpt] = strtok("/"); $cpt2 = $cpt2 + 1; } $cpt = $cpt + 1; } // // Affichage de la page // include ("../script/gab/page.php"); // Affichage des prochaines formations $cpt = 0; while ($cpt < $nbFormation) { // Affichage des formations if (mktime(09,00,00,$mois[1][$cpt],$jour[1][$cpt],$annee[1][$cpt]) > time()) { if (!isset($initTitre)) { $initTitre = ""; print "
Nos prochaines formations
\n"; } print ""; $cpt2 = 1; while ($cpt2 <= $nb_date_date) { // Affichage des dates de formation if ($date_date[$cpt2][$cpt] > 0) { if ($cpt2 > 1) print " - "; print $jour[$cpt2][$cpt] . " "; if (($annee[$cpt2+1][$cpt] != $annee[$cpt2][$cpt]) OR (($date_date[$cpt2+1][$cpt] > 0) AND ($mois[$cpt2][$cpt] != $mois[$cpt2+1][$cpt]))) { print $moisName[intval($mois[$cpt2][$cpt])]; } if (($date_date[$cpt2+1][$cpt] == 0) OR (($annee[$cpt2+1][$cpt] != $annee[$cpt2][$cpt]) AND ($cpt2 != 1))) { print " " . $annee[$cpt2][$cpt]; } } $cpt2 = $cpt2 + 1; } print " : "; if ($formation_titre0[$cpt] != "") print $formation_titre0[$cpt] . " "; ?> print $formation_titre[$cpt] ?> print " " .$formation_titre2[$cpt]; print ".
"; } $cpt = $cpt + 1; } // Affichage des dernieres formations $cpt = 0; while ($cpt < $nbFormation) { // Affichage des formations if (mktime(09,00,00,$mois[1][$cpt],$jour[1][$cpt],$annee[1][$cpt]) <= time()) { if (!isset($initTitre2)) { $initTitre2 = ""; print "Nos dernières formations
\n"; } print ""; $cpt2 = 1; while ($cpt2 <= $nb_date_date) { // Affichage des dates de formation if ($date_date[$cpt2][$cpt] > 0) { if ($cpt2 > 1) print " - "; print $jour[$cpt2][$cpt] . " "; if (($annee[$cpt2+1][$cpt] != $annee[$cpt2][$cpt]) OR (($date_date[$cpt2+1][$cpt] > 0) AND ($mois[$cpt2][$cpt] != $mois[$cpt2+1][$cpt]))) { print $moisName[intval($mois[$cpt2][$cpt])]; } if (($date_date[$cpt2+1][$cpt] == 0) OR (($annee[$cpt2+1][$cpt] != $annee[$cpt2][$cpt]) AND ($cpt2 != 1))) { print " " . $annee[$cpt2][$cpt]; } } $cpt2 = $cpt2 + 1; } print " : "; if ($formation_titre0[$cpt] != "") print $formation_titre0[$cpt] . " "; ?> print $formation_titre[$cpt] ?> print " " .$formation_titre2[$cpt]; print ".
"; } $cpt = $cpt + 1; } print $footPage; ?>