/
fonctions.php
96 lines (80 loc) · 2.21 KB
/
fonctions.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
<?php
include('class/Membre.php');
function connect_BD(){
$mysqli = new mysqli("localhost", "admin", "", "test");
if ($mysqli->connect_errno) {
$error = "Echec lors de la connexion à MySQL : (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
return $error;
}
return $mysqli;
}
function existMail($mail){
$mysqli = connect_BD();
$nb = $mysqli->query("SELECT mail FROM membre WHERE mail ='$mail'")->num_rows;
if($nb == 1)
return true;
else
return false;
}
function existPseudo($pseudo){
$mysqli = connect_BD();
$nb = $mysqli->query("SELECT pseudo FROM membre WHERE pseudo ='$pseudo'")->num_rows;
if($nb == 1)
return true;
else
return false;
}
function register($mail,$pseudo,$mdp){
if(isset($mail, $pseudo, $mdp)){
if(existMail($mail) != true && existPseudo($pseudo) != true){
$mdp = crypt($mdp, '$2a$07$wtc$');
$user = new Membre($mail,$pseudo,$mdp,0);
return true;
}else{
$error = "Pseudo ou E-mail déja utilisés";
return false;
}
}else{
$error = "Un des champs est vide.";
return false;
}
}
function existMdp($mdp){
$mdp= crypt($mdp, '$2a$07$wtc$');
$mysqli = connect_BD();
$nb = $mysqli->query("SELECT mdp FROM membre WHERE mdp ='$mdp'")->num_rows;
if($nb == 1)
return true;
else
return false;
}
function existPseudo_Mdp($pseudo,$mdp){
$mdp= crypt($mdp, '$2a$07$wtc$');
$mysqli = connect_BD();
$truemdp = $mysqli->query("SELECT mdp FROM membre WHERE pseudo ='$pseudo' or mail ='$pseudo'")->fetch_row();
if($truemdp[0]==$mdp){
return true;
}
else
return false;
}
function connexion(){
$mysqli=connect_BD();
$login = $_POST['pseudo'];
$mdp = $_POST['mdp'];
if(existPseudo($login)==true || existMail($login)==true){
if(existMdp($mdp)== true){
session_start();
$_SESSION["login"]=$login;
}
else{
$message = 'Mot de passe incorrect.';
echo $message;
}
}
else{
$message= 'Pseudo ou adresse mail incorrect(e)';
echo $message;
}
}
?>