<?php
require_once 'db/config.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = trim($_POST['project_name'] ?? '');
    $client = trim($_POST['client_name'] ?? '');
    $start_date = trim($_POST['start_date'] ?? '');

    if (empty($name) || empty($start_date)) {
        // Basic validation
        // In a real app, you would have a more robust error handling/messaging system
        header('Location: index.php?error=validation');
        exit;
    }

    try {
        $pdo = db();
        $sql = "INSERT INTO projects (name, client, start_date) VALUES (?, ?, ?)";
        $stmt = $pdo->prepare($sql);
        $stmt->execute([$name, $client, $start_date]);
    } catch (PDOException $e) {
        // Proper error logging should be implemented
        // For now, redirect with a generic error
        header('Location: index.php?error=db');
        exit;
    }

    header('Location: index.php?success=added');
    exit;
} else {
    // If not a POST request, redirect home
    header('Location: index.php');
    exit;
}