Bugs
Create\n";
}
# bugs query
$bugs = $conn->prepare("SELECT bugs.id AS id, title, description, users.username AS submitter
FROM bugs JOIN users ON bugs.author = users.id
WHERE title LIKE :term");
$bugs->bindValue(':term', isset($_GET['term']) ? '%' . $_GET['term'] : "%");
$bugs->execute();
if($bugs->rowCount() > 0) {
?>
Title | Description | Owner |
$row[title] | " . truncate($row['description']) . " | $row[submitter] | \n";
}
?>
No bugs found.\n";
}
?>
Reports
Create\n";
}
# reports query
$reports = $conn->query("SELECT reports.id AS id, title, description, users.username AS user
FROM reports JOIN users ON reports.author=users.id WHERE bug IS NULL ORDER BY id");
if($reports->rowCount() > 0) {
?>
Title | Description | Submitted by |
$row[title] | " . truncate($row['description']) . " | $row[user] | \n";
}
?>
No unassigned reports.\n";
}
require_once(TEMPLATES_PATH . "/footer.php");
?>