prepare("DELETE FROM activities WHERE id = ?"); $stmt->execute([$activityIdToDelete]); } catch (PDOException $e) { error_log("Database error: " . $e->getMessage()); } } // Handle new activity creation if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['activity_name'])) { $activityName = trim($_POST['activity_name']); $activityDate = trim($_POST['activity_date']); $activityNotes = trim($_POST['activity_notes']); if (!empty($activityName)) { try { $pdo = db(); $stmt = $pdo->prepare("INSERT INTO activities (name, activity_date, notes) VALUES (?, ?, ?)"); $stmt->execute([$activityName, $activityDate, $activityNotes]); } catch (PDOException $e) { error_log("Database error: " . $e->getMessage()); } } } // Fetch all activities $activities = []; try { $pdo = db(); $stmt = $pdo->query("SELECT id, name, activity_date, notes FROM activities ORDER BY activity_date DESC, created_at DESC"); $activities = $stmt->fetchAll(); } catch (PDOException $e) { error_log("Database error: " . $e->getMessage()); } ?> Activity Planner

Activity Planner

Plan your winter adventures.

Add New Activity

Planned Activities

No activities planned yet.

Back to Home