Most recent articles
$cdb = new ControlPadDB();
$dbh = $cdb->dbh;
$news = Frontend::getAllNews($_GET);
$returnArray['q_count'] = $news['q_count'];
$returnArray['q'] = $news['q'];
$returnArray['v'] = $news['v'];
$stmt_c = $dbh->prepare($returnArray['q_count']);
$stmt_c->execute($returnArray['v']);
if ($row_c = $stmt_c->fetch(PDO::FETCH_ASSOC)) {
$count = $row_c['cnt'];
}
$num_rows = array('0' => intval($count));
$pages = new Paginator();
$pages->items_total = $num_rows[0];
$pages->mid_range = 9; // Number of pages to display. Must be odd and > 3
$pages->default_ipp = 10;
$pages->paginate();
// echo $pages->display_pages();
//echo "" . $pages->display_jump_menu() . $pages->display_items_per_page() . "";
$query = $returnArray['q'] . $pages->limit;
$stmt_res = $dbh->prepare($query);
$stmt_res->execute($returnArray['v']);
?>
$cnt = 1;
$column = 0;
$lang = CommonBase::isLanguageSet();
while ($row_news = $stmt_res->fetch(PDO::FETCH_ASSOC)) {
$id = CommonBase::encrypt($row_news['Id']);
$time = $month = date("l jS F Y", strtotime($row_news['news_date']));
if ($lang == "sin") {
$t = strip_tags($row_news['title_sin']);
$dis = CommonBase::limitWord(strip_tags($row_news['news_sin']), 400) . '...';
$dis = str_replace(' ', '', $dis);
$t = str_replace(' ', '', $t);
$read_more = '
';
} elseif ($lang == "eng") {
$t = strip_tags($row_news['title_eng']);
$dis = $row['news_eng'] . CommonBase::limitWord(strip_tags($row_news['news_eng']), 1000);
$read_more = '
';
} elseif ($lang == "tam") {
$t = strip_tags($row_news['title_tam']);
$dis = CommonBase::limitWord(strip_tags($row_news['news_tam']), 1000);
$read_more = '
';
}
?>


