From: Jacob Casper <dev@jacobcasper.com>
Date: Sun, 26 Jun 2022 20:20:30 +0000 (-0500)
Subject: Render pictures at a canonical URL
X-Git-Url: https://git.jacobcasper.com/?p=pics.git;a=commitdiff_plain;h=fd25bf8779a37e731732f3978f5cef80704f00f9

Render pictures at a canonical URL

Spit out the full quality images when requested at their exact URL. This
allows use as a img src element or canonical url for the RSS enclosure
element to download.
---

diff --git a/index.php b/index.php
index c7b91bc..b5b343e 100644
--- a/index.php
+++ b/index.php
@@ -18,6 +18,9 @@ switch ($path) {
     case '':
         require './app.php';
         break;
+    case 'pic':
+        require './pic.php';
+        break;
     case 'upload':
         require './upload.php';
         break;
diff --git a/pic.php b/pic.php
new file mode 100644
index 0000000..ece33b9
--- /dev/null
+++ b/pic.php
@@ -0,0 +1,27 @@
+<?php
+    $id = array_shift($pieces);
+
+    if (empty($id)) {
+        header('HTTP/1.0 400 Bad Request');
+        die('400 Bad (Empty) Request');
+    }
+
+    require_once __DIR__ . '/db.php';
+
+    $db = get_db();
+    $fetch_stmt = $db->prepare('SELECT
+        pi.ID, pi.MIME_TYPE, pi.PIC_B64
+        FROM pics pi
+        WHERE pi.ID = :id');
+    $fetch_stmt->bindValue(':id', $id);
+    $result = $fetch_stmt->execute();
+    if ($pic = $result->fetchArray()) {
+        $mime_type = $pic['MIME_TYPE'];
+        $file_b64 = $pic['PIC_B64'];
+        $pic_id = $pic['ID'];
+        header("Content-Type: {$mime_type}");
+        die(base64_decode($file_b64, true));
+    }
+    header('HTTP/1.0 404 Not Found');
+    die('404 File Not Found');
+?>