prepare(" SELECT SUM(ci.quantity) FROM cart_items ci JOIN carts c ON ci.cart_id = c.id WHERE c.user_id = ? "); $stmt_cart->execute([$_SESSION['user_id']]); $cart_count = intval($stmt_cart->fetchColumn()); } // Get notifications and live order tracking statuses specifically for logged-in user $unread_notifs = []; $my_orders_tracking = []; if (isset($_SESSION['user_id'])) { $current_uid = intval($_SESSION['user_id']); // Fetch ONLY unread notifications for this logged-in user ID $stmt_notif = $db->prepare("SELECT * FROM notifications WHERE user_id = ? AND is_read = 0 ORDER BY created_at DESC LIMIT 5"); $stmt_notif->execute([$current_uid]); $unread_notifs = $stmt_notif->fetchAll(); // Fetch ONLY active ongoing orders placed by this logged-in user ID $stmt_my_orders = $db->prepare(" SELECT o.id, o.order_no, o.status, o.net_amount, o.created_at, o.updated_at FROM orders o WHERE o.user_id = ? AND o.status NOT IN ('received', 'cancelled') ORDER BY o.updated_at DESC LIMIT 5 "); $stmt_my_orders->execute([$current_uid]); $my_orders_tracking = $stmt_my_orders->fetchAll(); } ?>