From fd4cb27121122d146b8cc3d55ad5aa9312c2cbe6 Mon Sep 17 00:00:00 2001
From: Aqua-sama <aqua@iserlohn-fortress.net>
Date: Wed, 7 Apr 2021 11:49:12 +0300
Subject: Initial commit

---
 view.php | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 view.php

(limited to 'view.php')

diff --git a/view.php b/view.php
new file mode 100644
index 0000000..c10c9c8
--- /dev/null
+++ b/view.php
@@ -0,0 +1,26 @@
+<?php
+require 'config.php';
+require_once(TEMPLATES_PATH . "/header.php");
+require_once(TEMPLATES_PATH . "/panel.php");
+
+if(!isset($_GET['id']) || $_GET['id'] == "") {
+    echo "<div id='error'>No bug selected, redirecting to index...</div>";
+    header('Refresh: 2; URL=index.php');
+
+} else {
+    if(isset($_SESSION['user_id']) && $_SESSION['user_id'] != "") {
+        echo "<p><a href=edit.php?id=$_GET[id]>Edit</a></p>";
+    }
+
+    $conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']);
+
+    $query = "SELECT title, description, users.username AS submitter FROM bugs JOIN users ON bugs.author = users.id WHERE bugs.id=$_GET[id]";
+    $result = $conn->query($query)->fetch();
+
+    echo "<p><b>$result[title]</b></p>";
+    echo "<p>Submitted by $result[submitter]</p>";
+    echo "<p>$result[description]</p>";
+}
+
+require_once(TEMPLATES_PATH . "/footer.php");
+?>
-- 
cgit v1.2.1