From fd4cb27121122d146b8cc3d55ad5aa9312c2cbe6 Mon Sep 17 00:00:00 2001
From: Aqua-sama <aqua@iserlohn-fortress.net>
Date: Wed, 7 Apr 2021 11:49:12 +0300
Subject: Initial commit

---
 index.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 index.php

(limited to 'index.php')

diff --git a/index.php b/index.php
new file mode 100644
index 0000000..5e79ca7
--- /dev/null
+++ b/index.php
@@ -0,0 +1,27 @@
+<?php
+require 'config.php';
+require_once(TEMPLATES_PATH . "/header.php");
+require_once(TEMPLATES_PATH . "/panel.php");
+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';
+if(isset($_GET['term']) && $_GET['term'] != "") {
+    echo "where the title contains: $_GET[term]";
+    $query = $query . " WHERE title LIKE '%$_GET[term]%'";
+}
+
+echo "<table style='width:80%'>\n";
+echo "<tr><th>Title</th><th>Description</th><th>Submitter</th></tr>\n";
+foreach ($conn->query($query) as $row) {
+    echo "<tr>\n";
+    echo "<td><a href=view.php?id=$row[id]>$row[title]</a></td>\n";
+    echo "<td>" . truncate($row['description']) . "</td>\n";
+    echo "<td>$row[submitter]</td>\n";
+    echo "</tr>\n";
+}
+echo "</table>\n";
+
+require_once(TEMPLATES_PATH . "/footer.php");
+?>
-- 
cgit v1.2.1