$rubrique="form"; $rubrique2="prog"; // // Connexion a la base de donnees // include ("../../script/admin/connect.php"); // Initialisation de la variable 'id' if (isset($_GET['id'])) $id = $_GET['id']; elseif (isset($_POST['id'])) $id = $_POST['id']; elseif (!isset($id)) $id = "1"; $query = "SELECT *"; $query.= " FROM tbl_formation"; $query.= " WHERE ID = '$id'"; if ($edit=="1") $query.= " AND (publi='prev' OR publi='publi')"; elseif ($edit!="2") $query.= " AND publi='publi'"; $mysql_result = mysql_query($query); $nbFormation = mysql_num_rows($mysql_result); if ($nbFormation < 1) { $query = "SELECT * FROM tbl_formation"; if ($edit=="1") $query.= " WHERE publi='prev' OR publi='publi'"; elseif ($edit!="2") $query.= " WHERE publi='publi'"; $query.= " ORDER BY ID"; $mysql_result = mysql_query($query); } $cpt = 0; mysql_data_seek($mysql_result, $cpt); $row = mysql_fetch_array($mysql_result); $formation_ID = $row["ID"]; $formation_type = $row["type"]; $formation_titre = $row["titre"]; $formation_titre0 = $row["titre0"]; $formation_titre2 = $row["titre2"]; $formation_soustitre = $row["soustitre"]; $formation_duree = $row["duree"]; $formation_objectif = $row["objectif"]; $formation_public = $row["public"]; $formation_requis = $row["requis"]; $formation_programme = $row["programme"]; $formation_programme2 = $row["programme2"]; $formation_pedago = $row["pedago"]; $formation_nombre = $row["nombre"]; $formation_dossier = $row["dossier"]; $formation_facultatif = $row["facultatif"]; $formation_date = $row["dates"]; $query = "SELECT *"; $query.= " FROM tbl_date"; $query.= " WHERE ID = '$formation_date'"; if ($edit=="1") $query.= " AND (publi='prev' OR publi='publi')"; elseif ($edit!="2") $query.= " AND publi='publi'"; $query.= " ORDER BY date1"; $mysql_result = mysql_query($query); $nbDate = mysql_num_rows($mysql_result); if ($nbDate > 0) { mysql_data_seek($mysql_result, $cpt); $row = mysql_fetch_array($mysql_result); $date_ID = $row["ID"]; $date_ville = $row["ville"]; $date_commentaire = $row["commentaire"]; $date_tarif = $row["tarif"]; $date_lieu = $row["lieu"]; $date_date[1] = date_convert_mysql2classic($row["date1"]); $date_date[2] = date_convert_mysql2classic($row["date2"]); $date_date[3] = date_convert_mysql2classic($row["date3"]); $date_date[4] = date_convert_mysql2classic($row["date4"]); $date_date[5] = date_convert_mysql2classic($row["date5"]); $nb_date_date = 5; $cpt2 = 1; while ($cpt2 <= $nb_date_date) { // classement des dates de formation $jour[$cpt2] = strtok($date_date[$cpt2], "/"); $mois[$cpt2] = strtok("/"); $annee[$cpt2] = strtok("/"); $cpt2 = $cpt2 + 1; } } // // Affichage de la page // if (!isset($formation_type)) $formation_type="manuel"; $rubriqueOW = $formation_type; include ("../../script/gab/ow.php"); ?>
if ($formation_titre0 != "") print $formation_titre0 . " "; print $formation_titre . " " . $formation_titre2; if ($formation_duree > 0) { print " (" . $formation_duree . " "; if ($formation_duree > 1) { print "jours"; } else { print "jour"; } if ($formation_facultatif > 0) { print " + " . $formation_duree . " "; if ($formation_facultatif > 1) { print "jours"; } else { print "jour"; } } print ")"; } ?>
Objectifs
print $formation_objectif;
?>
Public
if ($formation_requis!="") print "et pré-requis";
?>
print $formation_public;
if ($formation_requis!="") print "
" . $formation_requis;
?>
Programme
if ($formation_programme2!="") print "Jour 1
";
print $formation_programme;
?>
Environnement pédagogique
print $formation_pedago;
if ($formation_nombre > 0) {
print "
Nombre maximum de stagiaires : " . $formation_nombre;
}
if ($formation_dossier != "") {
print "
\nDossier stagiaire : " . $formation_dossier;
}
?>
Dates . Lieux d'ouverture. Inscriptions
Les séminaires ont lieu à
print $date_ville . " " . $date_lieu;
if ($date_date[1] > 0) {
if (mktime(09,00,00,$mois[1],$jour[1],$annee[1]) > time()) {
if ($date_date[2] > 0) {
print " aux dates suivantes : ";
} elseif ($date_date[1] > 0) {
print " à la date suivante : ";
}
print "";
$cpt2 = 1; // Affichage des dates de formation
while ($cpt2 <= $nb_date_date) {
if ($date_date[$cpt2] > 0) {
if ($cpt2 > 1) print " - ";
print $jour[$cpt2] . " ";
if (($annee[$cpt2+1] != $annee[$cpt2]) OR
(($date_date[$cpt2+1] > 0) AND ($mois[$cpt2] != $mois[$cpt2+1]))) {
print $moisName[intval($mois[$cpt2])];
}
if (($date_date[$cpt2+1] == 0) OR
(($annee[$cpt2+1] != $annee[$cpt2]) AND ($cpt2 != 1))) {
print " " . $annee[$cpt2];
}
}
$cpt2 = $cpt2 + 1;
}
print "";
} else {
print ". Dates de formations à venir.";
}
}
print "
" . $date_commentaire;
?>
Tarif : "; print $date_tarif; print " €TTC par personne"; if ($formation_facultatif != "") print " et par jour"; print "
"; } } print $footPage; ?>