diff options
Diffstat (limited to 'report')
-rw-r--r-- | report/edit.php | 14 | ||||
-rw-r--r-- | report/update.php | 5 |
2 files changed, 16 insertions, 3 deletions
diff --git a/report/edit.php b/report/edit.php index ef289bd..cd2e1a8 100644 --- a/report/edit.php +++ b/report/edit.php @@ -14,8 +14,9 @@ $title = ""; $submitter = $_SESSION['user_name']; $description = ""; +$conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']); + 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 reports JOIN users ON reports.author=users.id WHERE reports.id=:report_id"); @@ -28,6 +29,9 @@ if($id != "") { $description = $result['description']; } +# get bug id's +$bugs = $conn->query("SELECT id, title FROM bugs"); + ?> <form action="update.php?id=<?php echo $id; ?>" method="post"> @@ -35,6 +39,14 @@ if($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> +<p>Assign to bug: <select name="bug_id"> +<option value="">None</option> +<?php +foreach($bugs as $bug) { + echo "<option value=$bug[id]>$bug[title]</option>"; +} +?> +</select></p> <input type="submit" value="submit" > </form> diff --git a/report/update.php b/report/update.php index 0fadb53..c8ef12b 100644 --- a/report/update.php +++ b/report/update.php @@ -7,8 +7,8 @@ require_once(LIBRARY_PATH . "/functions.php"); if(session_set()) { $conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']); $query = $_POST['id'] == "" ? - $conn->prepare("INSERT INTO reports (author, title, description) VALUES (:user_id, :title, :description)") - : $conn->prepare("UPDATE reports SET title=:title, description=:description WHERE id=:report_id"); + $conn->prepare("INSERT INTO reports (author, title, description, bug) VALUES (:user_id, :title, :description, :bug_id)") + : $conn->prepare("UPDATE reports SET title=:title, description=:description, bug=:bug_id WHERE id=:report_id"); if($_POST['id'] == "") { $query->bindParam(':user_id', $_SESSION['user_id']); } else { @@ -16,6 +16,7 @@ if(session_set()) { } $query->bindParam(':title', $_POST['title']); $query->bindParam(':description', $_POST['description']); + $query->bindValue(':bug_id', $_POST['bug_id'] == "" ? null : $_POST['bug_id']); if($query->execute()) { echo "<h2>report submitted</h2>"; } else { |