Upload
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 "";
echo "
";
echo "
{$comment_text}
";
echo '
';
}
?>