Ultra File Manager

Edit: /home/u523034047/domains/eipcsindia.com/public_html/LoanApp/notifications.php

<?php
session_start();
include 'connection.php';

if (!isset($_SESSION['username'])) {
    header("Location: signin.php");
    exit();
}

$username = $_SESSION['username'];

// Fetch user ID
$stmt = $conn->prepare("SELECT id FROM user_reg WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
$user_id = $user['id'];
$stmt->close();

// Fetch notifications
$notif_stmt = $conn->prepare("SELECT title, message, created_at FROM user_notifications WHERE user_id = ? ORDER BY created_at DESC");
$notif_stmt->bind_param("i", $user_id);
$notif_stmt->execute();
$notifications = $notif_stmt->get_result();
?>

<!doctype html>

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">
    <meta name="generator" content="">
    <title>FiMobile V2.0 - Mobile HTML template</title>

<meta name="apple-mobile-web-app-capable" content="yes">

<link rel="apple-touch-icon" href="assets/img/favicon180.png" sizes="180x180">
    <link rel="icon" href="assets/img/favicon32.png" sizes="32x32" type="image/png">
    <link rel="icon" href="assets/img/favicon16.png" sizes="16x16" type="image/png">

<link rel="preconnect" href="https://fonts.googleapis.com/">
    <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@400;600;700&amp;display=swap" rel="stylesheet">
    <link href="https://fonts.googleapis.com/css2?family=Open+Sans:wght@300;400;600;700&amp;display=swap" rel="stylesheet">

<link rel="stylesheet" href="../../../../cdn.jsdelivr.net/npm/bootstrap-icons%401.5.0/font/bootstrap-icons.css">

<link href="assets/css/style.css" rel="stylesheet" id="style">
</head>

<div class="container-fluid loader-wrap">
        <div class="row h-100">
            <div class="col-10 col-md-6 col-lg-5 col-xl-3 mx-auto text-center align-self-center">
                <div class="loader-cube-wrap loader-cube-animate mx-auto">
                    <img src="assets/img/logo.png" alt="Logo">
                </div>
                <p class="mt-4">It's time for track budget<br><strong>Please wait...</strong></p>
            </div>
        </div>
    </div>

<main class="h-100 has-header">

<header class="header position-fixed">
            <div class="row">
                <div class="col-auto">
                    <button class="btn btn-light btn-44 back-btn" onclick="window.location.replace('index.php');">
                        <i class="bi bi-arrow-left"></i>
                    </button>
                </div>
                <div class="col align-self-center text-center">
                    <h5>Notification</h5>
                </div>
                <div class="col-auto">
                    <a href="notifications.php" target="_self" class="btn btn-light btn-44">
                        <i class="bi bi-bell"></i>
                        <span class="count-indicator"></span>
                    </a>
                </div>
            </div>
        </header>

<div class="main-container container pt-0">
            
            <div class="row">
                <div class="col-12 px-0">
        <div class="list-group list-group-flush bg-none">
    <?php if ($notifications->num_rows > 0): ?>
        <?php while ($notif = $notifications->fetch_assoc()): ?>
            <a class="list-group-item bg-white">
                <div class="row">
                    <div class="col-auto">
                        <div class="avatar avatar-44 coverimg rounded-10">
                            <img src="assets/img/notification.png" alt="">
                        </div>
                    </div>
                    <div class="col align-self-center ps-0">
                        <p class="mb-1"><b><?php echo htmlspecialchars($notif['title']); ?></b></p>
                        <p class="mb-1"><?php echo htmlspecialchars($notif['message']); ?></p>
                        <p class="size-12 text-muted">
                            <?php echo date("d M Y h:i A", strtotime($notif['created_at'])); ?>
                        </p>
                    </div>
                </div>
            </a>
        <?php endwhile; ?>
    <?php else: ?>
        <div class="list-group-item text-center">
            No notifications found.
        </div>
    <?php endif; ?>
</div>
  
                </div>
            </div>
        </div>

</main>

<script src="assets/js/jquery-3.3.1.min.js"></script>
    <script src="assets/js/popper.min.js"></script>
    <script src="assets/vendor/bootstrap-5/js/bootstrap.bundle.min.js"></script>

<script src="assets/js/jquery.cookie.js"></script>

<script src="assets/js/main.js"></script>
    <script src="assets/js/color-scheme.js"></script>

<script src="assets/js/app.js"></script>

</body>

</html>

Ukuran: 5.4 KB