notificationFetch.php

<?php 
//Add this file to use database for every file
include("db.php");

if(isset($_POST['user'])){
    
$id = $_POST['user'];
$stmt = $con->prepare("SELECT * FROM `notification` WHERE receiver_id =? ORDER BY time DESC LIMIT 25");
$stmt->bind_param("i",$id);
$stmt->execute();
$result = $stmt->get_result();
$stmt->close();

$count=0;

$output='<div class="drop-content">';
//making the list of content
    while($row = $result->fetch_assoc()){
        $noti_id = $row['id'];
        $type = $row['type'];
        $content = $row['content_id'];
        $readStatus = $row['read_status'];
        $date = date_create($row['time']);
        $postBy = '';
		$link='';
		$pic='';

        //display date and time
        date_default_timezone_set('Asia/Kuala_Lumpur');
        $time = date_format($date, 'G:i');
        $dateNow = date('Y-m-d H:i:s');
        $curr_date = date_create($dateNow);

        $date_diff = date_diff($date, $curr_date);
        $day_diff = $date_diff->format("%a");
        if($day_diff>7){
            $day = date_format($date, 'm M');
        }else if($day_diff>=2 && $day_diff<=7){
            $day = date_format($date, 'D');
        }
        else if($day_diff>1 && $day_diff<2){
            $day = 'Yesterday';
        }
        else{
            $day = 'Today';
        }

        //check for content event
        if($type == 'event'){
            $stmt = $con->prepare("SELECT `title`, `photo`  FROM `event` WHERE id=?");
            $stmt->bind_param("i", $content);
            $stmt->execute();
            $eventResult = $stmt->get_result();
            $stmt->close();

            //if event does not exist
            if(!( $event = $eventResult->fetch_assoc())){
                continue;
              }
            $postBy = 'FSKTM Admin posted an event';
            $text = $event['title'];
            $pic = '../images/event/'.$event['photo'];
            $link = '../alumni/eventdetail.php?eventID='.$content.'&notifID='.urlencode(base64_encode($noti_id));
        }
        //check for content friend
        else if($type == 'request' ||$type == 'acceptFriend' || $type == 'rejectFriend'){
            $stmt = $con->prepare("SELECT `title`, `fullname`, `profile_pic`  FROM `alumni_profile` WHERE alumni_id=?");
            $stmt->bind_param("i", $content);
            $stmt->execute();
            $friendResult = $stmt->get_result();
            $stmt->close();
            
            //if user does not exist
            if(!($friend = $friendResult->fetch_assoc())){
                continue;
              }

            $title = $friend['title'];
            $name = $friend['fullname'];
			if ($friend['profile_pic']==NULL){
				$friend['profile_pic']='default.png';
			}
            $pic = '../images/profileimg/'.$friend['profile_pic'];

            //link to friend request tab
            $link  = '../alumni/friendRequest.php?notifID='.urlencode(base64_encode($noti_id));

            //check if alumni has title
            if(!isset($title)){
                $postBy = $name;
            }
            else{
                $postBy = $title.' '.$name;
            }
            
            //check whether accepted or requested
            if($type == 'request'){
                $text = 'Sent you a friend request';
            }
            else if($type == 'acceptFriend'){
                $text = 'Accepted your friend request';
            }else if($type == 'rejectFriend'){
                $text = 'Rejected your friend request';
            }
        }else{
            $text ='Notification not found';
        }

        //change color of noti and count number of unread status
        if($readStatus==0){
            $seen = 'notification-box bg-gray';
            $count+=1;
        }else if($readStatus==1){
            $seen = 'notification-box';
        }   

        $output .= '
        <li class="'.$seen.' seen"  data-id="'.$noti_id.'" onclick="location.reload();location.href = \''.$link.'\'">
        <div class="row mb-3" type="submitNoti">
          <div class="col-lg-3 col-sm-3 col-3 img-position">
            <img src="'.$pic.'" class="image-cover">
          </div>    
          <div class="col-lg-8 col-sm-8 col-8">
            <strong class="text-info"> '.$postBy.' </strong>
            <div>
              '.$text.'
            </div>
            <small style="color: grey;"> <i>'.$day.' at '.$time.'</i></small>
          </div> 
        </div>
        </li>';

    }

    //for displaying notification(3)
    if($count==0){
        $displayCount = '';
    }else{
        $displayCount = '('.$count.')';
    }

$header='
<li class="head text-light bg-dark">
<div class="row">
  <div class="col-lg-12 col-sm-12 col-12">
  <form action="" method="post">
    <div class="form-inline flex-box mt-2 mb-2 ml-2 mr-2">
      <label>Notification'.$displayCount.'</label>
      <input type="text" name="receiver_id" value="'.$id.'" hidden/>
      <button onclick="location.reload()" name="submit" type="submit" class="btn btn-secondary btn-sm ml-5"  style="float: right;">Mark all as read</button>
    </div>
  </form>
  </div>
</div>
</li>';

$overall = $header.$output.'</div>';

$data = array(
    "notification"=>$overall,
    "unread"=>$count
);


echo json_encode($data);

}

?>