-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcontact.class.php
120 lines (98 loc) · 2.23 KB
/
contact.class.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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
require_once("/bundle/Reader/Reader.class.php");
class Contact extends Reader
{
private $id;
private $name;
private $lastName;
private $mail;
private $content;
private $ip;
private $sendTime;
private $view;
public function newContact(Contact $contact)
{
$bdd = Contact::getPdoConnexion();
$req = $bdd->prepare('INSERT INTO contact(name, lastName, mail, contenu, ip, sendTime) VALUES(:name, :lastName, :mail, :content, :ip, :sendTime)');
$req->execute(array(
'name' => $contact->getName(),
'lastName' => $contact->getLastName(),
'mail' => $contact->getMail(),
'content' => $contact->getContent(),
'ip' => $contact->getIp(),
'sendTime' => $contact->getSendTime()
));
}
public function getAllContact(){
$bdd = Contact::getPdoConnexion();
$reponse = $bdd->query('SELECT * FROM contact');
$array = array();
while($donnees = $reponse->fetch())
{
$cont = new Contact();
$cont->setId($donnees['id']);
$cont->setName($donnees['name']);
$cont->setLastName($donnees['lastName']);
$cont->setIp($donnees['ip']);
$cont->setMail($donnees['mail']);
$cont->setContent($donnees['contenu']);
$cont->setSendTime($donnees['sendTime']);
$cont->setView($donnees['view']);
//more
array_push($array, $cont);
}
return $array;
}
public function getId()
{
return $this->id;
}
public function setId($id){
$this->id = $id;
}
public function getName()
{
return $this->name;
}
public function setName($name)
{
$this->name = $name;
}
public function getLastName(){
return $this->lastName;
}
public function setLastName($lastName){
$this->lastName = $lastName;
}
public function getMail(){
return $this->mail;
}
public function setMail($mail){
$this->mail = $mail;
}
public function getContent(){
return $this->content;
}
public function setContent($content){
$this->content = $content;
}
public function getIp(){
return $this->ip;
}
public function setIp($ip){
$this->ip = $ip;
}
public function getSendTime(){
return $this->sendTime;
}
public function setSendTime($sendTime){
$this->sendTime = $sendTime;
}
public function getView(){
return $this->view;
}
public function setView($view){
$this->view = $view;
}
}
?>