[pics.git] / index.php

<html>
<a href='upload.php'>Upload</a>
<?php

require_once __DIR__ . '/db.php';

$db = get_db();
$posts = $db->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 "<div id='post-{$post_id}'>";

  echo "<img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/>";
  echo "<p>{$comment_text}</p>";
  echo '</div>';
}
?>
<div>footer</div>
</html>
Commit	Line	Data
	1	<html>
	2	<a href='upload.php'>Upload</a>
	3	<?php
	4
	5	require_once __DIR__ . '/db.php';
	6
	7	$db = get_db();
	8	$posts = $db->query('SELECT
	9	p.ID, p.TIMESTAMP, pi.MIME_TYPE, pi.PIC_B64, c.BODY
	10	FROM posts p
	11	JOIN pics pi on p.id = pi.post_id
	12	JOIN comments c on p.id = c.post_id
	13	ORDER BY p.TIMESTAMP DESC');
	14	while ($post = $posts->fetchArray()) {
	15	$mime_type = $post['MIME_TYPE'];
	16	$file_b64 = $post['PIC_B64'];
	17	$post_id = $post['ID'];
	18	$comment_text = $post['BODY'];
	19	$img = new Imagick();
	20	$img->readImageBlob(base64_decode($file_b64));
	21	$img->setImageCompressionQuality(85);
	22	$img->adaptiveResizeImage(480, 0);
	23	$compressed_b64 = base64_encode($img->getImageBlob());
	24
	25	echo "<div id='post-{$post_id}'>";
	26
	27	echo "<img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/>";
	28	echo "<p>{$comment_text}</p>";
	29	echo '</div>';
	30	}
	31	?>
	32	<div>footer</div>
	33	</html>