/
model.php
86 lines (71 loc) · 3.13 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
<?php
require_once'ModeleBDD.php';
/*
* *****************************************************************************************
* *****************************************************************************************
* ******************************* Connexion Personne *************************************
* *****************************************************************************************
* *****************************************************************************************
*/
class Connexion extends ModeleBDD {
private $login;
private $password;
private $bdd;
public function __construct($login, $password) {
$this->login = $login;
$this->password = $password;
$this->bdd = bdd();
}
public function verification_connexion() {
$requete = $this->bdd->prepare('Select * from personne where login = :login');
$requete->execute(array('login' => $this->login));
$reponse = $requete->fetch();
if ($reponse) {
if ($this->password == $reponse['password']) {
return 'ok';
} else {
$erreur = 'Le mot de passe saisi est incorrect';
return $erreur;
}
} else {
$erreur = 'Ce login n\'existe pas!!';
return $erreur;
}
}
public function session() {
$requete = $this->bdd->prepare('select * from personne where login = :login');
$requete->execute(array('login' => $this->login));
$donnees = $requete->fetch();
$_SESSION['idPersonne'] = $donnees['idPersonne'];
$_SESSION['level'] = 1;
setcookie('idPersonne', $donnees['idPersonne'], time() + 3600 * 24 * 3, '/', 'group1.estiam.com', false, true);
return 1;
}
}
/*
* *****************************************************************************************
* *****************************************************************************************
* ****************************** Connexion Persistante ***********************************
* *****************************************************************************************
* *****************************************************************************************
*/
class ConnexionPersistante extends ModeleBDD {
private $IdPersonne;
private $bdd;
public function __construct($IdPersonne) {
$this->IdPersonne = $IdPersonne;
$this->bdd = bdd();
}
public function session2() {
$requete = $this->bdd->prepare('select * from personne where idPersonne = :IdPersonne');
$requete->execute(array('IdPersonne' => $this->IdPersonne));
$donnees = $requete->fetch();
$_SESSION['idPersonne'] = $donnees['idPersonne'];
// $_SESSION['level'] = $donnees['level'];
//$_SESSION['typePersonne'] = $donnees['typePersonne'];
//setcookie('idPersonne', $donnees['idPersonne'], time() + 24 * 3600, '/', 'localhost', false, true);
// setcookie('idPersonne', $donnees['idPersonne'],time()+3600*24*3);
return 1;
}
}
?>