<?php
include "ominterior_db.php";

// Get the ID
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

// Handle update
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $h2 = $_POST['h2'];
    $paragraph = $_POST['paragraph'];

    $stmt = $conn->prepare("UPDATE texts SET h2 = ?, paragraph = ? WHERE id = ?");
    $stmt->bind_param("ssi", $h2, $paragraph, $id);

    if ($stmt->execute()) {
        header("Location: texts.php");

    } else {
        $error = "Update failed: " . $stmt->error;
    }
    $stmt->close();
}

// Fetch existing record
$stmt = $conn->prepare("SELECT h2, paragraph FROM texts WHERE id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$content = $result->fetch_assoc();
$stmt->close();

$conn->close();
?>

<!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 TEXT</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 TEXTS</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-12 mx-auto">
                        <div class="card p-4"> <!-- Added padding here -->
                            <div class="card-header d-flex justify-content-between align-items-center">
                                <h5 class="mb-0">Edit TEXTS</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"> <!-- Optional: You can also move form inside this div -->
                                <?php if ($content): ?>
                                    <form method="POST">
                                        <div class="mb-3">
                                            <label for="h2" class="form-label">Heading (H2)</label>
                                            <input type="text" name="h2" class="form-control" value="<?= htmlspecialchars($content['h2']) ?>" required>
                                        </div>

                                        <div class="mb-3">
                                            <label for="paragraph" class="form-label">Paragraph</label>
                                            <textarea name="paragraph" class="form-control" rows="5" required><?= htmlspecialchars($content['paragraph']) ?></textarea>
                                        </div>

                                        <button type="submit" class="btn btn-primary">Update</button>
                                        <a href="texts.php" class="btn btn-secondary">Cancel</a>
                                    </form>
                                <?php else: ?>
                                    <div class="alert alert-warning">Content not found.</div>
                                <?php endif; ?> 
                            </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>
