$db_content = new db_query($sql_news_content); $row = mysqli_fetch_assoc($db_content->result); unset($db_content); $detail_data['new_detail'] = $row['ndt_content']; $datetime_facebook = $detail_data['new_date']; $datetime_detail_timestamp = $detail_data['new_date']; $detail_data['new_date'] = getDateTime(1, 1, 1, 1, '', $detail_data['new_date']); $detail_data['link_cat'] = generate_cat_url($detail_data); $detail_data['new_picture'] = get_picture_path($detail_data['new_picture'], 'large'); $detail_data['facebook_share_link'] = 'http://khang.vn' . generate_news_detail_url($detail_data); $detail_data['facebook_social'] = array(); $detail_data['facebook_social']['like'] = get_facebook_like_button($detail_data['facebook_share_link']); $detail_data['facebook_social']['comment'] = get_facebook_comment_frame($detail_data['facebook_share_link']); $detail_data['facebook_social']['embed'] = get_facebook_embedded_post($detail_data['facebook_share_link']); $detail_data['new_teaser'] = $detail_data['new_teaser'] ? $detail_data['new_teaser'] : cut_string(removeHTML($detail_data['new_detail']), 200, '...'); $color_cat = get_color_category($detail_data['cat_id']); $rainTpl->assign('color_cat', $color_cat); $rainTpl->assign('page_title', $detail_data['new_title']); $rainTpl->assign('detail_data', $detail_data); //query ra các tin cùng chuyên mục $sql_cat_list_news = 'SELECT new_id, new_picture, new_title, cat_name FROM news LEFT JOIN categories ON cat_id = new_cat_id WHERE new_cat_id = ' . $detail_data['cat_id'] . ' AND new_active = 1 AND new_id <> ' . $iNews . ' AND new_date <= ' . $datetime_detail_timestamp . ' ORDER BY new_date DESC LIMIT 3'; $db_cat_news = new db_query($sql_cat_list_news);
cat_name, new_view FROM news LEFT JOIN categories ON cat_id = new_cat_id WHERE new_active = 1 AND new_date >= ' . MIN_TIME_NEWS_HOT . ' ORDER BY new_view DESC LIMIT 0,6'; $db_list_home = new db_query($sql_list_home); $list_home = array(); while ($row = mysqli_fetch_assoc($db_list_home->result)) { $row['new_title'] = htmlspecialbo($row['new_title']); $row['new_picture'] = get_picture_path($row['new_picture'], 'small'); $row['new_date'] = date('d \\T\\h m, Y, h:i a', $row['new_date']); $row['new_view'] = number_format($row['new_view']); $row['link_cat'] = generate_cat_url($row); $row['color_cat'] = get_color_category($row['cat_id']); $row['link_detail'] = generate_news_detail_url($row); $list_home[] = $row; } $rainTpl->assign('list_home', $list_home); //lấy ra các category, mỗi category 3 tin mới nhất - trừ mục tin sức khỏe $list_news_category = array(); $cat_tsk = $list_category[1]; foreach ($list_category as $cat_temp) { //bỏ qua tin sức khỏe if ($cat_tsk['cat_id'] == $cat_temp['cat_id'] || $cat_tsk['cat_id'] == 0) { continue; } $db_query = new db_query('SELECT new_id, new_title, new_picture,
} $detail_data['link_cat_next'] = generate_cat_url($detail_data, $iPage + 1); $detail_data['cat_title'] = $detail_data['cat_title'] ? $detail_data['cat_title'] : $detail_data['cat_name'] . ' | Khang.vn - Cẩm nang sức khỏe'; //list category $list_category = get_all_categories($iCat); $count_list_cate = count($list_category) - 2; $list_category2 = array_slice($list_category, 1, $count_list_cate); $rainTpl->assign('list_categories', $list_category); $rainTpl->assign('list_categories_slice', $list_category2); $rainTpl->assign('detail_data', $detail_data); $rainTpl->assign('iPage', $iPage); $rainTpl->assign('page_title', $detail_data['cat_title']); $rainTpl->assign('base_search_url', '/search'); $rainTpl->assign('meta_description', get_meta_description_category($detail_data)); $rainTpl->assign('meta_keyword', get_meta_keyword_category($detail_data)); $rainTpl->assign('color_cat', get_color_category($detail_data['cat_id'])); $rainTpl->assign('adv_top', $adv_top); $rainTpl->assign('adv_right', $adv_right); $rainTpl->assign('link_hoidap', generate_qaa_url()); //quảng cáo banner $rainTpl->assign('adv_banner_list', $adv_banner_list); if ($is_pjax) { include_once '../includes/pjax/inc_cat_pjax.php'; exit; } include_once '../includes/inc_cat.php'; $facebook_og = ' <meta property="og:site_name" content="Khang.vn - Cẩm nang sức khỏe cho mọi nhà"/> <meta property="og:title" content="Thông tin y tế, sức khỏe cộng đồng"/> <meta property="og:type" content="website" /> <meta property="og:url" content="http://khang.vn' . $detail_data['link_cat'] . '" />