prepare($query);
$stmt->bind_param("i", $headId);
$stmt->execute();
$result = $stmt->get_result();
$head = $result->fetch_assoc();
if (!$head) {
header("Location: base.php");
exit();
}
// Fetch expense categories for dropdown
$categoriesQuery = "SELECT id, name FROM expense_categories ORDER BY name";
$categoriesResult = $conn->query($categoriesQuery);
$categories = $categoriesResult->fetch_all(MYSQLI_ASSOC);
// Handle form submission
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$query = "UPDATE expense_heads SET name = ?, category_id = ? WHERE id = ?";
$stmt = $conn->prepare($query);
$stmt->bind_param("sii", $_POST["name"], $_POST["category_id"], $headId);
$stmt->execute();
header("Location: base.php");
exit();
}
$content = <<Edit Expense Head
HTML;
// Include the main layout
include 'main_layout.php';
// Helper function to generate category options
function generateCategoryOptions($categories, $selectedCategoryId) {
$options = '';
foreach ($categories as $category) {
$selected = $category['id'] == $selectedCategoryId ? 'selected' : '';
$options .= "";
}
return $options;
}