From 5cda80fcdd44ec6ff8a6cc0c781c5a2e28aec8f9 Mon Sep 17 00:00:00 2001
From: Gabriel Dunne <gdunne@quilime.com>
Date: Tue, 19 Mar 2013 19:16:21 -0700
Subject: [PATCH] Added web index.

---
 www/index.php | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 www/index.php
diff --git a/www/index.php b/www/index.php
new file mode 100644
index 0000000..e799e5b
--- /dev/null
+++ b/www/index.php
@@ -0,0 +1,23 @@
+<?php
+
+    $dbh = new PDO( 'sqlite:agg.db' );
+    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+    $q = sprintf("  SELECT * FROM entries as e ORDER BY e.added DESC ");
+    $result = $dbh->query($q);
+?>
+<!DOCTYPE html>
+<head>
+    <style>
+        body { font-family: sans-serif; }
+        ul, li { list-style-type: none; }
+        li { margin-bottom:20px; }
+    </style>
+</head>
+
+</body>
+<h1>agg/v</h1>
+<? foreach($result as $row): ?>
+    <li>
+    <a href="<?=$row['url']?>"><?=$row['title'] == "" ? basename($row['url']) : $row['title']; ?></a>
+    </li>
+<? endforeach; ?>
-- 
2.34.1

