[pics.git] / app.php

<html>
<head>
<link rel="stylesheet" href="style.css">
<link rel="alternate" title="Pics dot JC" type="application/rss+xml" href="/rss.xml">
</head>

<body>
<main>
<a href='upload'>Upload</a>
<?php

require_once __DIR__ . '/db.php';

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

  echo "<a href='pic/{$pic_id}'> <img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/></a>";
  echo "<p>{$comment_text}</p>";
  echo '</div>';
}
?>
</main>
</body>
</html>
Commit	Line	Data
bcb1d27e JC	1	<html>
	2	<head>
	3	<link rel="stylesheet" href="style.css">
	4	<link rel="alternate" title="Pics dot JC" type="application/rss+xml" href="/rss.xml">
	5	</head>
	6
	7	<body>
	8	<main>
	9	<a href='upload'>Upload</a>
	10	<?php
	11
	12	require_once __DIR__ . '/db.php';
	13
	14	$db = get_db();
	15	$posts = $db->query('SELECT
2f6fa662 JC	16	p.ID as POST_ID,
	17	p.TIMESTAMP,
	18	pi.ID as PIC_ID,
	19	pi.MIME_TYPE,
	20	pi.PIC_B64,
	21	c.BODY
bcb1d27e JC	22	FROM posts p
	23	JOIN pics pi on p.id = pi.post_id
	24	JOIN comments c on p.id = c.post_id
	25	ORDER BY p.TIMESTAMP DESC');
	26	while ($post = $posts->fetchArray()) {
	27	$mime_type = $post['MIME_TYPE'];
	28	$file_b64 = $post['PIC_B64'];
2f6fa662 JC	29	$post_id = $post['POST_ID'];
2f6fa662 JC	30	$pic_id = $post['PIC_ID'];
bcb1d27e JC	31	$comment_text = $post['BODY'];
	32	$img = new Imagick();
	33	$img->readImageBlob(base64_decode($file_b64));
	34	$img->setImageCompressionQuality(85);
	35	$img->adaptiveResizeImage(480, 0);
	36	$compressed_b64 = base64_encode($img->getImageBlob());
	37
	38	echo "<div id='post-{$post_id}'>";
	39
2f6fa662	40	echo "<a href='pic/{$pic_id}'> <img src='data:{$mime_type};base64,{$compressed_b64}' alt='$'/></a>";
bcb1d27e JC	41	echo "<p>{$comment_text}</p>";
	42	echo '</div>';
	43	}
	44	?>
	45	</main>
	46	</body>
	47	</html>