1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
|
<?php
require_once('../inc/functions.php');
require_once('../inc/bdd.php');
//FONCTION QUI VERIFIE QUE LA SESSION DOIT BIEN ETRE OUVERTE en verifiant qu'elle ne soit pas deja demarrer
logged_only();
;
//Appel la fonction pour rechercher tous les articles
$articles = getArticles();
//$message='';
debug($_FILES);
// Vérification si des données obligatoires ont été postées pour l'enregistrement d'un article
if(isset($_POST['upload']))
{
//Mise en place des variables : Vérification si les données ne sont pas vide
if(!empty($_POST['categories_id']))
{
$titre = htmlspecialchars($_POST['titre']);
$page = htmlspecialchars($_POST['page']);
// $titreCache = htmlspecialchars($_POST['titreCache']);
$titreCache = isset($_POST['titreCache']) ? $_POST['titreCache'] : NULL;
$auteur = htmlspecialchars($_POST['auteur']);
$contenu = ($_POST['contenu']);
// $categories_id = htmlspecialchars($_POST['categories_id']);
$categories_id = isset($_POST['categories_id']) ? $_POST['categories_id'] : NULL;
// $nom_categorie = htmlspecialchars($_POST['nomCategorie']);
$nom_categorie = isset($_POST['nom_categorie']) ? $_POST['nom_categorie'] : NULL;
$page = ($_POST['page']);
$lienSiteWeb1 = ($_POST['lienSiteWeb1']);
$lienSiteWeb1_legende = ($_POST['lienSiteWeb1_legende']);
$lienSiteWeb2 = ($_POST['lienSiteWeb2']);
$lienSiteWeb2_legende = ($_POST['lienSiteWeb2_legende']);
$photo = ($_FILES['photo']['name']);
$miniature = isset($_FILES['miniature']['name']) ? $_FILES['miniature']['name'] : NULL;
$photo_legende = ($_POST['photo_legende']);
$photo_lienPdf = isset($_FILES['photo_lienPdf']['name']) ? $_FILES['photo_lienPdf']['name'] : NULL;
$photo_lienPdf = isset($_POST['photo_lienPdf']) ? $_POST['photo_lienPdf'] : NULL;
$fichierTempo = ($_FILES['photo']['tmp_name']);
$fichierTempoMiniature = isset($_FILES['miniature']['tmp_name']) ? $_FILES['miniature']['tmp_name'] : NULL;
// $fichierTempo_photo_lienPdf = ($_FILES['photo_lienPdf']['tmp_name']);
// $fichierTempo_photo_lienPdf = isset($_FILES['photo_lienPdf']['tmp_name']) ? $_FILES['photo_lienPdf']['tmp_name'] : NULL;
$pdf1 = isset($_FILES['pdf1']['name']) ? $_FILES['pdf1']['name'] : NULL;
$pdf1_legende = ($_POST['pdf1_legende']);
$fichierTempoPdf1 = isset($_FILES['pdf1']['tmp_name']) ? $_FILES['pdf1']['tmp_name'] : NULL;
$pdf2 = isset($_FILES['pdf2']['name']) ? $_FILES['pdf2']['name'] : NULL;
$pdf2_legende = ($_POST['pdf2_legende']);
$fichierTempoPdf2 = isset($_FILES['pdf2']['tmp_name']) ? $_FILES['pdf2']['tmp_name'] : NULL;
$pdf3 = isset($_FILES['pdf3']['name']) ? $_FILES['pdf3']['name'] : NULL;
$pdf3_legende = ($_POST['pdf3_legende']);
$fichierTempoPdf3 = isset($_FILES['pdf3']['tmp_name']) ? $_FILES['pdf3']['tmp_name'] : NULL;
$pdf4 = isset($_FILES['pdf4']['name']) ? $_FILES['pdf4']['name'] : NULL;
$pdf4_legende = ($_POST['pdf4_legende']);
$fichierTempoPdf4 = isset($_FILES['pdf4']['tmp_name']) ? $_FILES['pdf4']['tmp_name'] : NULL;
$pdf5 = isset($_FILES['pdf5']['name']) ? $_FILES['pdf5']['name'] : NULL;
$pdf5_legende = ($_POST['pdf5_legende']);
$fichierTempoPdf5 = isset($_FILES['pdf5']['tmp_name']) ? $_FILES['pdf5']['tmp_name'] : NULL;
$pdf6 = isset($_FILES['pdf6']['name']) ? $_FILES['pdf6']['name'] : NULL;
$pdf6_legende = ($_POST['pdf6_legende']);
$fichierTempoPdf6 = isset($_FILES['pdf6']['tmp_name']) ? $_FILES['pdf6']['tmp_name'] : NULL;
$pdf7 = isset($_FILES['pdf7']['name']) ? $_FILES['pdf7']['name'] : NULL;
$pdf7_legende = ($_POST['pdf7_legende']);
$fichierTempoPdf7 = isset($_FILES['pdf7']['tmp_name']) ? $_FILES['pdf7']['tmp_name'] : NULL;
$pdf8 = isset($_FILES['pdf8']['name']) ? $_FILES['pdf8']['name'] : NULL;
$pdf8_legende = ($_POST['pdf8_legende']);
$fichierTempoPdf8 = isset($_FILES['pdf8']['tmp_name']) ? $_FILES['pdf8']['tmp_name'] : NULL;
$pdf9 = isset($_FILES['pdf9']['name']) ? $_FILES['pdf9']['name'] : NULL;
$pdf9_legende = ($_POST['pdf9_legende']);
$fichierTempoPdf9 = isset($_FILES['pdf9']['tmp_name']) ? $_FILES['pdf9']['tmp_name'] : NULL;
$pdf10 = isset($_FILES['pdf10']['name']) ? $_FILES['pdf10']['name'] : NULL;
$pdf10_legende = ($_POST['pdf10_legende']);
$fichierTempoPdf10 = isset($_FILES['pdf10']['tmp_name']) ? $_FILES['pdf10']['tmp_name'] : NULL;
$pdf10 = isset($_FILES['pdf10']['name']) ? $_FILES['pdf10']['name'] : NULL;
$pdf10_legende = ($_POST['pdf10_legende']);
$fichierTempoPdf10 = isset($_FILES['pdf10']['tmp_name']) ? $_FILES['pdf10']['tmp_name'] : NULL;
$pdf11 = isset($_FILES['pdf11']['name']) ? $_FILES['pdf11']['name'] : NULL;
$pdf11_legende = ($_POST['pdf11_legende']);
$fichierTempoPdf11 = isset($_FILES['pdf11']['tmp_name']) ? $_FILES['pdf11']['tmp_name'] : NULL;
$pdf12 = isset($_FILES['pdf12']['name']) ? $_FILES['pdf12']['name'] : NULL;
$pdf12_legende = ($_POST['pdf12_legende']);
$fichierTempoPdf12 = isset($_FILES['pdf12']['tmp_name']) ? $_FILES['pdf12']['tmp_name'] : NULL;
$pdf13 = isset($_FILES['pdf13']['name']) ? $_FILES['pdf13']['name'] : NULL;
$pdf13_legende = ($_POST['pdf13_legende']);
$fichierTempoPdf13 = isset($_FILES['pdf13']['tmp_name']) ? $_FILES['pdf13']['tmp_name'] : NULL;
$pdf14 = isset($_FILES['pdf14']['name']) ? $_FILES['pdf14']['name'] : NULL;
$pdf14_legende = ($_POST['pdf14_legende']);
$fichierTempoPdf14 = isset($_FILES['pdf14']['tmp_name']) ? $_FILES['pdf14']['tmp_name'] : NULL;
$pdf15 = isset($_FILES['pdf15']['name']) ? $_FILES['pdf15']['name'] : NULL;
$pdf15_legende = ($_POST['pdf15_legende']);
$fichierTempoPdf15 = isset($_FILES['pdf15']['tmp_name']) ? $_FILES['pdf15']['tmp_name'] : NULL;
$pdf16 = isset($_FILES['pdf16']['name']) ? $_FILES['pdf16']['name'] : NULL;
$pdf16_legende = ($_POST['pdf16_legende']);
$fichierTempoPdf16 = isset($_FILES['pdf16']['tmp_name']) ? $_FILES['pdf16']['tmp_name'] : NULL;
$pdf17 = isset($_FILES['pdf17']['name']) ? $_FILES['pdf17']['name'] : NULL;
$pdf17_legende = ($_POST['pdf17_legende']);
$fichierTempoPdf17 = isset($_FILES['pdf17']['tmp_name']) ? $_FILES['pdf17']['tmp_name'] : NULL;
$pdf18 = isset($_FILES['pdf18']['name']) ? $_FILES['pdf18']['name'] : NULL;
$pdf18_legende = ($_POST['pdf18_legende']);
$fichierTempoPdf18 = isset($_FILES['pdf18']['tmp_name']) ? $_FILES['pdf18']['tmp_name'] : NULL;
$pdf19 = isset($_FILES['pdf19']['name']) ? $_FILES['pdf19']['name'] : NULL;
$pdf19_legende = ($_POST['pdf19_legende']);
$fichierTempoPdf19 = isset($_FILES['pdf19']['tmp_name']) ? $_FILES['pdf19']['tmp_name'] : NULL;
$pdf20 = isset($_FILES['pdf20']['name']) ? $_FILES['pdf20']['name'] : NULL;
$pdf20_legende = ($_POST['pdf20_legende']);
$fichierTempoPdf20 = isset($_FILES['pdf20']['tmp_name']) ? $_FILES['pdf20']['tmp_name'] : NULL;
$pdf21 = isset($_FILES['pdf21']['name']) ? $_FILES['pdf21']['name'] : NULL;
$pdf21_legende = ($_POST['pdf21_legende']);
$fichierTempoPdf21 = isset($_FILES['pdf21']['tmp_name']) ? $_FILES['pdf21']['tmp_name'] : NULL;
$pdf22 = isset($_FILES['pdf22']['name']) ? $_FILES['pdf22']['name'] : NULL;
$pdf22_legende = ($_POST['pdf22_legende']);
$fichierTempoPdf22 = isset($_FILES['pdf22']['tmp_name']) ? $_FILES['pdf22']['tmp_name'] : NULL;
$pdf23 = isset($_FILES['pdf23']['name']) ? $_FILES['pdf23']['name'] : NULL;
$pdf23_legende = ($_POST['pdf23_legende']);
$fichierTempoPdf23 = isset($_FILES['pdf23']['tmp_name']) ? $_FILES['pdf23']['tmp_name'] : NULL;
$pdf24 = isset($_FILES['pdf24']['name']) ? $_FILES['pdf24']['name'] : NULL;
$pdf24_legende = ($_POST['pdf24_legende']);
$fichierTempoPdf24 = isset($_FILES['pdf24']['tmp_name']) ? $_FILES['pdf24']['tmp_name'] : NULL;
$pdf25 = isset($_FILES['pdf25']['name']) ? $_FILES['pdf25']['name'] : NULL;
$pdf25_legende = ($_POST['pdf25_legende']);
$fichierTempoPdf25 = isset($_FILES['pdf25']['tmp_name']) ? $_FILES['pdf25']['tmp_name'] : NULL;
$pdf26 = isset($_FILES['pdf26']['name']) ? $_FILES['pdf26']['name'] : NULL;
$pdf26_legende = ($_POST['pdf26_legende']);
$fichierTempoPdf26 = isset($_FILES['pdf26']['tmp_name']) ? $_FILES['pdf26']['tmp_name'] : NULL;
$pdf27 = isset($_FILES['pdf27']['name']) ? $_FILES['pdf27']['name'] : NULL;
$pdf27_legende = ($_POST['pdf27_legende']);
$fichierTempoPdf27 = isset($_FILES['pdf27']['tmp_name']) ? $_FILES['pdf27']['tmp_name'] : NULL;
$pdf28 = isset($_FILES['pdf28']['name']) ? $_FILES['pdf28']['name'] : NULL;
$pdf28_legende = ($_POST['pdf28_legende']);
$fichierTempoPdf28 = isset($_FILES['pdf28']['tmp_name']) ? $_FILES['pdf28']['tmp_name'] : NULL;
$pdf29 = isset($_FILES['pdf29']['name']) ? $_FILES['pdf29']['name'] : NULL;
$pdf29_legende = ($_POST['pdf29_legende']);
$fichierTempoPdf29 = isset($_FILES['pdf29']['tmp_name']) ? $_FILES['pdf29']['tmp_name'] : NULL;
$pdf30 = isset($_FILES['pdf30']['name']) ? $_FILES['pdf30']['name'] : NULL;
$pdf30_legende = ($_POST['pdf30_legende']);
$fichierTempoPdf30 = isset($_FILES['pdf30']['tmp_name']) ? $_FILES['pdf30']['tmp_name'] : NULL;
move_uploaded_file($fichierTempo, '../images/'.$photo);
move_uploaded_file($fichierTempoMiniature, '../images/'.$miniature);
// move_uploaded_file($fichierTempo_photo_lienPdf, '../fichierPdf/'.$photo_lienPdf);
move_uploaded_file($fichierTempoPdf1, '../fichierPdf/'.$pdf1);
move_uploaded_file($fichierTempoPdf2, '../fichierPdf/'.$pdf2);
move_uploaded_file($fichierTempoPdf3, '../fichierPdf/'.$pdf3);
move_uploaded_file($fichierTempoPdf4, '../fichierPdf/'.$pdf4);
move_uploaded_file($fichierTempoPdf5, '../fichierPdf/'.$pdf5);
move_uploaded_file($fichierTempoPdf6, '../fichierPdf/'.$pdf6);
move_uploaded_file($fichierTempoPdf7, '../fichierPdf/'.$pdf7);
move_uploaded_file($fichierTempoPdf8, '../fichierPdf/'.$pdf8);
move_uploaded_file($fichierTempoPdf9, '../fichierPdf/'.$pdf9);
move_uploaded_file($fichierTempoPdf10, '../fichierPdf/'.$pdf10);
move_uploaded_file($fichierTempoPdf11, '../fichierPdf/'.$pdf11);
move_uploaded_file($fichierTempoPdf12, '../fichierPdf/'.$pdf12);
move_uploaded_file($fichierTempoPdf13, '../fichierPdf/'.$pdf13);
move_uploaded_file($fichierTempoPdf14, '../fichierPdf/'.$pdf14);
move_uploaded_file($fichierTempoPdf15, '../fichierPdf/'.$pdf15);
move_uploaded_file($fichierTempoPdf16, '../fichierPdf/'.$pdf16);
move_uploaded_file($fichierTempoPdf17, '../fichierPdf/'.$pdf17);
move_uploaded_file($fichierTempoPdf18, '../fichierPdf/'.$pdf18);
move_uploaded_file($fichierTempoPdf19, '../fichierPdf/'.$pdf19);
move_uploaded_file($fichierTempoPdf20, '../fichierPdf/'.$pdf20);
move_uploaded_file($fichierTempoPdf21, '../fichierPdf/'.$pdf21);
move_uploaded_file($fichierTempoPdf22, '../fichierPdf/'.$pdf22);
move_uploaded_file($fichierTempoPdf23, '../fichierPdf/'.$pdf23);
move_uploaded_file($fichierTempoPdf24, '../fichierPdf/'.$pdf24);
move_uploaded_file($fichierTempoPdf25, '../fichierPdf/'.$pdf25);
move_uploaded_file($fichierTempoPdf26, '../fichierPdf/'.$pdf26);
move_uploaded_file($fichierTempoPdf27, '../fichierPdf/'.$pdf27);
move_uploaded_file($fichierTempoPdf28, '../fichierPdf/'.$pdf28);
move_uploaded_file($fichierTempoPdf29, '../fichierPdf/'.$pdf29);
move_uploaded_file($fichierTempoPdf30, '../fichierPdf/'.$pdf30);
//ps = paramètre statement
$ps = $bdd->prepare('INSERT INTO articles (titre, titreCache, auteur, contenu, lienSiteWeb1, lienSiteWeb1_legende, lienSiteWeb2, lienSiteWeb2_legende, dateArticle, dateTimeEdition, photo, miniature, photo_legende, photo_lienPdf, pdf1, pdf1_legende, pdf2, pdf2_legende, pdf3, pdf3_legende, pdf4, pdf4_legende, pdf5, pdf5_legende, pdf6, pdf6_legende, pdf7, pdf7_legende, pdf8, pdf8_legende, pdf9, pdf9_legende, pdf10, pdf10_legende, pdf11, pdf11_legende, pdf12, pdf12_legende, pdf13, pdf13_legende, pdf14, pdf14_legende, pdf15, pdf15_legende, pdf16, pdf16_legende, pdf17, pdf17_legende, pdf18, pdf18_legende, pdf19, pdf19_legende, pdf20, pdf20_legende, pdf21, pdf21_legende, pdf22, pdf22_legende, pdf23, pdf23_legende, pdf24, pdf24_legende, pdf25, pdf25_legende, pdf26, pdf26_legende, pdf27, pdf27_legende, pdf28, pdf28_legende,pdf29, pdf29_legende, pdf30, pdf30_legende, categories_id, page ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');
//params = tableau des paramètres
$params=array($titre, $titreCache, $auteur, $contenu, $lienSiteWeb1, $lienSiteWeb1_legende, $lienSiteWeb2, $lienSiteWeb2_legende, $photo, $miniature, $photo_legende, $photo_lienPdf, $pdf1, $pdf1_legende, $pdf2, $pdf2_legende, $pdf3, $pdf3_legende, $pdf4, $pdf4_legende, $pdf5, $pdf5_legende, $pdf6, $pdf6_legende, $pdf7, $pdf7_legende, $pdf8, $pdf8_legende, $pdf9, $pdf9_legende, $pdf10, $pdf10_legende, $pdf11, $pdf11_legende, $pdf12, $pdf12_legende, $pdf13, $pdf13_legende, $pdf14, $pdf14_legende, $pdf15, $pdf15_legende, $pdf16, $pdf16_legende, $pdf17, $pdf17_legende, $pdf18, $pdf18_legende, $pdf19, $pdf19_legende, $pdf20, $pdf20_legende, $pdf21, $pdf21_legende, $pdf22, $pdf22_legende, $pdf23, $pdf23_legende, $pdf24, $pdf24_legende, $pdf25, $pdf25_legende, $pdf26, $pdf26_legende, $pdf27, $pdf27_legende, $pdf28, $pdf28_legende, $pdf29, $pdf29_legende, $pdf30, $pdf30_legende, $categories_id, $page);
$ps->execute($params);
}else{
$message = "Une erreur s'est produite";
}
}else{
$message = "Veuillez remplir tous les champs";
}
header('location: adminarticle_avec_pdf'); |
