39 ajout_evenement.php
View file
@@ -61,21 +61,21 @@
</div>
<div class="box-body">
<div class="form-group">
<label>Nom de l'événement</label>
<input type="text" class="form-control" value="" placeholder="Nom de l'événement">
</div>
<label>Nom de l'événement</label>
<input type="text" class="form-control" value="" placeholder="Nom de l'événement">
</div>
<div class="form-group">
<label>Lieu de l'événement</label>
<input type="text" class="form-control" value="" placeholder="Lieu de l'événement">
</div>
<label>Lieu de l'événement</label>
<input type="text" class="form-control" value="" placeholder="Lieu de l'événement">
</div>
<div class="form-group">
<label>Description de l'événement (calendrier)</label>
<input type="text" class="form-control" value="" placeholder="Description pour calendrier">
</div>
<label>Description de l'événement (calendrier)</label>
<input type="text" class="form-control" value="" placeholder="Description pour calendrier">
</div>
<div class="form-group">
<label>Lien du site web de l'événement </label>
<input type="text" class="form-control" value="" placeholder="Lien du site web de l'événement">
</div>
<label>Lien du site web de l'événement </label>
<input type="text" class="form-control" value="" placeholder="Lien du site web de l'événement">
</div>
<div class="form-group">
<label>Type d'événement</label>
<select class="form-control select2" style="width: 100%;">
@@ -203,5 +203,20 @@

});
</script>

<script>

var toast = $("#custom-toast");
function show_toast(message){
toast.html(message);
toast.slideToggle().delay(2000).slideToggle();
}

</script>
<?php
if(isset($_GET['message'])){ ?>
<script>show_toast('<?=$_GET['message'];?>');</script>
<?php }
?>
</body>
</html>
164 ajout_programme.php
View file

This file was deleted.

184 gestion_emission.php
View file
@@ -86,54 +86,55 @@
<!-- /.box-tools -->
</div>
<!-- /.box-header -->
<div class="box-body">
<div class="row">
<div class="col-md-4">
<div class="box box-purple">
<div class="box-header with-border">
<h3 class="box-title">Info article</h3>
</div>
<div class="box-body">
<label>Titre de l'article</label>
<input type="text" class="form-control" value="" placeholder="Titre de l'article">
<br>
<div class="form-group">
<label>Tags (optionnels)</label>
<select class="form-control select2" multiple="multiple" data-placeholder="Ajouter un tag" style="width: 100%;">
<?php
foreach($tags as $tag){ ?>
<option value="<?=$tag['id_tag'];?>"><?=$tag['lib_tag'];?></option>
<?php }
?>
</select>
</div>
<div class="form-group">
<label for="exampleInputFile">Mettre une image de couverture (optionnel)</label>
<input type="file" id="exampleInputFile">
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
<div class="box-footer">
<button type="submit" class="btn btn-primary">Envoyer</button>
</div>
</div>
<div class="col-md-8">
<div class="box">
<div class="box-header">
<h3 class="box-title">Rédiger l'article</h3>
</div>
<!-- /.box-header -->
<div class="box-body pad">
<form role="form">
<textarea class="textarea" placeholder="Rédiger l'article" style="width: 100%; height: 500px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</form>
</div>
</div>
</div>
</div>
<form method="post" action="traitements/add_article_emission.php" enctype="multipart/form-data">
<div class="box-body">
<div class="row">
<div class="col-md-4">
<div class="box box-purple">
<div class="box-header with-border">
<h3 class="box-title">Info article</h3>
</div>
<div class="box-body">
<label>Titre de l'article</label>
<input name="titre" type="text" class="form-control" value="" placeholder="Titre de l'article">
<br>
<div class="form-group">
<label>Tags (optionnels)</label>
<select class="form-control select2" name="tags[]" multiple="multiple" data-placeholder="Ajouter un tag" style="width: 100%;">
<?php
foreach($tags as $tag){ ?>
<option value="<?=$tag['id_tag'];?>"><?=$tag['lib_tag'];?></option>
<?php }
?>
</select>
</div>
<div class="form-group">
<label for="exampleInputFile">Mettre une image de couverture (optionnel)</label>
<input name="image" type="file" id="exampleInputFile">
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
<div class="box-footer">
<button type="submit" class="btn btn-primary">Envoyer</button>
</div>
</div>
<div class="col-md-8">
<div class="box">
<div class="box-header">
<h3 class="box-title">Rédiger l'article</h3>
</div>
<!-- /.box-header -->
<div class="box-body pad">
<textarea name="contenu" class="textarea" placeholder="Rédiger l'article" style="width: 100%; height: 500px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
</div>
</div>
</div>
<input style="display:none;" name='emission' value="<?=$id;?>"/>
</form>
<!-- /.box-body -->
</div>
<!-- /.box -->
@@ -156,22 +157,23 @@
<!-- /.box-header -->
<div class="box-body">
<div class="row">
<form method="post" action="traitements/add_podcast_emission.php" enctype="multipart/form-data">
<div class="col-md-4">
<div class="box box-purple">
<div class="box-header with-border">
<h3 class="box-title">Info podcast</h3>
</div>
<div class="box-body">
<label>Titre du podcast </label>
<input type="text" class="form-control" value="" placeholder="Titre du podcast">
<input name="titre" type="text" class="form-control" value="" placeholder="Titre du podcast">
<br>
<div class="form-group">
<label for="exampleInputFile">Podcast </label>
<input type="file" id="exampleInputFile">
<input name="podcast" type="file" id="exampleInputFile">
</div>
<div class="form-group">
<label>Tags (optionnels)</label>
<select class="form-control select2" multiple="multiple" data-placeholder="Ajouter un tag" style="width: 100%;">
<select name="tags[]" class="form-control select2" multiple="multiple" data-placeholder="Ajouter un tag" style="width: 100%;">
<?php
foreach($tags as $tag){ ?>
<option value="<?=$tag['id_tag'];?>"><?=$tag['lib_tag'];?></option>
@@ -181,7 +183,7 @@
</div>
<div class="form-group">
<label for="exampleInputFile">Insérer une image de présentation (optionnel)</label>
<input type="file" id="exampleInputFile">
<input name="image" type="file" id="exampleInputFile">
</div>
</div>
<!-- /.box-body -->
@@ -198,12 +200,12 @@
</div>
<!-- /.box-header -->
<div class="box-body pad">
<form role="form">
<textarea class="textarea" placeholder="Contenu du podcast" style="width: 100%; height: 500px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
<textarea name="contenu" class="textarea" placeholder="Contenu du podcast" style="width: 100%; height: 500px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</form>
</div>
</div>
<input style="display:none;" name='emission' value="<?=$id;?>"/>
</form>
</div>
</div>
<!-- /.box-body -->
@@ -215,6 +217,7 @@
<br>

<div class="row">
<form method="post" action="traitements/edit_emission.php" enctype="multipart/form-data">
<div class="col-md-6 col-lg-6 col-xs-6">
<div class="box box-primary">
<div class="box-header with-border">
@@ -224,47 +227,48 @@
<div class="form-group">
<div class="form-group">
<label>Nom de l'émission</label>
<input type="text" class="form-control" value="<?php echo $titre ?>" placeholder="<?php echo $titre ?>">
<input name="titre" type="text" class="form-control" value="<?php echo $titre ?>" placeholder="<?php echo $titre ?>">
</div>
</div>
<br>
<div class="form-group">
<label for="exampleInputFile">Modifier image de couverture</label>
<input type="file" id="exampleInputFile">
<input name="image" type="file" id="exampleInputFile">
</div>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">Programmation émission</h3>
</div>
<div class="box-body">
<div class="form-group">
<label>Début du programme</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control pull-left" id="horaire_debut">
</div><!-- /.input group -->
<br>
<label>Fin du programme</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control pull-left" id="horaire_fin">
</div><!-- /.input group -->
</div><!-- /.form group -->

</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary">Ajouter</button>
</div>
<!-- /.box-body -->
</div>
<!-- OSEF -->
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">Programmation émission</h3>
</div>
<div class="box-body">
<div class="form-group">
<label>Début du programme</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control pull-left" id="horaire_debut">
</div><!-- /.input group -->
<br>
<label>Fin du programme</label>
<div class="input-group">
<div class="input-group-addon">
<i class="fa fa-clock-o"></i>
</div>
<input type="text" class="form-control pull-left" id="horaire_fin">
</div><!-- /.input group -->
</div><!-- /.form group -->
<!-- FIN OSEF -->
</div>
<div class="box-footer">
<button type="submit" class="btn btn-primary">Ajouter</button>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<div class="col-md-6">
@@ -274,15 +278,15 @@
</div>
<!-- /.box-header -->
<div class="box-body pad">
<form role="form">
<textarea class="textarea" placeholder="Rédiger l'article" style="width: 100%; height: 500px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"><?php echo $description; ?></textarea>
<textarea name="description" class="textarea" placeholder="Rédiger l'article" style="width: 100%; height: 500px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"><?php echo $description; ?></textarea>
</div>
<div class="box-footer">
<button type="submit" data-toggle="tooltip" title="De toute façon ça marche pô là" class="btn btn-primary disabled">Modifier</button>
<button type="submit" class="btn btn-primary">Modifier</button>
</div>
</form>
</div>
</div>
<input style="display:none;" name='emission' value="<?=$id;?>"/>
</form>
</div>
<br>
<br>
10 traitements/add_article.php
View file
@@ -1,5 +1,5 @@
<?php
include "../../includes/database.php";
include "../includes/database.php";
if(isset($_POST['titre']) && isset($_POST['contenu']) && isset($_POST['categorie'])){

$titre = $_POST['titre'];
@@ -13,7 +13,7 @@
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 2000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../../ajout_article.php?message=Erreur lors de l'ajout");
header("Location: ../ajout_article.php?message=Erreur lors de l'ajout");
} else {
$sql = "INSERT INTO articles (date_article, titre_article, contenu_article, categ_article) VALUES (NOW(),?,?,?)";
$req = $db->prepare($sql);
@@ -30,15 +30,15 @@
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 2000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../../ajout_article.php?message=Erreur lors de l'ajout");
header("Location: ../ajout_article.php?message=Erreur lors de l'ajout");
} else {

$sql = "SELECT MAX(id_article) as max FROM articles";
$req = $db->query($sql)->fetch(PDO::FETCH_ASSOC);
$id = $req['max'];

$chemin_front = "img/article/".$id.".".$extension_upload;
$chemin = "../../../RadioPac/img/article/".$id.".".$extension_upload;
$chemin = "../../RadioPac/img/article/".$id.".".$extension_upload;

move_uploaded_file($_FILES['image']['tmp_name'],$chemin);

@@ -61,7 +61,7 @@
$req->execute(array($tag,$id));
}
}
header("Location: ../../ajout_article.php?message=Ajout avec success");
header("Location: ../ajout_article.php?message=Ajout avec success");
}

} else {
70 traitements/add_article_emission.php
View file
@@ -0,0 +1,70 @@
<?php
include "../includes/database.php";
if(isset($_POST['titre']) && isset($_POST['contenu']) && isset($_POST['emission'])){

$titre = $_POST['titre'];
$contenu = $_POST['contenu'];
$emission = $_POST['emission'];

if($titre != "" && $contenu != "" && $emission != ""){

if(isset($_FILES['image']) && $_FILES['image']['size'] > 0){
$extensions_valides = array( 'jpg' , 'jpeg' , 'png' );
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 2000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout&id=$emission");
} else {
$sql = "INSERT INTO articles (date_article, titre_article, contenu_article,id_emission) VALUES (NOW(),?,?,?)";
$req = $db->prepare($sql);
$req->execute(array($titre,$contenu,$emission));
}
} else {
$sql = "INSERT INTO articles (date_article, titre_article, contenu_article, id_emission) VALUES (NOW(),?,?,?)";
$req = $db->prepare($sql);
$req->execute(array($titre,$contenu,$emission));
}

if(isset($_FILES['image']) && $_FILES['image']['size'] > 0){
$extensions_valides = array( 'jpg' , 'jpeg' , 'png' );
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 2000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout&id=$emission");
} else {

$sql = "SELECT MAX(id_article) as max FROM articles";
$req = $db->query($sql)->fetch(PDO::FETCH_ASSOC);
$id = $req['max'];

$chemin_front = "img/article/".$id.".".$extension_upload;
$chemin = "../../RadioPac/img/article/".$id.".".$extension_upload;

move_uploaded_file($_FILES['image']['tmp_name'],$chemin);

$sql = "UPDATE articles SET photo_article = '$chemin_front' WHERE id_article = $id";
$req = $db->prepare($sql);
$req->execute();
}
}
if(isset($_POST['tags']) && $_POST['tags'] != null){

$tags = $_POST['tags'];

$sql = "SELECT MAX(id_article) as max FROM articles";
$req = $db->query($sql)->fetch(PDO::FETCH_ASSOC);
$id = $req['max'];

$sql = "INSERT INTO tag_article (id_tag, id_article) VALUES(?,?)";
$req = $db->prepare($sql);
foreach($tags as $tag){
$req->execute(array($tag,$id));
}
}
header("Location: ../gestion_emission.php?message=Ajout avec success&id=$emission");
}

} else {
echo "Erreur lors de l'ajout";
}
?>
44 traitements/add_emission.php
View file
@@ -0,0 +1,44 @@
<?php
include "../includes/database.php";

var_dump($_POST);
var_dump($_FILES);

if(isset($_POST['titre']) && isset($_POST['description'])){
$titre = $_POST['titre'];
$description = $_POST['description'];

if(isset($_FILES['image']) && $_FILES['image']['size'] > 0){
$extensions_valides = array( 'jpg' , 'jpeg' , 'png' );
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 2000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../ajout_emission.php?message=Erreur lors de l'ajout");
} else {

$sql = "INSERT INTO emissions (titre_emission, descri_emission) VALUES (?,?)";
$req = $db->prepare($sql);
$req->execute(array($titre,$description));

$sql = "SELECT MAX(id_emission) as max FROM emissions";
$req = $db->query($sql)->fetch(PDO::FETCH_ASSOC);
$id = $req['max'];

$chemin_front = "img/emission/".$id.".".$extension_upload;
$chemin = "../../RadioPac/img/emission/".$id.".".$extension_upload;

move_uploaded_file($_FILES['image']['tmp_name'],$chemin);

$sql = "UPDATE emissions SET photo_emission = '$chemin_front' WHERE id_emission = $id";
$req = $db->prepare($sql);
$req->execute();

header("Location: ../ajout_emission.php?message=Ajouté avec succes");
}
} else {
header("Location: ../ajout_emission.php?message=Erreur lors de l'ajout");
}

}

?>
83 traitements/add_podcast_emission.php
View file
@@ -0,0 +1,83 @@
<?php
include "../includes/database.php";
if(isset($_POST['titre']) && isset($_POST['contenu']) && isset($_POST['emission'])){

$titre = $_POST['titre'];
$contenu = $_POST['contenu'];
$emission = $_POST['emission'];

var_dump($_POST);
var_dump($_FILES);

if(isset($_FILES['podcast']) && $_FILES['podcast']['size'] > 0){

$extensions_valides = array('mp3');
$extension_upload = strtolower(substr(strrchr($_FILES['podcast']['name'], '.'),1));

if ($_FILES['podcast']['error'] > 0 || $_FILES['podcast']['size'] > 30000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout4&id=$emission");
} else {

$sql = "INSERT INTO podcasts (emission_podcast, titre_podcast, descri_podcast, date_podcast) VALUES (?,?,?,NOW())";
$req = $db->prepare($sql);
$req->execute(array($emission,$titre,$contenu));

$sql = "SELECT MAX(id_podcast) as max FROM podcasts";
$req = $db->query($sql)->fetch(PDO::FETCH_ASSOC);
$id = $req['max'];

$chemin = "../../RadioPac/podcasts/".$emission."/".$id.".".$extension_upload;
$chemin_front = "podcasts/".$emission."/".$id.".".$extension_upload;

move_uploaded_file($_FILES['podcast']['tmp_name'],$chemin);

$sql = "UPDATE podcasts SET chemin_podcast = '$chemin_front' WHERE id_podcast = $id";
$req = $db->prepare($sql);
$req->execute();

if(isset($_FILES['image']) && $_FILES['image']['size'] > 0){

$extensions_valides = array( 'jpg' , 'jpeg' , 'png' );
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 5000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout3&id=$emission");
} else {

$chemin = "../../RadioPac/img/podcasts/".$id.".".$extension_upload;
$chemin_front = "img/podcasts/".$id.".".$extension_upload;

move_uploaded_file($_FILES['image']['tmp_name'],$chemin);

$sql = "UPDATE podcasts SET photo_podcast = '$chemin_front' WHERE id_podcast = $id";
$req = $db->prepare($sql);
$req->execute();

}
}

if(isset($_POST['tags']) && $_POST['tags'] != null){

$tags = $_POST['tags'];

$sql = "INSERT INTO tag_podcast (id_tag, id_podcast) VALUES(?,?)";
$req = $db->prepare($sql);
foreach($tags as $tag){
$req->execute(array($tag,$id));
}
}

header("Location: ../gestion_emission.php?message=Ajout avec success&id=$emission");

}

} else {
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout2&id=$emission");
}

} else {

header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout1&id=$emission");
}

?>
35 traitements/edit_emission.php
View file
@@ -0,0 +1,35 @@
<?php
include "../includes/database.php";

if(isset($_POST['titre']) && isset($_POST['description']) && isset($_POST['emission'])){

$titre = $_POST['titre'];
$description = $_POST['description'];
$emission = $_POST['emission'];

$sql = "UPDATE emissions SET titre_emission = '$titre', descri_emission = '$description' WHERE id_emission = $emission";
$req = $db->prepare($sql);
$req->execute();

if(isset($_FILES['image']) && $_FILES['image']['size'] > 0){
$extensions_valides = array( 'jpg' , 'jpeg' , 'png' );
$extension_upload = strtolower(substr(strrchr($_FILES['image']['name'], '.'),1));

if ($_FILES['image']['error'] > 0 || $_FILES['image']['size'] > 5000000 || !in_array($extension_upload,$extensions_valides)){
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout3&id=$emission");
} else {
$chemin = "../../RadioPac/img/emission/".$emission.".".$extension_upload;

move_uploaded_file($_FILES['image']['tmp_name'],$chemin);
header("Location: ../gestion_emission.php?message=Edité avec succes3&id=$emission");
}
}

} else {
header("Location: ../gestion_emission.php?message=Erreur lors de l'ajout3&id=$emission");
}




?>