forked from parrago/App_info
/
model.php
98 lines (67 loc) · 3.47 KB
/
model.php
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
<?php
$connect = mysqli_connect("localhost", "root", "", "bddsimplevent");
mysqli_set_charset($connect,"utf8");
function affichage_categ_recherche_avancee(){
global $connect;
$result = mysqli_query($connect, "select * from categorie order by nomCat") or die("MsQL Erreur : ".mysqli_errno($connect));
return $result;
}
function insert_categ($nomCat) {
global $connect;
mysqli_query($connect, "insert into categorie (nomCat) values ('$nomCat')") or die("MySQL Erreur : " . mysqli_error($connect));
}
function delete_categ($id_categ) {
global $connect;
mysqli_query($connect, "delete from categorie where id_categ ='$id_categ'") or die("MySQL Erreur : " . mysqli_error($connect));
}
function update_categ($nouveauNom, $idcateg){
global $connect;
mysqli_query($connect, "update categorie set nomCat='$nouveauNom' where id_categ=".$idcateg) or die("MySQL Erreur : " . mysqli_error($connect));
}
function verification_mdp($adrentre){
global $connect;
$result = mysqli_query($connect, "select mot_de_passe,id_utilisateur,admin from utilisateur where mail='$adrentre'") or die("MsQL Erreur : ".mysqli_errno($connect));
$resultat = mysqli_fetch_assoc($result);
return $resultat;
}
function modification_categorie(){
$result = affichage_categ_recherche_avancee();
$compteur = 1;
if($compteur==1){
echo'<div class="nomcateg">';
while($categorie = mysqli_fetch_assoc($result)) {
echo '<div class="nom_de_categ">'.$categorie['nomCat'].'</div>';
}
echo'</div>';
$result = affichage_categ_recherche_avancee();
echo'<div class="zone_input_categ">';
while($categorie = mysqli_fetch_assoc($result)) {
echo'<form action="gestion_categorie.php" method="post">';
echo'<input type="text" class="zone_modification_categ" placeholder="modification" name='.$categorie['nomCat'].'> ';
echo'<input type="submit" value="supprimer/modifier" class="bouton_suppression_categ" name='.$categorie['id_categ'].'>';
echo'</form>';
}
$compteur = 0;
}
}
function affichage_utilisateurs(){
global $connect;
$result = mysqli_query($connect, "select mail from utilisateur order by mail") or die("MsQL Erreur : ".mysqli_errno($connect));
return $result;
}
function affichage_topics(){
global $connect;
$result = mysqli_query($connect, "select * from sujet") or die("MsQL Erreur : ".mysqli_errno($connect));
$compteur = 1;
if($compteur==1){
while($topic = mysqli_fetch_assoc($result)) {
echo '<tr>';
echo '<td class="colonne_topics">'.$topic['sujet'].'</td>';
echo '<td class="colonne_messages">'.$nb_messages.'</td>';
echo '<td class="colonne_dernier_message">'.$date_dernier_message.'</td>';
echo '</tr>';
}
echo'</div>';
$compteur = 0;
}
}