prepare('SELECT * FROM user_services WHERE user_id = ? AND service_id = ?'); $p->execute([$user_id, $service_id]); $existing_subscription = $p->fetch(); if (!$existing_subscription) { $p = db()->prepare('INSERT INTO user_services (user_id, service_id) VALUES (?, ?)'); $p->execute([$user_id, $service_id]); } header('Location: subscribe.php'); exit(); } $p = db()->prepare('SELECT * FROM services'); $p->execute(); $services = $p->fetchAll(); $p = db()->prepare('SELECT service_id FROM user_services WHERE user_id = ?'); $p->execute([$user_id]); $subscribed_services = $p->fetchAll(PDO::FETCH_COLUMN); ?>

Subscribe to Services

Browse our available services and subscribe to the ones you need.