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
|
<?php
$a = $_REQUEST['subject1'];
$con=mysqli_connect("localhost","root","","wkayetdb");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT id, message FROM notifications WHERE subject = '".$a."' AND status = 'unseen' ORDER BY id DESC LIMIT 0, 1");
$notification = array();
while($row = mysqli_fetch_array($result)) {
$id = $row['id'];
$message = $row['message'];
if($message=="a ajouté"){
$result1 = mysqli_query($con,"SELECT notifications.id AS id, groupe.id_groupe AS groupid, eventsgroupe.start AS startdate, groupe.groupename AS groupname, notifications.message AS message, eventsgroupe.title AS title, notifications.status as status FROM notifications, eventsgroupe, groupe WHERE notifications.actor = groupe.id_groupe AND notifications.object = eventsgroupe.id AND notifications.id = '".$id."'");
while($row1 = mysqli_fetch_array($result1)) {
$notification = array('id'=>$row1['id'],'groupid'=>$row1['groupid'],'startdate'=>$row1['startdate'],'groupname'=>$row1['groupname'],'message'=>$row1['message'],'title'=>$row1['title'],'status'=>$row1['status']);
}
}
elseif(($message=="a accepté votre invitation de rejoindre votre groupe")||($message=="a décliné votre invitation de rejoindre votre groupe")){
$result2 = mysqli_query($con,"SELECT notifications.id AS id, groupe.groupename AS groupname, notifications.message AS message, user.name AS username FROM notifications, user, groupe WHERE notifications.actor = user.id_user AND notifications.object = groupe.id_groupe AND notifications.id = '".$id."'");
while($row2 = mysqli_fetch_array($result2)) {
$notification = array('id'=>$row2['id'],'username'=>$row2['username'],'message'=>$row2['message'],'groupname'=>$row2['groupname']);
}
}
}
echo json_encode($notification);
mysqli_close($con);
?> |
Partager