2024-06-16 15:02:27 +02:00
|
|
|
<!DOCTYPE html>
|
|
|
|
|
<html lang="fr">
|
|
|
|
|
<head>
|
|
|
|
|
<meta charset="utf-8">
|
|
|
|
|
<link rel="icon" href="../img/jo2024.jpg">
|
|
|
|
|
<link rel="stylesheet" href="../css/style.css">
|
|
|
|
|
<title>Création évènement - Jeux Olympiques</title>
|
|
|
|
|
</head>
|
|
|
|
|
<body>
|
|
|
|
|
|
|
|
|
|
<?php
|
|
|
|
|
|
|
|
|
|
// Informations de connexion à la base de données
|
|
|
|
|
require_once 'common.php';
|
|
|
|
|
session_start();
|
|
|
|
|
$db = initDatabase();
|
|
|
|
|
|
|
|
|
|
if (!empty($_POST['nom'])) {
|
|
|
|
|
|
|
|
|
|
// Utiliser htmlspecialchars pour échapper les caractères spéciaux
|
|
|
|
|
$nom = htmlspecialchars($_POST['nom'], ENT_QUOTES, 'UTF-8');
|
|
|
|
|
$sport = htmlspecialchars($_POST['sport'], ENT_QUOTES, 'UTF-8');
|
|
|
|
|
$lieu = htmlspecialchars($_POST['lieu'], ENT_QUOTES, 'UTF-8');
|
|
|
|
|
$date = htmlspecialchars($_POST['date'], ENT_QUOTES, 'UTF-8');
|
|
|
|
|
$description = htmlspecialchars($_POST['description'], ENT_QUOTES, 'UTF-8');
|
|
|
|
|
|
|
|
|
|
// Récupérer le dernier ID et calculer le nouvel ID
|
|
|
|
|
$recupid = mysqli_query($db, "SELECT MAX(id) AS max_id FROM evenement");
|
|
|
|
|
$row = mysqli_fetch_assoc($recupid);
|
|
|
|
|
$id = $row['max_id'] + 1;
|
|
|
|
|
|
|
|
|
|
// Préparer la requête SQL
|
|
|
|
|
$stmt = mysqli_prepare($db, "INSERT INTO evenement (id, nom, sport, lieux, date, description, nbinscrit) VALUES (?, ?, ?, ?, ?, ?, ?)");
|
|
|
|
|
|
|
|
|
|
// Vérifier si la requête a été préparée avec succès
|
|
|
|
|
if ($stmt === false) {
|
|
|
|
|
die("Erreur de préparation de la requête : " . mysqli_error($db));
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// Lier les paramètres à la requête préparée
|
|
|
|
|
$statut = 0; // Valeur par défaut pour le statut
|
|
|
|
|
mysqli_stmt_bind_param($stmt, 'isssssi', $id, $nom, $sport, $lieu, $date, $description, $statut);
|
|
|
|
|
|
|
|
|
|
// Exécuter la requête
|
|
|
|
|
if (mysqli_stmt_execute($stmt)) {
|
|
|
|
|
header('Location: evenement.php');
|
|
|
|
|
exit();
|
|
|
|
|
} else {
|
|
|
|
|
die("Erreur d'exécution de la requête : " . mysqli_stmt_error($stmt));
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// Fermer la requête
|
|
|
|
|
mysqli_stmt_close($stmt);
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
// Fermer la connexion
|
|
|
|
|
mysqli_close($db);
|
|
|
|
|
|
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
<header>
|
|
|
|
|
<h1 class='Hello'> Page de création d'évènement </h1>
|
|
|
|
|
<nav>
|
|
|
|
|
<?php
|
|
|
|
|
if (isset($_SESSION['login'])) {
|
|
|
|
|
echo "<a href='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/' class='categorie'>Page d'accueil</a>";
|
|
|
|
|
echo "<a href='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/php/profil.php'><img class='profil' src='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/img/photo-profil.png' alt='profil'></a>";
|
|
|
|
|
echo "<a href='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/php/.php' class='categorie'>Déconnexion</a>";
|
|
|
|
|
} else {
|
|
|
|
|
echo "<a href='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/' class='categorie'>Page d'accueil</a>";
|
|
|
|
|
echo "<a href='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/php/connexion.php' class='categorie'>Connexion</a>";
|
|
|
|
|
echo "<a href='https://dwarves.iut-fbleau.fr/~ghouar-t/SaeDEV2.2/php/inscription.php' class='categorie'>Inscription</a>";
|
|
|
|
|
}
|
|
|
|
|
?>
|
|
|
|
|
</nav>
|
|
|
|
|
</header>
|
|
|
|
|
|
|
|
|
|
<div class="inscription" id="inscription">
|
2024-06-16 17:58:12 +02:00
|
|
|
<u><i><h2>Création évènements</h2></i></u><br>
|
2024-06-16 15:02:27 +02:00
|
|
|
<form action="" method="post">
|
2024-06-16 17:58:12 +02:00
|
|
|
<label for="nom">Nom évènement :</label><br>
|
2024-06-16 15:02:27 +02:00
|
|
|
<input type="text" id="nom" name="nom" required><br><br>
|
|
|
|
|
<label for="sport">Sport :</label><br>
|
|
|
|
|
<input type="text" id="sport" name="sport" required><br><br>
|
|
|
|
|
<label for="lieu">Lieu :</label><br>
|
|
|
|
|
<input type="text" id="lieu" name="lieu" required><br><br>
|
|
|
|
|
<label for="date">Date :</label><br>
|
|
|
|
|
<input type="date" id="date" name="date" required><br><br>
|
|
|
|
|
<label for="description">Description :</label><br>
|
|
|
|
|
<input type="text" id="description" name="description" required><br><br>
|
|
|
|
|
<button type="submit" class="submit">Créer un évènement</button>
|
|
|
|
|
</form>
|
|
|
|
|
</div>
|
|
|
|
|
|
|
|
|
|
<footer>
|
|
|
|
|
<?php require_once('footer.php'); ?>
|
|
|
|
|
</footer>
|
|
|
|
|
|
|
|
|
|
</body>
|
|
|
|
|
</html>
|
