36092-vm/unsubscribe_weather.php
Flatlogic Bot 301e490568 op
2025-11-23 07:47:10 +00:00

33 lines
1.1 KiB
PHP

<?php
require_once __DIR__ . '/db/config.php';
session_start();
header('Content-Type: application/json');
if (!isset($_SESSION['user_id'])) {
echo json_encode(['success' => false, 'message' => 'You must be logged in to unsubscribe.']);
exit;
}
$data = json_decode(file_get_contents('php://input'), true);
$subscription_id = $data['subscription_id'] ?? null;
if (!$subscription_id) {
echo json_encode(['success' => false, 'message' => 'Subscription ID is required.']);
exit;
}
try {
$pdo = db();
$stmt = $pdo->prepare("DELETE FROM weather_subscriptions WHERE id = ? AND user_id = ?");
$stmt->execute([$subscription_id, $_SESSION['user_id']]);
if ($stmt->rowCount() > 0) {
echo json_encode(['success' => true, 'message' => 'Unsubscribed successfully!']);
} else {
echo json_encode(['success' => false, 'message' => 'Subscription not found or you do not have permission to delete it.']);
}
} catch (PDOException $e) {
echo json_encode(['success' => false, 'message' => 'Database error: ' . $e->getMessage()]);
}
?>