$options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ];

$stmt = $pdo->prepare("INSERT INTO work_orders (title, description) VALUES (:title, :desc)"); $stmt->execute([':title' => $title, ':desc' => $desc]);

if ($title === '') echo "Title required."; exit;

// Handle POST create if ($_SERVER['REQUEST_METHOD'] === 'POST') // Basic input sanitation $title = trim($_POST['title'] ?? ''); $desc = trim($_POST['description'] ?? '');

// Redirect to avoid resubmission header('Location: create.php'); exit;

if ($_SERVER['REQUEST_METHOD'] === 'POST') $id = (int)($_POST['id'] ?? 0); if ($id > 0) $stmt = $pdo->prepare("DELETE FROM work_orders WHERE id = :id"); $stmt->execute([':id'=>$id]);

try $pdo = new PDO($dsn, $user, $pass, $options); catch (Exception $e) http_response_code(500); echo "DB connection error"; exit;

if ($_SERVER['REQUEST_METHOD'] !== 'POST') header('Location: create.php'); exit; $id = (int)($_POST['id'] ?? 0); $status = $_POST['status'] ?? 'open'; $allowed = ['open','in_progress','completed','closed']; if ($id <= 0 || !in_array($status, $allowed, true)) header('Location: create.php'); exit;