PHPIndex

This page lists files in the current directory. You can view content, get download/execute commands for Wget, Curl, or PowerShell, or filter the list using wildcards (e.g., `*.sh`).

css
img
includes
js
show_members.php
wget 'https://lists2.roe3.org/tg-hof/members/show_members.php'
View Content
<?php
include("../config.php");
session_start();

$limit = 8;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $limit;
$query = "SELECT name, year_inducted, GROUP_CONCAT(nominated_by SEPARATOR ', ') AS nominated_by FROM member WHERE approved = 1 GROUP BY name, year_inducted";
//$ret = mysqli_query($conn, "SELECT * FROM member WHERE approved = 1 LIMIT $limit OFFSET $offset");
$ret = mysqli_query($conn, $query);
$total_records_query = mysqli_query($conn, "SELECT COUNT(DISTINCT(name)) as total FROM member WHERE approved = 1");
$total_records_row = mysqli_fetch_assoc($total_records_query);
$total_records = $total_records_row['total'];
$total_pages = ceil($total_records / $limit);

?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Current Members | Tech-Geeks Hall of Fame</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="icon" href="../assets/img/favicon.png" type="image/x-icon">
    <?php include('includes/global_styles.php'); ?>

    <style>
        table.table tr th,
        table.table tr td {
            border-color: #e9e9e9;
            padding: 10px;
        }

        table.table th i {
            font-size: 13px;
            margin: 0 5px;
            cursor: pointer;
        }

        table.table td:last-child {
            width: 130px;
        }

        table.table td a {
            color: #a0a5b1;
            display: inline-block;
            margin: 0 5px;
        }

        table.table td a.view {
            color: #03A9F4;
        }

        table.table td a.edit {
            color: #FFC107;
        }

        table.table td a.delete {
            color: #E34724;
        }

        table.table td i {
            font-size: 19px;
        }

        .hint-text {
            float: left;
            margin-top: 10px;
            font-size: 13px;
        }
    </style>
</head>

<body class="layout-fixed sidebar-expand-lg bg-body-tertiary">
    <div class="app-wrapper">

        <?php
        include('includes/navbar.php');
        include('includes/sidebar.php');
        ?>

        <main class="app-main">
            <div class="app-content-header">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-sm-6">
                            <h3 class="mb-0">Current Hall of Fame Members</h3>
                        </div>
                        <div class="col-sm-6">
                            <ol class="breadcrumb float-sm-end">
                                <li class="breadcrumb-item"><a href="../index.php">Home</a></li>
                                <li class="breadcrumb-item active" aria-current="page">Current Hall of Fame Members</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

            <div class="app-content">
                <div class="container-fluid">
                    <div class="row g-4">
                        <div class="col-md-12">
                            <div class="card card-primary card-outline mb-4">
                                <div class="card-header">
                                    <div class="card-title">Current Hall of Fame Members are shown here</div>
                                </div>
                                <div class="card-body p-0">
                                    <div class="table-responsive">
                                        <table class="table table-striped table-hover" id="table-data">
                                            <thead>
                                                <tr class="align-middle">
                                                    <th style="width: 10px">#</th>
                                                    <th>Name</th>
                                                    <th>Year Inducted</th>
                                                    <th>Nominated By</th>
                                                    <th style="width: 40px">View</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                $cnt = $offset + 1;
                                                if (mysqli_num_rows($ret) > 0) {
                                                    while ($row = mysqli_fetch_array($ret)) {
                                                ?>
                                                        <tr class="align-middle">
                                                            <td><?php echo $cnt; ?></td>
                                                            <td><?php echo $row['name']; ?></td>
                                                            <td><?php echo $row['year_inducted']; ?></td>
                                                            <td><?php echo $row['nominated_by']; ?></td>
                                                            <td>
                                                              <!--  <a href="view_member.php?id=<?php echo htmlentities($row['member_id']); ?>" class="view" title="View" data-toggle="tooltip"><i class="bi bi-eye-fill"></i></a> -->
                                                                <a href="view_member.php?name=<?php echo htmlentities($row['name']); ?>" class="view" title="View" data-toggle="tooltip"><i class="bi bi-eye-fill"></i></a>
                                                            </td>
                                                        </tr>
                                                    <?php
                                                        $cnt = $cnt + 1;
                                                    }
                                                } else { ?>
                                                    <tr>
                                                        <th style="text-align:center; color:red;" colspan="7">No Inductees</th>
                                                    </tr>
                                                <?php } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                <div class="card-footer clearfix">
                                    <form action="export_data.php" method="POST">

                                      <!--  <button class="exportexcel btn btn-success" id="exportexcel" name="exportexcel" type="submit"><i class="bi bi-download"></i>&nbsp; Export Data</button> -->
                                        <ul class="pagination pagination-sm m-0 float-end">
                                            <?php if ($page > 1): ?>
                                                <li class="page-item"><a class="page-link" href="?page=<?php echo $page - 1; ?>">&laquo; Previous</a></li>
                                            <?php endif; ?>
                                            <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                <li class="page-item <?php if ($i == $page) echo 'active'; ?>">
                                                    <a class="page-link" href="?page=<?php echo $i; ?>"><?php echo $i; ?></a>
                                                </li>
                                            <?php endfor; ?>
                                            <?php if ($page < $total_pages): ?>
                                                <li class="page-item"><a class="page-link" href="?page=<?php echo $page + 1; ?>">Next &raquo;</a></li>
                                            <?php endif; ?>
                                        </ul>
                                    </form>
                                </div>
                            </div>
                            <?php if (isset($_GET['update']) && htmlspecialchars($_GET['update']) == 'success'): ?>
                                <div class="callout callout-success">Member Details updated successfully!</div>
                            <?php endif; ?>
                            <?php if (isset($_GET['delete']) && htmlspecialchars($_GET['delete']) == 'success'): ?>
                                <div class="callout callout-success">Member Details deleted successfully!</div>
                            <?php endif; ?>
                        </div>
                    </div>
                </div>
            </div>
        </main>

        <?php include("includes/footer.php"); ?>

    </div>

</body>

</html>
view_member.php
wget 'https://lists2.roe3.org/tg-hof/members/view_member.php'
View Content
<?php
include("../config.php");
session_start();
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>Member Details | Tech-Geeks Hall of Fame</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="icon" href="../assets/img/favicon.png" type="image/x-icon">
    <?php include('includes/global_styles.php'); ?>
    <style>
        .table-responsive {
            padding: 4px;
            padding-top: 8px;
            margin-bottom: -14px;
        }

        .table-wrapper {
            min-width: 1000px;
            background: #fff;
            padding: 20px;
            box-shadow: 0 1px 1px rgba(0, 0, 0, .05);
        }

        table.table tr th,
        table.table tr td {
            border-color: #e9e9e9;
            padding: 10px;
        }

        table.table td:last-child {
            width: auto;
        }
    </style>
</head>

<body class="layout-fixed sidebar-expand-lg bg-body-tertiary">
    <div class="app-wrapper">

        <?php
        include('includes/navbar.php');
        include('includes/sidebar.php');
        ?>

        <main class="app-main">
            <div class="app-content-header">
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-sm-6">
                            <h3 class="mb-0">Hall of Fame Member Details</h3>
                        </div>
                        <div class="col-sm-6">
                            <ol class="breadcrumb float-sm-end">
                                <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                                <li class="breadcrumb-item active" aria-current="page">Member Details</li>
                            </ol>
                        </div>
                    </div>
                </div>
            </div>

            <div class="app-content">
                <div class="container-fluid">
                    <div class="row g-4">
                        <div class="col-md-12">
                            <div class="card card-primary card-outline mb-4">
                                <div class="card-header">
                                    <div class="card-title">Member details are shown here</div>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table class="table table-bordered">
                                            <tbody>
                                                <?php
                                                //$vid = $_GET['id'];
                                                $vid = $_GET['name'];
						$query = "SELECT name, GROUP_CONCAT(contributions SEPARATOR '+++++++<br><br>') AS all_contributions FROM member WHERE name = '".$vid."' GROUP BY name;";
                                                //$ret = mysqli_query($conn, "select * from member where member_id =$vid");
                                                $ret = mysqli_query($conn, $query);
						
                                                $cnt = 1;
                                                while ($row = mysqli_fetch_array($ret)) {
                                                ?>
                                                    <tr>
                                                        <th>Nominee</th>
                                                        <td><b><?php echo $row['name']; ?></b></td>
						   </tr>
						<!--
						   <tr>
                                                        <th>Nominated By</th>
                                                        <td><?php echo $row['nominated_by']; ?></td>
						   </tr>
						   <tr>
                                                        <th>Year Inducted</th>
                                                        <td><?php echo $row['year_inducted']; ?></td>
                                                    </tr>
                                                    <tr>
                                                        <th>Background/Work Experience</th>
                                                        <td><?php echo $row['vita']; ?></td>
                                                    </tr>
                                                    <tr>
                                                        <th>Districts/Schools/Entities Served</th>
                                                        <td><?php echo $row['location']; ?></td>
                                                    </tr>
						  -->
                                                    <tr>
                                                        <th>Contributions to Tech-Geeks</th>
                                                        <td><?php echo $row['all_contributions']; ?></td>
                                                    </tr>
                                                <?php
                                                    $cnt = $cnt + 1;
                                                } ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                <div class="card-footer">
                                <a href="show_members.php" class="btn btn-primary"><i class="bi bi-arrow-left-circle"></i>&nbsp; Back to All Members</a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </main>

        <?php include("includes/footer.php"); ?>
        
    </div>

</body>

</html>