while ($row = mysqli_fetch_assoc($db_query->result)) {
$i++;
$row['new_title'] = htmlspecialbo($row['new_title']);
$row['new_picture'] = get_picture_path($row['new_picture'], 'medium');
$row['new_date'] = date('d \\T\\h m, Y, h:i a', $row['new_date']);
$row['new_view'] = number_format($row['new_view']);
$row['cat_name'] = $cat_temp['cat_name'];
//first news of this cat
$row['is_first'] = $i == 1 ? 1 : 0;
$row['link_detail'] = generate_news_detail_url($row);
$list_temp[] = $row;
}
if (!$list_temp) {
continue;
}
$list_news_category[] = array('cat_id' => $cat_temp['cat_id'], 'cat_name' => $cat_temp['cat_name'], 'link_cat' => generate_cat_url($cat_temp), 'array_news' => $list_temp);
unset($db_query);
}
if (!$list_news_category) {
echo 'Trang đang cập nhật';
exit;
}
//lấy ra list tin sức khỏe hot
$list_news_tsk = array('cat_name' => $cat_tsk['cat_name'], 'link_cat' => $cat_tsk['link_cat'], 'array_news' => array());
$db_news_tsk_hot = new db_query('SELECT new_id,
new_title,
new_picture
FROM news
WHERE new_active = 1
AND new_cat_id = ' . $cat_tsk['cat_id'] . '
AND new_date >= ' . MIN_TIME_NEWS_HOT . '
if (!$detail_data) {
error_404_document();
}
//tăng view cho tin
$db_update_view = new db_execute('UPDATE news SET new_view = new_view + 1 WHERE new_id = ' . $iNews);
unset($db_update_view);
//lấy chi tiết tin
$sql_news_content = 'SELECT ndt_content FROM news_detail WHERE ndt_id = ' . $iNews;
$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,
function get_news_ban_co_biet($yyy = 4)
{
global $lllll;
if (isset($lllll['ban_co_biet'])) {
return $lllll['ban_co_biet'];
}
$oooooo = 3;
$ggggg = intval($yyy) * 5;
$jj = 'SELECT new_id,new_picture,new_title,cat_name,cat_id
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_cat_id = ' . $oooooo . '
AND new_active = 1
AND new_view >= ' . MIN_NEWS_VIEW . '
AND new_date <= ' . TIMESTAMP . '
AND new_date >= ' . MIN_TIME_NEWS_HOT . '
LIMIT ' . $ggggg;
$ll = new db_query($jj);
$kkkkkk = array();
while ($ooooo = mysqli_fetch_assoc($ll->result)) {
$ooooo['link_detail'] = generate_news_detail_url($ooooo);
$ooooo['new_title'] = htmlspecialbo($ooooo['new_title']);
$kkkkkk['link_cat'] = generate_cat_url($ooooo);
$kkkkkk['cat_name'] = $ooooo['cat_name'];
$kkkkkk['array_news'][] = $ooooo;
}
if (!$kkkkkk) {
$jj = 'SELECT new_id,new_picture,new_title,cat_name,cat_id
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_cat_id = ' . $oooooo . '
AND new_active = 1
AND new_date <= ' . TIMESTAMP . '
ORDER BY new_date DESC
LIMIT ' . $ggggg;
$ll = new db_query($jj);
while ($ooooo = mysqli_fetch_assoc($ll->result)) {
$ooooo['link_detail'] = generate_news_detail_url($ooooo);
$ooooo['new_title'] = htmlspecialbo($ooooo['new_title']);
$kkkkkk['link_cat'] = generate_cat_url($ooooo);
$kkkkkk['cat_name'] = $ooooo['cat_name'];
$kkkkkk['array_news'][] = $ooooo;
}
}
unset($ll);
shuffle($kkkkkk['array_news']);
$llllll = 0;
$mmmmmm = array();
foreach ($kkkkkk['array_news'] as $nnnnnn) {
$llllll++;
if ($llllll == 1) {
$nnnnnn['new_picture'] = get_picture_path($nnnnnn['new_picture'], 'medium');
$nnnnnn['is_first'] = 1;
}
if ($llllll > $yyy) {
break;
}
$mmmmmm[] = $nnnnnn;
}
$kkkkkk['array_news'] = $mmmmmm;
$lllll['ban_co_biet'] = $kkkkkk;
return $kkkkkk;
}
AND new_date <= ' . TIMESTAMP . '
AND new_cat_id = ' . $iCat . '
ORDER BY new_date DESC
LIMIT 5';
$db_news_release = new db_query($sql_news_release);
$news_release = array();
//xử lý để không lấy trùng tin so với list tin ở dưới
$string_query_unique = '';
if (mysqli_num_rows($db_news_release->result)) {
$string_query_unique = ' AND new_id NOT IN (';
while ($row = mysqli_fetch_assoc($db_news_release->result)) {
$row['new_title'] = htmlspecialbo($row['new_title']);
$row['new_picture'] = get_picture_path($row['new_picture'], 'large');
$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['link_detail'] = generate_news_detail_url($row);
$news_release[] = $row;
$string_query_unique .= $row['new_id'] . ',';
}
}
if ($string_query_unique) {
$string_query_unique = rtrim($string_query_unique, ',') . ') ';
}
unset($db_news_release);
$rainTpl->assign('news_release', $news_release);
//query ra tin hot ở cột bên phải của list tin danh mục
$sql_hot = 'SELECT new_id,
new_title,
cat_name
FROM news
$iCat = getValue('record_id', 'int', 'GET', 0);
$iPage = getValue('page', 'int', 'GET', 0);
$iPage = intval($iPage);
$iPage = $iPage > 1 ? $iPage : 1;
$limit_size = 10;
$db_detail_cat = new db_query('SELECT * FROM categories WHERE cat_id = ' . $iCat);
$detail_data = mysqli_fetch_assoc($db_detail_cat->result);
unset($db_detail_cat);
if (!$detail_data) {
error_404_document();
}
$detail_data['link_cat'] = generate_cat_url($detail_data);
if ($detail_data['cat_type'] == CATEGORY_TYPE_HOIDAP) {
move301(generate_qaa_url($detail_data));
}
$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);
$row['link_detail'] = generate_news_detail_url($row);
$list_hot_day[] = $row;
}
$rainTpl->assign('list_hot_day', $list_hot_day);
//lấy theo category, các bài
$list_news_cat = array();
$array_cat = get_category_news();
foreach ($array_cat as $cat_item) {
$db_query = new db_query('SELECT new_id, new_title, cat_name, new_picture
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_active = 1 AND new_date <= ' . TIMESTAMP . '
AND new_cat_id = ' . $cat_item['cat_id'] . '
ORDER BY new_date DESC
LIMIT 0,5');
$list_temp = array();
$first_news_temp = array();
$temp_count = 0;
while ($row = mysqli_fetch_assoc($db_query->result)) {
prepare_news_record($row, 'mobile');
$temp_count++;
if ($temp_count == 1) {
$first_news_temp = $row;
} else {
$list_temp[] = $row;
}
}
$list_news_cat[] = array('cat_id' => $cat_item['cat_id'], 'cat_name' => $cat_item['cat_name'], 'link_cat' => generate_cat_url($cat_item), 'first_news' => $first_news_temp, 'list_news' => $list_temp);
unset($db_query);
}
$rainTpl->assign('list_news_cat', $list_news_cat);
<url>
<loc><?php
echo DOMAIN_URL;
?>
/home/</loc>
<lastmod><?php
echo $lastmod_first;
?>
</lastmod>
<changefreq>daily</changefreq>
<priority>1.0</priority>
</url>;
<?php
$db = new db_query('SELECT * FROM categories WHERE cat_type = ' . CATEGORY_TYPE_NEWS);
while ($row = mysqli_fetch_assoc($db->result)) {
$link_cat = generate_cat_url($row);
?>
<url>
<loc><?php
echo DOMAIN_URL . $link_cat;
?>
</loc>
<?php
/*
<xhtml:link rel="alternate" media="only screen and max-width: 480px" href="http://m.24h.com.vn/" />
*/
?>
<lastmod><?php
echo $lastmod_first;
?>
</lastmod>
function get_news_ban_co_biet($number = 4)
{
global $_static_value;
if (isset($_static_value['ban_co_biet'])) {
return $_static_value['ban_co_biet'];
}
//id của danh mục bạn có biết
$id_cat = 3;
$limit_size = intval($number) * 5;
$sql = 'SELECT new_id,new_picture,new_title,cat_name,cat_id
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_cat_id = ' . $id_cat . '
AND new_active = 1
AND new_view >= ' . MIN_NEWS_VIEW . '
AND new_date <= ' . TIMESTAMP . '
AND new_date >= ' . MIN_TIME_NEWS_HOT . '
LIMIT ' . $limit_size;
$db_query = new db_query($sql);
$array_news = array();
while ($row = mysqli_fetch_assoc($db_query->result)) {
$row['link_detail'] = generate_news_detail_url($row);
$row['new_title'] = htmlspecialbo($row['new_title']);
$array_news['link_cat'] = generate_cat_url($row);
$array_news['cat_name'] = $row['cat_name'];
$array_news['array_news'][] = $row;
}
if (!$array_news) {
//nếu không có tin thì lấy tin bạn có biết mới nhất
$sql = 'SELECT new_id,new_picture,new_title,cat_name,cat_id
FROM news
LEFT JOIN categories ON cat_id = new_cat_id
WHERE new_cat_id = ' . $id_cat . '
AND new_active = 1
AND new_date <= ' . TIMESTAMP . '
ORDER BY new_date DESC
LIMIT ' . $limit_size;
$db_query = new db_query($sql);
while ($row = mysqli_fetch_assoc($db_query->result)) {
$row['link_detail'] = generate_news_detail_url($row);
$row['new_title'] = htmlspecialbo($row['new_title']);
$array_news['link_cat'] = generate_cat_url($row);
$array_news['cat_name'] = $row['cat_name'];
$array_news['array_news'][] = $row;
}
}
unset($db_query);
shuffle($array_news['array_news']);
$count = 0;
$return_news = array();
foreach ($array_news['array_news'] as $a_news) {
$count++;
if ($count == 1) {
$a_news['new_picture'] = get_picture_path($a_news['new_picture'], 'medium');
$a_news['is_first'] = 1;
}
if ($count > $number) {
break;
}
$return_news[] = $a_news;
}
$array_news['array_news'] = $return_news;
$_static_value['ban_co_biet'] = $array_news;
return $array_news;
}
