prepare("SELECT * FROM habits WHERE id = ?");
$stmt->execute([$habitId]);
$habit = $stmt->fetch();
if (!$habit) {
die("Habit not found.");
}
// Fetch items for linking
$itemStmt = $pdo->query("
SELECT id, title, quantity, quantity_max
FROM items
ORDER BY title ASC
");
$items = $itemStmt->fetchAll();
// 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_calendar = 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;
$tab = $_POST['tab'] ?? 'misc';
// Optional linked item
$linked_item_id = !empty($_POST['linked_item_id']) ? intval($_POST['linked_item_id']) : null;
$consume_amount = !empty($_POST['consume_amount']) ? intval($_POST['consume_amount']) : null;
// Handle image upload
$image_path = $habit['image_path'];
if (!empty($_FILES['image']['name'])) {
$uploadDir = HABIT_IMAGES_PATH;
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 habit
$update = $pdo->prepare("
UPDATE habits
SET title = ?, description = ?, image_path = ?, frequency = ?, specific_date = ?,
show_on_calendar = ?, is_bounty = ?, xp_reward = ?, tab = ?, linked_item_id = ?, consume_amount = ?
WHERE id = ?
");
$update->execute([
$title,
$description,
$image_path,
$frequency,
$specific_date,
$show_on_calendar,
$is_bounty,
$xp_reward,
$tab,
$linked_item_id,
$consume_amount,
$habitId
]);
$message = "Habit updated successfully!";
}
?>
Edit Habit