PHPIndex

<?php
$sql = "SELECT * FROM member WHERE email = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $usermail);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();
?>

<footer class="app-footer"> 
            <div class="float-end d-none d-sm-inline">Version 1.0</div>
            Copyright © <span id="currentyear"></span>, Tech-Geeks Hall of Fame. All rights reserved.
        </footer>
    </div>
    
    <script src="js/jquery.min.js"></script>
    <script src="js/overlayscrollbars.browser.es6.min.js"></script>
    <script src="js/popper.min.js"></script>
    <script src="js/bootstrap.min.js"></script>
    <script src="js/dashboard-scripts.js"></script>
    
    <script>
        const SELECTOR_SIDEBAR_WRAPPER = ".sidebar-wrapper";
        const Default = {
            scrollbarTheme: "os-theme-light",
            scrollbarAutoHide: "leave",
            scrollbarClickScroll: true,
        };
        document.addEventListener("DOMContentLoaded", function() {
            const sidebarWrapper = document.querySelector(SELECTOR_SIDEBAR_WRAPPER);
            if (
                sidebarWrapper &&
                typeof OverlayScrollbarsGlobal?.OverlayScrollbars !== "undefined"
            ) {
                OverlayScrollbarsGlobal.OverlayScrollbars(sidebarWrapper, {
                    scrollbars: {
                        theme: Default.scrollbarTheme,
                        autoHide: Default.scrollbarAutoHide,
                        clickScroll: Default.scrollbarClickScroll,
                    },
                });
            }
        });
    </script>

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@fontsource/source-sans-3@5.1.0/index.min.css">
    <link rel="stylesheet" href="css/overlayscrollbars.min.css">
    <link rel="stylesheet" href="css/bootstrap-icons.min.css">
    <link rel="stylesheet" href="css/dashboard-style.css">

<?php
/*
$memberName = '';
$stmt = $conn->prepare("SELECT name FROM member WHERE email = ?");
$stmt->bind_param("s", $usermail);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $memberName = $row['name'];
} else {
    echo "<script>alert('Member not found in the database.');</script>";
}
*/
?>

<nav class="app-header navbar navbar-expand bg-body-secondary">
    <div class="container-fluid">
        <ul class="navbar-nav">
            <li class="nav-item"> <a class="nav-link" data-lte-toggle="sidebar" href="#" role="button"> <i class="bi bi-list" style="font-size: 22px;"></i> </a> </li>
            <form class="form-inline ml-3 mt-1 mb-1">
                <div class="input-group input-group-sm">
                    <input class="form-control form-control-navbar" type="search" id="Search" placeholder="Search" aria-label="Search" onkeyup="search()">
                    <div class="input-group-append">
                        <button class="btn btn-navbar" type="submit">
                            <i class="bi bi-search"></i>
                        </button>
                    </div>
                </div>
            </form>
        </ul>
        <ul class="navbar-nav ms-auto">
            <li class="nav-item"> <a class="nav-link" href="#" data-lte-toggle="fullscreen"> <i data-lte-icon="maximize" class="bi bi-arrows-fullscreen"></i> <i data-lte-icon="minimize" class="bi bi-fullscreen-exit" style="display: none;"></i> </a></li>
            <li class="nav-item dropdown">
                <button class="btn btn-link nav-link py-2 px-0 px-lg-2 dropdown-toggle d-flex align-items-center" id="bd-theme" type="button" aria-expanded="false" data-bs-toggle="dropdown" data-bs-display="static">
                    <span class="theme-icon-active">
                        <i class="my-1"></i>
                    </span>
                    <span class="d-lg-none ms-2" id="bd-theme-text">Theme</span>
                </button>
                <ul class="dropdown-menu dropdown-menu-end" aria-labelledby="bd-theme-text" style="--bs-dropdown-min-width: 8rem;">
                    <li>
                        <button type="button" class="dropdown-item d-flex align-items-center active" data-bs-theme-value="light" aria-pressed="false">
                            <i class="bi bi-sun-fill me-2"></i> Light <i class="bi bi-check-lg ms-auto d-none"></i>
                        </button>
                    </li>
                    <li>
                        <button type="button" class="dropdown-item d-flex align-items-center" data-bs-theme-value="dark" aria-pressed="false">
                            <i class="bi bi-moon-fill me-2"></i> Dark <i class="bi bi-check-lg ms-auto d-none"></i>
                        </button>
                    </li>
                    <li>
                        <button type="button" class="dropdown-item d-flex align-items-center" data-bs-theme-value="auto" aria-pressed="true">
                            <i class="bi bi-circle-half me-2"></i> Auto <i class="bi bi-check-lg ms-auto d-none"></i>
                        </button>
                    </li>
                </ul>
            </li>
        </ul>
    </div>
</nav>

<aside class="app-sidebar bg-primary-subtle shadow" data-bs-theme="dark">
            <div class="sidebar-brand">
	<a href="index.php" class="brand-link"><img src="../assets/img/tg-hof.webp" alt="AASICT Logo" class="brand-image shadow"> </a></div>
            <?php
            $activePage = basename($_SERVER['PHP_SELF'], ".php");
            ?>
            <div class="sidebar-wrapper">
                <nav class="mt-2">
                    <ul class="nav sidebar-menu flex-column" data-lte-toggle="treeview" role="menu" data-accordion="false">
                        <li class="nav-item"> <a href="../index.php" class="nav-link <?= ($activePage == 'dashboard') ? 'active':''; ?>"> <i class="nav-icon bi bi-speedometer"></i><p>Home</p></a></li>
                        <li class="nav-item"> <a href="show_members.php" class="nav-link <?= ($activePage == 'add_alumnus') || ($activePage == 'all_alumni') ? 'active':''; ?>"> <i class="nav-icon bi bi-people"></i><p>Show Members</p></a></li>
		    </ul>
                </nav>
            </div> 
        </aside>