產品介紹
0) {
$cur_page = intval($_GET['page']);
$per_page = 9;
if ($cur_page < 1) $cur_page = 1;
if (!empty($goods_cat['off'])) {
$cat_off_ids_list = implode(',', $goods_cat['off']);
$search['condition'] = " AND main_cat_id NOT IN ({$cat_off_ids_list}) AND sub_cat_id NOT IN ({$cat_off_ids_list}) ";
}
$rsg = $conn->PageExecute("SELECT * FROM {$goods_table} WHERE (main_cat_id = ? OR sub_cat_id = ?) {$search['condition']} AND enabled = 1 AND (show_start IS NULL OR show_start <= curdate()) AND (show_end IS NULL OR show_end >= curdate()) ORDER BY sort_order DESC, id DESC", $per_page, $cur_page, array($param['cat_id'], $param['cat_id']));
if (!$rsg) die($conn->ErrorMsg());
$total_page = $rsg->LastPageNo();
if ($total_page < 0) $total_page = 0;
if ($cur_page > $total_page) $cur_page = $total_page;
while (!$rsg->EOF) {
$id = $rsg->fields['id'];
$pic = mq_runtime_decode($rsg->fields['pic']);
$title = htmlencode(mq_runtime_decode($rsg->fields['title']));
$price = $rsg->fields['price'];
if ($price > 0) {
$price = number_format($price);
$price = 'NT$ '.$price;
} else {
$price = '';
}
$stock = $rsg->fields['stock'];
$allow_os_purchase = $rsg->fields['allow_os_purchase'];
$can_buy = $stock > 0 || $allow_os_purchase;
?>
MoveNext();
}
$rsg->Close();
unset($rsg);
}
?>