prepare("SELECT * FROM habits WHERE id = ?");
$stmt->execute([$id]);
$habit = $stmt->fetch();
if (!$habit) {
die("Habit not found.");
}
$message = "";
// Handle update
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$title = $_POST['title'];
$description = $_POST['description'];
$frequency = $_POST['frequency'];
$specific_date = !empty($_POST['specific_date']) ? $_POST['specific_date'] : null;
$show_on_cal = isset($_POST['show_on_calendar']) ? 1 : 0;
$is_bounty = isset($_POST['is_bounty']) ? 1 : 0;
$xp_reward = !empty($_POST['xp_reward']) ? intval($_POST['xp_reward']) : 10;
$image_path = $habit['image_path'];
// Optional new image
if (!empty($_FILES['image']['name'])) {
$uploadDir = "../assets/images/habits/";
if (!is_dir($uploadDir)) {
mkdir($uploadDir, 0777, true);
}
$filename = time() . "_" . basename($_FILES['image']['name']);
$targetPath = $uploadDir . $filename;
if (move_uploaded_file($_FILES['image']['tmp_name'], $targetPath)) {
$image_path = "assets/images/habits/" . $filename;
}
}
$update = $pdo->prepare("
UPDATE habits
SET title = ?, description = ?, frequency = ?, specific_date = ?,
show_on_calendar = ?, is_bounty = ?, xp_reward = ?, image_path = ?
WHERE id = ?
");
$update->execute([
$title,
$description,
$frequency,
$specific_date,
$show_on_cal,
$is_bounty,
$xp_reward,
$image_path,
$id
]);
$message = "Habit updated successfully.";
// Refresh habit
$stmt->execute([$id]);
$habit = $stmt->fetch();
}
?>
Edit Habit