<?php
include 'Error.inc';
include 'HTMLTemplate.inc';
header('Content-Style-Type: text/css');

$page = array_key_exists('page', $_GET)? $_GET['page']: 1;
if ($page < 1) $page = 1;

$page_num = array_key_exists('page_num', $_GET)? $_GET['page_num']: 20;

$db = pg_connect('dbname=harimawobbs user=hari');

$r = pg_query($db, 'SELECT COUNT(*) FROM article;');
list($total) = pg_fetch_row($r);
pg_free_result($r);

$total_pages = (int)(($total + $page_num - 1) / $page_num);
if ($page > $total_pages) $page = $total_pages;
$offset = ($page - 1) * $page_num;

$sql = "SELECT id, TO_CHAR(posttime, 'YYYY/MM/DD HH:MI:SS') AS date, name, title, message, ip FROM article ORDER BY posttime DESC LIMIT $page_num OFFSET $offset;";
$r = pg_query($db, $sql);
$article = array();
while ($o = pg_fetch_object($r)) $article[] = $o;
pg_free_result($r);

pg_close($db);

$temp = new HTMLTemplate('list.html');

$values = (object)array(
	'article' => $article,
);

echo $temp->replace($values);
?>