aboutsummaryrefslogtreecommitdiff
path: root/view.php
blob: 2468abbb1ada509a03ad07f239d95b7c9e18359d (plain)
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
<?php
require 'config.php';
require_once(TEMPLATES_PATH . "/header.php");
require_once(TEMPLATES_PATH . "/panel.php");
require_once(LIBRARY_PATH . "/parsedown.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']);
    $markdown = new Parsedown();

    $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>' . $markdown->text($result['description']) . '</p>';
}

require_once(TEMPLATES_PATH . "/footer.php");
?>