From 33fd114a314212b8759b525fb9e08d4ff4ca8869 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Tue, 14 Oct 2025 15:36:31 +0500 Subject: feat: web frontend --- web/index.php | 103 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 103 insertions(+) create mode 100644 web/index.php (limited to 'web/index.php') diff --git a/web/index.php b/web/index.php new file mode 100644 index 0000000..88c9711 --- /dev/null +++ b/web/index.php @@ -0,0 +1,103 @@ +prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count + FROM channel_words cw + INNER JOIN words w ON w.id = cw.word_id + INNER JOIN channels c ON c.alias_name = ? + INNER JOIN users u ON u.alias_name = ? + WHERE cw.channel_id = c.id AND cw.user_id = u.id + GROUP BY cw.word_id + ORDER BY usage_count DESC + LIMIT 100 + '); + $stmt->execute([$channel, $user]); +} else if (isset($channel)) { + $stmt = $db->prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count + FROM channel_words cw + INNER JOIN words w ON w.id = cw.word_id + INNER JOIN channels c ON c.alias_name = ? + WHERE cw.channel_id = c.id + GROUP BY cw.word_id + ORDER BY usage_count DESC + LIMIT 100 + '); + $stmt->execute([$channel]); +} else if (isset($user)) { + $stmt = $db->prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count + FROM channel_words cw + INNER JOIN words w ON w.id = cw.word_id + INNER JOIN users u ON u.alias_name = ? + WHERE cw.user_id = u.id + GROUP BY cw.word_id + ORDER BY usage_count DESC + LIMIT 100 + '); + $stmt->execute([$user]); +} else { + $stmt = $db->prepare('SELECT w.name, SUM(cw.usage_count) AS usage_count + FROM channel_words cw + INNER JOIN words w ON w.id = cw.word_id + GROUP BY cw.word_id + ORDER BY usage_count DESC + LIMIT 100 + '); + $stmt->execute(); +} + +$words = $stmt->fetchAll(PDO::FETCH_ASSOC); +?> + + + + + <?= INSTANCE_NAME ?> + + + + + + +
+
+
+
Search
+
+ + + +
+
+
+
+
+
+

+ Words +

+
+ +

No words.

+ + $word): ?> +
+

.

+

+

+
+ +
+
+
+
+
+ + + \ No newline at end of file -- cgit v1.2.3