if ($count > 0) {
//calculate the pages
$pages = $pagies->calculate_pages($count, $perPage, $p);
//get the activity records
$res = $DB->prepare("SELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\t`article_comments`.`id`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t`article_comments`.`added`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t`article_comments`.`author`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t`article_comments`.`article`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t`article_comments`.`text`, \r\n\t\t\t\t\t\t\t\t\t\t\t\t`account_data`.`displayName` AS `author_str` \r\n\t\t\t\t\t\t\t\t\t\t\tFROM `article_comments` \r\n\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `account_data` ON `account_data`.`id` = `article_comments`.`author` \r\n\t\t\t\t\t\t\t\t\t\t\tWHERE `article_comments`.`article` = :id \r\n\t\t\t\t\t\t\t\t\t\t\tORDER BY `article_comments`.`id` DESC \r\n\t\t\t\t\t\t\t\t\t\t\tLIMIT " . $pages['limit'] . ";");
$res->bindParam(':id', $ArticleID, PDO::PARAM_INT);
$res->execute();
//loop the records
while ($arr = $res->fetch()) {
echo '
<div class="comment_row" data-id="', $arr['id'], '">
<div class="headline">
<p><a href="', $config['BaseURL'], '/index.php?page=profile&uid=', $arr['author'], '">', $arr['author_str'], '</a> said:</p>
<span id="time" data-original="', $arr['added'], '">NaN</span>
</div>
<p class="comment">', Articles::parseTitle($arr['text']), '</p>
</div>';
}
}
unset($arr, $res);
?>
</div>
<?php
//Pagination
if ($count > 0 and $count > $perPage) {
echo '
<!-- Pagination -->
<br>
<div class="d-cont pagination-holder">
<h1><?php
echo $Count;
?>
Articles</h1>
<!--<p>/</p>
<h2><b>59</b> Comments</h2>-->
</div>
<?php
if ($Count > 0) {
while ($arr = $res->fetch()) {
echo '
<div class="article_short">
<a class="title" href="', $config['BaseURL'], '/index.php?page=article&id=', $arr['id'], '">', Articles::parseTitle($arr['title']), '</a><br/><br/>
<h4>', date('d M, Y', strtotime($arr['added'])), ' | ', $arr['views'], ' Views</h4>
<p>', Articles::parseTitle($arr['short_text']), '</p>
<a class="read_more" href="', $config['BaseURL'], '/index.php?page=article&id=', $arr['id'], '">Read More</a>
</div>';
}
} else {
echo 'There are no articles.';
}
?>
</div>
<div class="clear"></div>
</div>
<!-- Main side.End-->
