<?php
include '../includes/db.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = $_POST['project_name'];
    $url = $_POST['sheet_url'];
    $status = $_POST['status'];
    $deadline = $_POST['deadline'];

    $stmt = $conn->prepare("INSERT INTO seo_projects (project_name, sheet_url, status, deadline) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("ssss", $name, $url, $status, $deadline);

    if ($stmt->execute()) {
        header("Location: ../dashboard.php");
        exit;
    } else {
        echo "Error: " . $conn->error;
    }
}
?>