accesBase.php
3.46 KB
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
<?php
function connexion()
{
$machine='houplin.studserv.deule.net' ;
$user='grouille' ;
$pwd='postgres' ;
$db='projetCapteurs' ;
$link = pg_connect("host=$machine user=$user password=$pwd dbname=$db") or die('Erreur de Connection !<br />'.pg_last_error()) ;
return $link ;
}
function deconnexion($db)
{
pg_close($db);
}
function verifPwd($id, $pwd)
{
$db = connexion();
$query = "SELECT pwd FROM membres WHERE identifiant = '$id'";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
$pass = pg_fetch_assoc($result);
deconnexion($db);
return(password_verify($pwd, $pass['pwd']));
}
function notAMember($id)
{
$db = connexion();
$query = "SELECT * FROM membres WHERE identifiant = '$id'";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
if (pg_affected_rows($result)!=0){
return False;
}
else{
return True;
}
}
function countMember()
{
$db = connexion();
$query = "SELECT * FROM membres";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
return pg_affected_rows($result);
}
function inscription($id, $pwd, $nom, $prenom)
{
$db = connexion();
$num = countMember() +1;
$pwd_hache = password_hash($pwd, PASSWORD_DEFAULT);
$query = "INSERT INTO membres VALUES('$num', '$nom', '$prenom', '$pwd_hache', '$id')";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
if (pg_affected_rows($result)!=0){
return True;
}
else{
return False;
}
}
function getMembreByIdPwd($id, $pwd)
{
$db = connexion();
$query = "SELECT nom, prenom, pwd FROM membres WHERE identifiant = '$id'";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
$tab = pg_fetch_assoc($result);
if(password_verify($pwd, $tab['pwd']))
return $tab;
}
function getSensors()
{
$db = connexion();
$query = "SELECT * FROM capteurs";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
$tab = pg_fetch_all($result);
return $tab;
}
function upload($index,$maxsize=FALSE,$extensions=FALSE)
{
//Test1: fichier correctement uploadé
if (!isset($_FILES[$index]) OR $_FILES[$index]['error'] > 0) return FALSE;
//Test2: taille limite
if ($maxsize !== FALSE AND $_FILES[$index]['size'] > $maxsize) return FALSE;
//Test3: extension
$ext = substr(strrchr($_FILES[$index]['name'],'.'),1);
if ($extensions !== FALSE AND !in_array($ext,$extensions)) return FALSE;
$name = 'binaire';
$extension_upload = strtolower( substr( strrchr($_FILES['fichier']['name'], '.') ,1) );
$fichier = "upload/{$name}.{$extension_upload}";
//$fichier = basename($_FILES[$index]['name']);
return move_uploaded_file($_FILES['fichier']['tmp_name'],$fichier);
}
function get_num()
{
$db = connexion();
$query = "SELECT num FROM verif";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
$tab = pg_fetch_assoc($result);
return $tab['num'];
}
function inc_num()
{
$db = connexion();
$query = "SELECT num FROM verif";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
$tab = pg_fetch_assoc($result);
$var = $tab['num'];
$query = "UPDATE verif SET num='$var'+1";
$result = pg_query($db, $query) or die("La requête a echoué : ".pg_last_error());
}
?>