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`).
wget 'https://sme10.lists2.roe3.org/tg-hof/members/show_members.php'<?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> 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; ?>">« 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 »</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>
wget 'https://sme10.lists2.roe3.org/tg-hof/members/view_member.php'<?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> Back to All Members</a>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
<?php include("includes/footer.php"); ?>
</div>
</body>
</html>