From 4cee97e695c889445c3146bc8169a89b132855ea Mon Sep 17 00:00:00 2001
From: Aqua-sama
Date: Thu, 29 Apr 2021 18:04:56 +0300
Subject: Finish user management
---
index.php | 62 +++++++++++++++++++++++++++++++++++++++++++++++++++-----------
1 file changed, 51 insertions(+), 11 deletions(-)
(limited to 'index.php')
diff --git a/index.php b/index.php
index 5e79ca7..f63f3af 100644
--- a/index.php
+++ b/index.php
@@ -6,22 +6,62 @@ require_once(LIBRARY_PATH . "/functions.php");
$conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']);
-$query = 'SELECT bugs.id AS id, title, description, users.username AS submitter FROM bugs JOIN users ON bugs.author = users.id';
+?>
+Bugs
+
+query($bugs_q);
+if($bugs_r->rowCount() > 0) {
+?>
+
+Title | Description | Owner |
+$row[title] | " . truncate($row['description']) . " | $row[submitter] | \n";
+}
+?>
+
+
+Zero boogs found.
\n";
+}
+?>
+
+Reports
+Create\n";
+}
+
+# reports query
+$reports_q = 'SELECT title, description, author FROM reports WHERE bug IS NULL';
+
+$reports_r = $conn->query($reports_q);
+if($reports_r->rowCount() > 0) {
+?>
+
+
+Title | Description | Submitted by |
+$row[title] | " . truncate($row['description']) . " | $row[submitter] | \n";
}
+?>
+
-echo "\n";
-echo "Title | Description | Submitter |
\n";
-foreach ($conn->query($query) as $row) {
- echo "\n";
- echo "$row[title] | \n";
- echo "" . truncate($row['description']) . " | \n";
- echo "$row[submitter] | \n";
- echo "
\n";
+No unassigned reports.\n";
}
-echo "
\n";
require_once(TEMPLATES_PATH . "/footer.php");
?>
--
cgit v1.2.1