<?php
include "ominterior_db.php";

$success = $error = "";

// Get FAQ by ID
if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    die("Invalid FAQ ID.");
}

$id = intval($_GET['id']);

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $question = trim($_POST['question']);
    $answer = trim($_POST['answer']);

    if (!empty($question) && !empty($answer)) {
        $stmt = $conn->prepare("UPDATE faq SET question = ?, answer = ? WHERE id = ?");
        $stmt->bind_param("ssi", $question, $answer, $id);

        if ($stmt->execute()) {
            $success = "FAQ updated successfully!";
            echo "<script>alert('FAQ updated successfully!'); window.location.href='faq.php';</script>";

        } else {
            $error = "Error updating FAQ.";
        }

        $stmt->close();
    } else {
        $error = "Both fields are required.";
    }
}

// Fetch the existing FAQ
$stmt = $conn->prepare("SELECT * FROM faq WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$faq = $result->fetch_assoc();
$stmt->close();

if (!$faq) {
    die("FAQ not found.");
}
?>

<!doctype html>
<html lang="en" dir="ltr">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>OM INTERIOR - Edit FAQ</title>

    <!-- Bootstrap Core -->
    <link rel="stylesheet" href="assets/plugins/bootstrap/css/bootstrap.min.css" />
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css" />
    
    <!-- Theme Core -->
    <link rel="stylesheet" href="assets/css/main2.css" />
    <link rel="stylesheet" href="assets/css/theme1.css" />
    <link rel="icon" href="assets/images/black-logo.png" type="image/x-icon"/>
</head>

<body class="font-montserrat">
    <div class="page-loader-wrapper"><div class="loader"></div></div>

    <div id="main_content">
        <?php include 'haderTop_logo.php'; ?>
        <?php include 'rightside_menu.php'; ?>
        <?php include 'leftside_menu.php'; ?>

        <div class="page">
            <!-- Page Header -->
            <div id="page_top" class="section-body top_dark">
                <div class="container-fluid">
                    <div class="page-header d-flex justify-content-between align-items-center">
                        <div class="left">
                            <a href="javascript:void(0)" class="icon menu_toggle mr-3"><i class="fa fa-align-left"></i></a>
                            <h1 class="page-title">Edit F&Q</h1>
                        </div>
                        <div class="right">
                            <?php include 'dropdown_flex_menu.php'; ?>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Content -->
            <div class="container my-4">
                <div class="row">
                    <div class="col-lg-8 mx-auto">

                        <?php if ($success): ?>
                            <div class="alert alert-success"><?= $success ?></div>
                        <?php endif; ?>
                        <?php if ($error): ?>
                            <div class="alert alert-danger"><?= $error ?></div>
                        <?php endif; ?>

                        <div class="card">
                            <div class="card-header d-flex justify-content-between align-items-center">
                                <h5 class="mb-0">Edit FAQ Details</h5>
                                <a href="delete.php?id=<?= $faq["id"] ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this FAQ?')">Delete</a>
                            </div>
                            <div class="card-body">
                                <form method="POST">
                                    <div class="form-group">
                                        <label for="question"><strong>Question</strong></label>
                                        <input type="text" class="form-control" id="question" name="question" value="<?= htmlspecialchars($faq['question']) ?>" required>
                                    </div>
                                    <div class="form-group">
                                        <label for="answer"><strong>Answer</strong></label>
                                        <textarea class="form-control" id="answer" name="answer" rows="5" required><?= htmlspecialchars($faq['answer']) ?></textarea>
                                    </div>
                                    <button type="submit" class="btn btn-primary">Update FAQ</button>
                                    <a href="faq.php" class="btn btn-secondary">Back to FAQ</a>
                                </form>
                            </div>
                        </div>

                    </div>
                </div>
            </div>

            <!-- Footer -->
            <div class="section-body">
                <footer class="footer">
                    <div class="container-fluid">
                        <div class="row">
                            <div class="col-12 text-center text-md-right">
                                <ul class="list-inline mb-0">
                                    <li class="list-inline-item"><a href="doc/index.html">OM INTERIOR</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </footer>
            </div>
        </div>    
    </div>

    <!-- Scripts -->
    <script src="assets/bundles/lib.vendor.bundle.js"></script>
    <script src="assets/bundles/apexcharts.bundle.js"></script>
    <script src="assets/bundles/counterup.bundle.js"></script>
    <script src="assets/bundles/knobjs.bundle.js"></script>
    <script src="assets/bundles/c3.bundle.js"></script>
    <script src="assets/js/core.js"></script>
    <script src="assets/js/page/project-index.js"></script>
</body>
</html>
