query("SELECT id, name FROM properties ORDER BY name ASC")->fetchAll(PDO::FETCH_ASSOC); $tenants = $db->query("SELECT id, name FROM tenants ORDER BY name ASC")->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $error = "Error fetching data: " . $e->getMessage(); } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $property_id = $_POST['property_id'] ?? null; $tenant_id = $_POST['tenant_id'] ?? null; $description = $_POST['description'] ?? ''; $reported_date = $_POST['reported_date'] ?? ''; $status = $_POST['status'] ?? 'Open'; if ($property_id && $description && $reported_date) { try { $stmt = $db->prepare("INSERT INTO maintenance_requests (property_id, tenant_id, description, reported_date, status) VALUES (?, ?, ?, ?, ?)"); $stmt->execute([$property_id, $tenant_id, $description, $reported_date, $status]); header("Location: index.php?page=maintenance&success=Request added"); exit; } catch (PDOException $e) { $error = "Error: " . $e->getMessage(); } } else { $error = "Please fill all required fields."; } } include 'templates/header.php'; ?>

Add Maintenance Request