prepare("SELECT * FROM favorite_locations WHERE user_id = ? ORDER BY city_name ASC"); $stmt->execute([$user_id]); $favorite_locations = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt = $pdo->prepare("SELECT ws.*, fl.city_name FROM weather_subscriptions ws JOIN favorite_locations fl ON ws.location_id = fl.id WHERE ws.user_id = ?"); $stmt->execute([$user_id]); $subscriptions = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { error_log("DB Error: " . $e->getMessage()); } ?>

User Profile

Email:

User Profile

Favorite Locations

Your Subscriptions