c8f23f52ddd39f33560c6f2fcbc993dcd026db01
3 <link rel
="stylesheet" href
="style.css">
4 <link rel
="alternate" title
="Pics dot JC" type
="application/rss+xml" href
="/rss.xml">
9 <a href
='upload.php'>Upload
</a
>
12 require_once __DIR__
. '/db.php';
15 $posts = $db->query('SELECT
16 p.ID, p.TIMESTAMP, pi.MIME_TYPE, pi.PIC_B64, c.BODY
18 JOIN pics pi on p.id = pi.post_id
19 JOIN comments c on p.id = c.post_id
20 ORDER BY p.TIMESTAMP DESC');
21 while ($post = $posts->fetchArray()) {
22 $mime_type = $post['MIME_TYPE'];
23 $file_b64 = $post['PIC_B64'];
24 $post_id = $post['ID'];
25 $comment_text = $post['BODY'];
27 $img->readImageBlob(base64_decode($file_b64));
28 $img->setImageCompressionQuality(85);
29 $img->adaptiveResizeImage(480, 0);
30 $compressed_b64 = base64_encode($img->getImageBlob());
32 echo "<div id='post-{$post_id}'>";
34 echo "<img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/>";
35 echo "<p>{$comment_text}</p>";