BlogScript/edit-shortener.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
<?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-upload"></i> Update Shortener</div>
                <div class="card-body">

				<?php

				$errors = [];

				if (isset($_POST['submitEditShortener'])) {

					$dupe = DB::getInstance()->selectOneByField('shorteners', 'shortener_original_url', $_POST['shortener_original_url']);

					if (!empty($dupe)) {
			            $errors[] = 'That <strong>Original URL</strong> is already in use please choose another.';
		            }

					if (!empty($errors) > 0) {

						foreach($errors as $error) {
							echo "<div class=\"alert alert-danger\" role=\"alert\"><i class=\"fas fa-exclamation-triangle\"></i> {$error}</div>";
						}

					} else {

						$u = DB::getInstance()->update(
							'shorteners',
							'shortener_id',
							$_POST['updateId'],
						[
							'shortener_original_url' => $_POST['shortener_original_url']
						]);

						stdmsg("Your <strong>Original URL</strong> has been <strong>updated</strong>.");

					}

				}

				?>

				<?php

				    $shortener = DB::getInstance()->selectValues("SELECT * FROM `shorteners` WHERE `shortener_id`='{$_GET['shortenerId']}'");

				?>

				<form action="edit-shortener.php?shortenerId=<?= $_GET['shortenerId']; ?>" method="post">

					<div class="mb-3">
						<label for="shortener_original_url" class="form-label"><strong>Original URL:</strong></label>
						<input type="text" class="form-control" id="shortener_original_url" name="shortener_original_url" value="<?= $shortener['shortener_original_url']; ?>" required>
					</div>

					<div class="mb-3">
						<label for="shortener_short" class="form-label"><strong>Short Code (optional):</strong></label>
						<input type="text" class="form-control" id="shortener_short" name="shortener_short" value="<?= $shortener['shortener_short']; ?>" disabled>
					</div>

					<input type="hidden" name="updateId" value="<?= $_GET['shortenerId']; ?>">
					<button type="submit" name="submitEditShortener" class="btn btn-success float-end"><i class="fas fa-upload"></i> Update</button>

				</form>

                </div>

			</div>

		</div>
	</div>

</main>

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