get_results($Stag)) {
foreach ($rs as $r) {
$info = [
'name' => stripslashes($r->Ten),
'link'=> stripslashes($r->URL),
];
// Da ngon ngu
if(MULTI_LANGUAGE && lc()!=DEFAULT_LANGUAGE){
$ss = "SELECT * FROM ".PREFIX_NAME."tag_lg".SUPFIX_NAME."
WHERE tagID='".$r->tagID."' ".lw('AND');
if($rr = $dx->get_row($ss)){
$info['name'] = stripslashes($rr->Ten);
}
}
$taglist[] = $info;
}
}
?>
Tag:
Sản phẩm liên quan
get_results($ps)){
foreach($ps as $pr){
$s = "SELECT * FROM ".PREFIX_NAME."sku".SUPFIX_NAME." WHERE SKU='".$pr->SKU."' LIMIT 1";
if($r = $dx->get_row($s)) {
$info = [
'name' => stripslashes($pr->Ten),
'sku' => stripslashes($pr->SKU),
'price' => format_money($pr->Giaban,'đ',lg("Contact")),
'price_schema' => stripslashes($pr->Giaban),
'checkgia' => stripslashes($pr->checkgia),
'promo' => format_money($pr->GiaKM,'đ',0),
'brief' => Html2Text($pr->Tomtat,150),
'mota' =>Html2Text($pr->Mota,1000),
'link' => URL_Rewrite('trang-suc',$r->URL),
'Danhmuc' => stripslashes($pr->Danhmuc),
'promID' => stripslashes($pr->promID),
'promID_Vitri' => stripslashes($pr->promID_Vitri),
'promID_Vitri_left' => stripslashes($pr->promID_Vitri_left),
'metal' => stripslashes($pr->metal),
'colorID' => stripslashes($pr->colorID),
];
// Da ngon ngu
if(MULTI_LANGUAGE && lc()!=DEFAULT_LANGUAGE){
$ss = "SELECT * FROM ".PREFIX_NAME."product_lg".SUPFIX_NAME."
WHERE lgID='".$pr->proID."' ".lw('AND');
if($rr = $dx->get_row($ss)){
$info['name'] = stripslashes($rr->Ten);
$info['brief'] = CutString($rr->Tomtat,150);
}
}
$whs = '';
if(empty($colorID)){
$colorIDss = $pr->colorID;
$whs = ($whs==''?'AND':'')."(colorID='$colorIDss')";
}else{
$whs = ($whs==''?'AND':'')."(colorID='$colorID')";
}
$sql_img = "SELECT * FROM ".PREFIX_NAME."product_color_img".SUPFIX_NAME." WHERE proID='".$pr->proID."'
$whs LIMIT 1";
if($rm = $dx->get_row($sql_img)) {
$image = $rm->Anh;
$thumb = $rm->Anh;
$rias = $rm->Anh;
}else{
$image = 'img/noimages.jpg';
$thumb ='img/noimages.jpg';
$rias = 'img/noimages.jpg';
}
$info['image'] = $image;
$info['thumb'] = $thumb;
$info['rias'] = $rias;
}
$list[] = $info;
}
}
?>