BlogScript/users.php at master · grahammccann/BlogScript · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
<?php
    include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-sessions.php");
    include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-db-connection.php");
    include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-functions.php");
    include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-header.php");
?>


<main>

	<?php $user = getUsersDetails($member); ?>

	<?php

	if (!$user || $user['member_is_admin'] != "yes") {
		stderr("<strong>Protected</strong> page.");
		include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-footer.php");
		die();
	}

	?>

	<div class="row">

		<div class="col-md-3">

			<div class="card">
			<?php include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-dashboard.php"); ?>
			</div>

			<div class="card">
			<?php include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-dashboard-extended.php"); ?>
			</div>

		</div>

		<div class="col-md-9">
			<div class="card">
			  <div class="card-header"><i class="fas fa-users"></i> Users <span class="badge bg-success float-end"><a href="new-user.php" class="badge badge-primary badge-sm text-decoration-none" data-bs-toggle="tooltip" data-bs-placement="bottom" title="Create a new user">New User</a></span></div>
                <div class="card-body">

				<?php

				if (isset($_GET['delete'])) {

					try {

						$delete = DB::getInstance()->remove('members', 'member_id', $_GET['userId']);
						if ($delete) {
							stdmsg("The <strong>user</strong> has been <strong>deleted</strong>.");
						}

					} catch (Exception $e) {
						stdErr($e->getMessage());
					}

				}

				?>

				<?php $members = DB::getInstance()->select("SELECT * FROM `members`"); ?>

				<!-- DataTables -->
				<div class="table-responsive">
				<table class="table table-striped" id="tableUsers" width="100%" cellspacing="0">
				  <thead>
					<tr>
					  <th>ID</th>
					  <th>Name</th>
					  <th>Email</th>
					  <th>Admin</th>
					  <th>Added</th>
					  <th>&nbsp;</th>
					  <th>&nbsp;</th>
					</tr>
				  </thead>
				  <tfoot>
					<tr>
					  <th>ID</th>
					  <th>Name</th>
					  <th>Email</th>
					  <th>Admin</th>
					  <th>Added</th>
					  <th>&nbsp;</th>
					  <th>&nbsp;</th>
					</tr>
				  </tfoot>
				  <tbody>
						<?php foreach ($members as $member) { ?>

							<tr>
							    <td><?= $member['member_id']; ?></td>
								<td><?= $member['member_username']; ?></td>
								<td><a href="mailto:<?= $member['member_email']; ?>" class="text-decoration-none" target="_blank"><?= $member['member_email']; ?></span></td>
								<td class="text-center"><?= $member['member_is_admin'] == "yes" ? '<span class="badge bg-success">Yes</span>' : '<span class="badge bg-danger">No</span>'; ?></td>
								<td><?= date("m.d.y", strtotime($member['member_date'])); ?></td>
								<td class="text-center"><a href="edit-user.php?userId=<?= $member['member_id']; ?>" class="btn btn-warning btn-sm" role="button" data-bs-toggle="tooltip" data-bs-placement="bottom" title="Edit"><i class="fas fa-edit"></i></a></td>
								<td class="text-center"><a href="users.php?delete=1&amp;userId=<?= $member['member_id']; ?>" onClick="return confirm('Delete the user?')" class="btn btn-danger btn-sm" role="button" data-bs-toggle="tooltip" data-bs-placement="bottom" title="Delete"><i class="far fa-trash-alt"></i></a></td>
							</tr>

						<?php } ?>
				  </tbody>
				</table>
				</div>
                </div>
			</div>
		</div>
	</div>

</main>

<?php
    include($_SERVER['DOCUMENT_ROOT'] . "/includes/inc-footer.php");
?>