-
Notifications
You must be signed in to change notification settings - Fork 0
/
functions.php
114 lines (88 loc) · 2.47 KB
/
functions.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
<?php
function getConnexion(){
return mysqli_connect("localhost","root","","base");
}
function getUsers(){
$cnx=getConnexion();
$req=mysqli_query($cnx,"select * from user");
$tab=[];
while($t=mysqli_fetch_array($req)){
$tab []=$t;
}
mysqli_free_result($req);
mysqli_close($cnx);
return $tab;
}
function getAllMessagesRecus($iduser){
$cnx=getConnexion();
$req=mysqli_query($cnx,"select * from message where userreceive={$iduser} and receivedel=0");
$tab=[];
while($d=mysqli_fetch_array($req)){
$tab []=$d;
}
mysqli_free_result($req);
mysqli_close($cnx);
return $tab;
}
function getAllMessagesEnvoyes($iduser){
$cnx=getConnexion();
$req=mysqli_query($cnx,"select * from message where usersend={$iduser}");
$tab=[];
while($d=mysqli_fetch_array($req)){
$tab []=$d;
}
mysqli_free_result($req);
mysqli_close($cnx);
return $tab;
}
function getAllMessagesRecusNonLu($iduser){
$cnx=getConnexion();
$req=mysqli_query($cnx,"select * from message where userreceive={$iduser} and receiveread=0");
$tab=[];
while($d=mysqli_fetch_array($req)){
$tab []=$d;
}
mysqli_free_result($req);
mysqli_close($cnx);
return $tab;
}
function sendMessage($idsend,$idreceive,$titre,$message){
$cnx=getConnexion();
$date=Date("Y-m-d h:m:s");
$req=mysqli_query($cnx,"insert into message values(null,{$idsend},{$idreceive},'{$titre}','{$message}','{$date}',0,0,0,0)");
//mysqli_free_result($req);
mysqli_close($cnx);
}
function deleteSend($idsend,$idmessage){
$cnx=getConnexion();
$req=mysqli_query($cnx,"update message set senddel=1 where idmessage={$idmessage}");
mysqli_close($cnx);
}
function deleteReceive($idmessage){
$cnx=getConnexion();
$req=mysqli_query($cnx,"update message set receivedel=1 where idmessage={$idmessage}");
mysqli_close($cnx);
}
function getMessageRecu($idmessage){
$cnx=getConnexion();
$req=mysqli_query($cnx,"select * from message where idmessage={$idmessage}");
$message=null;
while($t=mysqli_fetch_array($req)){
$message=$d;
}
$req2=mysqli_query($cnx,"update message set receiveread=1 where idmessage={$idmessage}");
mysqli_free_result($req);
mysqli_close($cnx);
return $message;
}
function getUserById($iduser){
$cnx=getConnexion();
$req=mysqli_query($cnx,"select * from user where iduser={$iduser}");
$tab=null;
while($d=mysqli_fetch_array($req)){
$tab =$d;
}
mysqli_free_result($req);
mysqli_close($cnx);
return $tab;
}