Upload
query('SELECT
p.ID as POST_ID,
p.TIMESTAMP,
pi.ID as PIC_ID,
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['POST_ID'];
$pic_id = $post['PIC_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 '
';
}
?>