num_rows; $q = "SELECT product.product_id, product.product_name, product.path, category.category_name, brand.brand_name, pack_model.model FROM product JOIN category ON product.category_category_id = category.category_id JOIN brand ON product.brand_brand_id = brand.brand_id JOIN pack_model ON product.pack_model_pack_model_id = pack_model.pack_model_id"; $rs = Database::search($q); while ($row = $rs->fetch_assoc()) { // Price $pid = $row['product_id']; $w_rs = Database::search("SELECT price, offer_price FROM weight WHERE product_product_id = '$pid' ORDER BY offer_price ASC LIMIT 1"); $w_data = $w_rs->fetch_assoc(); $price = 0.00; $original_price = 0.00; if ($w_data) { $price = (float) $w_data['offer_price']; $original = (float) $w_data['price']; if ($original > $price) { $original_price = $original; } } // Image $image = !empty($row['path']) ? $row['path'] : "../teaCup.png"; // Category mapping $cat = $row['category_name']; $lower_cat = strtolower($cat); if (in_array($lower_cat, ['black', 'green', 'white', 'oolong', 'herbal'])) { $cat = 'Tea'; } $cat = ucfirst($cat); $sub_cat = ucfirst($row['category_name']); // Weights $weight_names_rs = Database::search("SELECT weight_name FROM weight WHERE product_product_id = '$pid' ORDER BY weight_id ASC"); $weight_list = []; while ($wr = $weight_names_rs->fetch_assoc()) { $weight_list[] = $wr['weight_name']; } $weights_str = implode(', ', $weight_list); $products_array[] = [ 'id' => (int) $row['product_id'], 'name' => $row['product_name'], 'category' => $cat, 'sub_category' => $sub_cat, 'origin' => "Sri Lanka", 'brand' => $row['brand_name'], 'model' => $row['model'], 'weights' => $weights_str, 'price' => $price, 'original_price' => $original_price, 'image' => $image, 'images' => [$image], 'rating' => 5.0 ]; } ?> Shop Premium Teas | Dropti Zeylona
The Collection

Lose yourself in our
world of tea

0 Elixirs Found