Implement routing

[pics.git] / app.php
diff --git a/app.php b/app.php

new file mode 100644 (file)

index 0000000..a3f2597
--- /dev/null
+++ b/app.php
@@ -0,0 +1,41 @@
+<html>
+<head>
+<link rel="stylesheet" href="style.css">
+<link rel="alternate" title="Pics dot JC" type="application/rss+xml" href="/rss.xml">
+</head>
+
+<body>
+<main>
+<a href='upload'>Upload</a>
+<?php
+
+require_once __DIR__ . '/db.php';
+
+$db = get_db();
+$posts = $db->query('SELECT
+  p.ID, p.TIMESTAMP, pi.MIME_TYPE, pi.PIC_B64, c.BODY
+  FROM posts p
+  JOIN pics pi on p.id = pi.post_id
+  JOIN comments c on p.id = c.post_id
+  ORDER BY p.TIMESTAMP DESC');
+while ($post = $posts->fetchArray()) {
+  $mime_type = $post['MIME_TYPE'];
+  $file_b64 = $post['PIC_B64'];
+  $post_id = $post['ID'];
+  $comment_text = $post['BODY'];
+  $img = new Imagick();
+  $img->readImageBlob(base64_decode($file_b64));
+  $img->setImageCompressionQuality(85);
+  $img->adaptiveResizeImage(480, 0);
+  $compressed_b64 = base64_encode($img->getImageBlob());
+
+  echo "<div id='post-{$post_id}'>";
+
+  echo "<img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/>";
+  echo "<p>{$comment_text}</p>";
+  echo '</div>';
+}
+?>
+</main>
+</body>
+</html>