$sql_query = "SELECT * FROM setup_slider ORDER BY setup_slider_order ASC";
$result = mysql_query($sql_query) or die(mysql_error());
$found = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)){
$setup_slider_id = $row[setup_slider_id];
$setup_slider_title = $row[setup_slider_title];
$setup_slider_pic_dir = $dir_base . "/" . $setup_sliderpic["big"]["path"] . "/" . $setup_slider_id . ".jpg";
$setup_slider_pic_url = $url_base . "/" . $setup_sliderpic["big"]["path"] . "/" . $setup_slider_id . ".jpg";
?>
} ?>
Produk Baru
-
$sql_query = "
SELECT *
FROM setup_product, setup_category, setup_agerange, setup_brand
WHERE
setup_product_category = setup_category_id AND
setup_product_agerange = setup_agerange_id AND
setup_product_brand = setup_brand_id AND
setup_product_status = 'latest' AND
setup_product_stock > 0
ORDER BY RAND()
LIMIT 0, 8
";
$result = mysql_query($sql_query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
$setup_product_id = $row[setup_product_id];
$setup_product_category = $row[setup_category_title];
$setup_product_agerange = $row[setup_agerange_title];
$setup_product_brand = $row[setup_brand_title];
$setup_product_stock = $row[setup_product_stock];
$setup_product_status = $row[setup_product_status];
$setup_product_price_normal = $row[setup_product_price_amount_normal];
$setup_product_price_disc = $row[setup_product_price_amount_discounted];
$setup_product_title = $row[setup_product_title];
$setup_product_url = $row[setup_product_url];
$setup_product_add = $url_base . "/purchase/$setup_product_url/1/product$setup_product_id.html";
$setup_product_url = $url_base . "/product/$setup_product_url/product$setup_product_id.html";
$setup_product_keyword = $row[setup_product_keyword];
$setup_product_brief = $row[setup_product_brief];
$setup_product_content = $row[setup_product_content];
$setup_product_viewed = $row[setup_product_viewed_real];
$setup_product_date = strtotime($row[setup_product_date]);
$setup_product_date = date("d M Y", $setup_product_date);
$setup_product_pic_dir = $dir_base . "/" . $setup_productpic["med"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_url = $url_base . "/" . $setup_productpic["med"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_found = "no";
if (file_exists($setup_product_pic_dir)) {
$setup_product_pic_found = "yes";
}
?>
- } ?>
Produk Laris
-
$sql_query = "
SELECT *
FROM setup_product, setup_category, setup_agerange, setup_brand
WHERE
setup_product_category = setup_category_id AND
setup_product_agerange = setup_agerange_id AND
setup_product_brand = setup_brand_id AND
setup_product_status = 'bestseller' AND
setup_product_stock > 0
ORDER BY RAND()
LIMIT 0, 8
";
$result = mysql_query($sql_query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
$setup_product_id = $row[setup_product_id];
$setup_product_category = $row[setup_category_title];
$setup_product_agerange = $row[setup_agerange_title];
$setup_product_brand = $row[setup_brand_title];
$setup_product_stock = $row[setup_product_stock];
$setup_product_status = $row[setup_product_status];
$setup_product_price_normal = $row[setup_product_price_amount_normal];
$setup_product_price_disc = $row[setup_product_price_amount_discounted];
$setup_product_title = $row[setup_product_title];
$setup_product_url = $row[setup_product_url];
$setup_product_add = $url_base . "/purchase/$setup_product_url/1/product$setup_product_id.html";
$setup_product_url = $url_base . "/product/$setup_product_url/product$setup_product_id.html";
$setup_product_keyword = $row[setup_product_keyword];
$setup_product_brief = $row[setup_product_brief];
$setup_product_content = $row[setup_product_content];
$setup_product_viewed = $row[setup_product_viewed_real];
$setup_product_date = strtotime($row[setup_product_date]);
$setup_product_date = date("d M Y", $setup_product_date);
$setup_product_pic_dir = $dir_base . "/" . $setup_productpic["med"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_url = $url_base . "/" . $setup_productpic["med"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_found = "no";
if (file_exists($setup_product_pic_dir)) {
$setup_product_pic_found = "yes";
}
?>
- } ?>
Produk Promo
-
$sql_query = "
SELECT *
FROM setup_product, setup_category, setup_agerange, setup_brand
WHERE
setup_product_category = setup_category_id AND
setup_product_agerange = setup_agerange_id AND
setup_product_brand = setup_brand_id AND
setup_product_status = 'discount' AND
setup_product_stock > 0
ORDER BY RAND()
LIMIT 0, 8
";
$result = mysql_query($sql_query) or die(mysql_error());
while ($row = mysql_fetch_array($result)){
$setup_product_id = $row[setup_product_id];
$setup_product_category = $row[setup_category_title];
$setup_product_agerange = $row[setup_agerange_title];
$setup_product_brand = $row[setup_brand_title];
$setup_product_stock = $row[setup_product_stock];
$setup_product_status = $row[setup_product_status];
$setup_product_price_normal = $row[setup_product_price_amount_normal];
$setup_product_price_disc = $row[setup_product_price_amount_discounted];
$setup_product_title = $row[setup_product_title];
$setup_product_url = $row[setup_product_url];
$setup_product_add = $url_base . "/purchase/$setup_product_url/1/product$setup_product_id.html";
$setup_product_url = $url_base . "/product/$setup_product_url/product$setup_product_id.html";
$setup_product_keyword = $row[setup_product_keyword];
$setup_product_brief = $row[setup_product_brief];
$setup_product_content = $row[setup_product_content];
$setup_product_viewed = $row[setup_product_viewed_real];
$setup_product_date = strtotime($row[setup_product_date]);
$setup_product_date = date("d M Y", $setup_product_date);
$setup_product_pic_dir = $dir_base . "/" . $setup_productpic["med"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_url = $url_base . "/" . $setup_productpic["med"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_found = "no";
if (file_exists($setup_product_pic_dir)) {
$setup_product_pic_found = "yes";
}
?>
- } ?>
Categories
Popular
-
$i = 0;
$sql_query = "
SELECT *
FROM setup_product, setup_category, setup_agerange, setup_brand
WHERE
setup_product_category = setup_category_id AND
setup_product_agerange = setup_agerange_id AND
setup_product_brand = setup_brand_id AND
setup_product_status = 'popular' AND
setup_product_stock > 0
ORDER BY RAND()
LIMIT 0, 6
";
$result = mysql_query($sql_query) or die(mysql_error());
$total = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)){
$i++;
$setup_product_id = $row[setup_product_id];
$setup_product_category = $row[setup_category_title];
$setup_product_agerange = $row[setup_agerange_title];
$setup_product_brand = $row[setup_brand_title];
$setup_product_stock = $row[setup_product_stock];
$setup_product_status = $row[setup_product_status];
$setup_product_price_normal = $row[setup_product_price_amount_normal];
$setup_product_price_disc = $row[setup_product_price_amount_discounted];
$setup_product_title = $row[setup_product_title];
$setup_product_url = $row[setup_product_url];
$setup_product_add = $url_base . "/purchase/$setup_product_url/1/product$setup_product_id.html";
$setup_product_url = $url_base . "/product/$setup_product_url/product$setup_product_id.html";
$setup_product_keyword = $row[setup_product_keyword];
$setup_product_brief = $row[setup_product_brief];
$setup_product_content = $row[setup_product_content];
$setup_product_viewed = $row[setup_product_viewed_real];
$setup_product_date = strtotime($row[setup_product_date]);
$setup_product_date = date("d M Y", $setup_product_date);
$setup_product_pic_dir = $dir_base . "/" . $setup_productpic["sml"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_url = $url_base . "/" . $setup_productpic["sml"]["path"] . "/" . $setup_product_id . ".jpg";
$setup_product_pic_found = "no";
if (file_exists($setup_product_pic_dir)) {
$setup_product_pic_found = "yes";
}
if ($i == $total) {
$class = "bg_none";
}
?>
-