1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / oxyield.live / user /
Filename : notifications.php
back
<?php
session_start();
error_reporting(0);
include('../../config/config.php');
include('includes/checklogin.php');
include('includes/functions.php');

check_login();
$title="Dashboard";
$uid=$_SESSION['id'];
$uip=$_SERVER['REMOTE_ADDR'];
include 'includes/header.php'; 

$currentTime = date( 'd-m-Y h:i:s A', time () );
$uid= $_SESSION['id'];

$sql = "SELECT * FROM `users` WHERE id=$uid";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

$sql2 = "UPDATE `notifications` set `is_read`='1'
WHERE `receiver_id`='$uid' ";	
$result = mysqli_query($con, $sql2);


?>
  
  <div class="container-fluid main-content px-2 px-lg-4">
    <div class="row my-2 g-3 g-lg-4 promotion">
        <div class="col-12 d-flex justify-content-between align-items-center px-3 flex-wrap gap-3">
            <h5 class="text-white mb-0">Notifications</h5>
        </div>


                <div class="row my-2 g-3 g-lg-4">
                
                <?php
									$userid=$_SESSION['id']; 
									$query="SELECT * FROM `notifications` WHERE `receiver_id`='$uid'  ORDER BY `notification_id` DESC LIMIT 3";
									$result=mysqli_query($con,$query);
										 $cnt=+1;
										 if(mysqli_num_rows($result)>0){
										while($row=mysqli_fetch_array($result)){
											$type=$row['action_type'];
							
											$date_string=$row['created_at'];// date retrieved from database
											$timestamp = strtotime($date_string); // convert date string to Unix timestamp
											$date = date("jS \of F Y", $timestamp);// format timestamp into words

								?>
                                   <div class="col-md-12 col-xl-12 col-xxl-1">
                                        <div class="price-box">
                                            <div class="d-flex flex-column">					
                                                <p class="mb-0"><?php echo htmlentities($row['body']);?></p>
                                                <span class="small d-inline-block mt-1 text-white"><?php echo htmlentities($date);?></span>

                                            </div>
                                        </div>
                                    </div>
                                    <?php } 
                                }else{ ?>
                                    <div class="row my-2 g-3 g-lg-4 mt-5" >
                                            <p style="text-align:center;">You don't have any notification!</p>
                                </div>
                    <?php  } ?>

                      


                </div>

  
</div>

<div style="margin-top:30px;height:10px;"></div>

<?php include 'bottom-tabs.php' ?>      
<?php include 'includes/footer.php' ?>