Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory : /home/u615232177/public_html/ |
<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']);
include("header.php"); ?>
<title><?php echo $company_name; ?> - Inbox</title>
<div class="col-md-12 col-xs-12" id="product_msg"></div>
<!-- Start All Title Box -->
<div class="all-title-box">
<div class="container">
<div class="row">
<div class="col-lg-12">
<h2>Notifications</h2>
<ul class="breadcrumb">
<li class="breadcrumb-item"><a href="#">Home</a></li>
<li class="breadcrumb-item active">Inbox</li>
</ul>
</div>
</div>
</div>
</div>
<!-- End All Title Box -->
<div class="listing-area pt-50 pb-50"> <br>
<div class="container">
<div class="row">
<div class="col-xl-12 col-lg-12 col-md-12">
<div class="latest-items latest-items2">
<div class="row">
<div class="col-md-8 col-lg-8 mb-4 mb-lg-0">
<?php
$sql = "SELECT COUNT(id) FROM notifications WHERE receiver='$user_id' ORDER BY id DESC";
$query = mysqli_query($con, $sql);
$row = mysqli_fetch_row($query);
//here we have the total row count
$rows = $row[0];
//number of results we want per page
$page_rows = 25;
//tells us the page number of our last page
$last = ceil($rows/$page_rows);
//this makes sure last cannot be less than 1
if($last < 1){$last = 1;}
//establish the page num variable
$pagenum = 1;
//Get pageum from $GET if it is present, else its 1
if(isset($_GET['pn'])){
$pagenum = preg_replace('#[^0-9]#', '', $_GET['pn']);
}
//below 1 or more than last page
if($pagenum < 1){
$pagenum = 1;
}else if ($pagenum > $last) {
$pagenum = $last;
}
//this sets the range of rows to query for the chosen pagenum
$limit = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows;
//grabs one page worth of rows
$sql = "SELECT * FROM notifications WHERE receiver='$user_id' ORDER BY id DESC $limit";
$query = mysqli_query($con, $sql);
//this shows the user what page they on and total number
$textline1 = "Messages $rows";
$textline2 = "Page $pagenum of $last";
//establish the pagination controls
$paginationCtrls = "";
//if there is more than one page worth of results
if($last != 1){
if($pagenum > 1){
$previous = $pagenum - 1;
//$paginationCtrls .='<a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Previous</a>  ';
$paginationCtrls .='<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Prev</a></li>';
//render clickable links to the left of target page number
for($i = $pagenum-4; $i < $pagenum; $i++){
if($i > 0){
//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'"></a> ';
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
}
}
}
//render target number bt not link
//$paginationCtrls .= ''.$pagenum.' ';
$paginationCtrls .= '<span class="pagination"><ul><li class="active"><a href="#">'.$pagenum.'</a></li></ul></span>';
//render clickable number links to the right of target number
for($i = $pagenum+1; $i <= $last; $i++){
//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a> ';
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
if($i >= $pagenum+4){
break;
}
}
//this does the same as above, only checking if we are on the last page
if($pagenum != $last) {
$next = $pagenum + 1;
$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$next.'">Next</a></li>';
}
}
if(mysqli_num_rows($query) > 0 ){
while ($row_ads = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$id = $row_ads['id'];
$content = $row_ads['content'];
$sender = $row_ads['sender'];
$seen = $row_ads['seen'];
$date = $row_ads['date'];
if($seen =="Yes"){$opacity="opacity:0.4;";}else{$opacity="";}
echo"
<div class='d-block d-md-flex' style='border-radius:5px;padding:10px;background:gainsboro;height:200px;$opacity'>
<div class='lh-content'>
<h3 style='font-size:18px;'>$content</h3>
<address style='font-size:14px;'>$date</address>";
if($seen =="No"){
echo"
<form action='";echo htmlspecialchars($_SERVER["PHP_SELF"]);echo"' method='post'>
<div class='row form-group'>
<div class='col-md-12'>
<input type='hidden' value='$id' name='notification_id'>
<input type='submit' style='text-align:center;margin:auto;' name='mark_as_seen' value='Mark as seen' class='btn hvr-hover py-2 px-4 text-white'>
</div>
</div>
</form>
";
}
echo"
</div>
</div>
<br/><br/>
";
if (isset($_POST['mark_as_seen'])){
$notification_id = $_POST['notification_id'];
mysqli_query($con,
"UPDATE notifications SET
seen='Yes'
WHERE id='$notification_id'")or die(mysqli_error($con));
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Notification dismissed.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
}
}//end of while
}
else{echo"No notifications found.";}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
<?php include("footer.php"); ?>