aboutsummaryrefslogtreecommitdiff
path: root/bug/edit.php
blob: ad1ea3679b8d023393dac5390414bdf4c350a1f0 (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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
<?php
require '../config.php';
require_once(TEMPLATES_PATH . "/header.php");
require_once(TEMPLATES_PATH . "/panel.php");
require_once(LIBRARY_PATH . "/functions.php");

if(!session_set()) {
    echo "<div id='error'>Not logged in, redirecting to index...</div>";
    header("Refresh: 2; URL={$config['urls']['base']}");
    goto footer;
}

$id = isset($_GET['id']) ? $_GET['id'] : "";
$title = "";
$submitter = $_SESSION['user_name'];
$description = "";

if($id != "") {
    $conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']);
    $query = $conn->prepare("SELECT title, description, users.username AS submitter FROM bugs 
        JOIN users ON bugs.author=users.id WHERE bugs.id=:bug_id");
    $query->bindParam(':bug_id', $id);
    $query->execute();

    $result = $query->fetch();
    $title = $result['title'];
    $submitter = $result['submitter'];
    $description = $result['description'];
}
?>

<form action="update.php?id=<?php echo $id; ?>" method="post">
<input name="id" type="hidden" value="<?php echo $id; ?>">
<p>Title: <input name="title" type="text" value="<?php echo $title; ?>"></p>
<p>Submitted by: <?php echo $submitter; ?></p>
<p>Description: <br><textarea name="description" rows=25 cols=80><?php echo $description; ?></textarea></p>
<input type="submit" value="submit" >
</form>

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