88310fffb065bb7f00c5bb91df39148194504c1b
3 <link rel
="stylesheet" href
="style.css">
8 <a href
='upload.php'>Upload
</a
>
11 require_once __DIR__
. '/db.php';
14 $posts = $db->query('SELECT
15 p.ID, p.TIMESTAMP, pi.MIME_TYPE, pi.PIC_B64, c.BODY
17 JOIN pics pi on p.id = pi.post_id
18 JOIN comments c on p.id = c.post_id
19 ORDER BY p.TIMESTAMP DESC');
20 while ($post = $posts->fetchArray()) {
21 $mime_type = $post['MIME_TYPE'];
22 $file_b64 = $post['PIC_B64'];
23 $post_id = $post['ID'];
24 $comment_text = $post['BODY'];
26 $img->readImageBlob(base64_decode($file_b64));
27 $img->setImageCompressionQuality(85);
28 $img->adaptiveResizeImage(480, 0);
29 $compressed_b64 = base64_encode($img->getImageBlob());
31 echo "<div id='post-{$post_id}'>";
33 echo "<img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/>";
34 echo "<p>{$comment_text}</p>";