BlogScript/pages.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
<?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-file-word"></i> Pages <span class="badge bg-success float-end"><a href="new-page.php" class="badge badge-primary badge-sm text-decoration-none" data-bs-toggle="tooltip" data-bs-placement="bottom" title="Create a new page">New Page</a></span></div>
                <div class="card-body">

				<?php

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

					try {

						$delete = DB::getInstance()->remove('pages', 'page_id', $_GET['pageId']);
						if ($delete) {
							stdmsg("The <strong>page</strong> has been <strong>deleted</strong>.");
						}

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

				}

				?>

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

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

							<tr>
							    <td><?= $page['page_id']; ?></td>
								<td><a href="<?= urlFull(); ?>page.php?page=<?= $page['page_slug']; ?>" class="text-decoration-none"><?= $page['page_name']; ?></a></td>
								<td><?= date("m.d.y", strtotime($page['page_date'])); ?></td>
								<td class="text-center"><a href="edit-page.php?pageId=<?= $page['page_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="pages.php?delete=1&amp;pageId=<?= $page['page_id']; ?>" onClick="return confirm('Delete the page?')" 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");
?>