<?php
// ----------  PHP SECTION  ----------
include 'auth.php';
include 'connection.php';

/* ---------------------------------
   1.  FETCH EXISTING ROW (id = 1)
----------------------------------*/
$id = 1;
$selectSql  = "SELECT * FROM footer_content WHERE id = ?";
$selectStmt = mysqli_prepare($conn, $selectSql);
mysqli_stmt_bind_param($selectStmt, "i", $id);
mysqli_stmt_execute($selectStmt);
$result = mysqli_stmt_get_result($selectStmt);
$data   = mysqli_fetch_assoc($result) ?: ['about_us' => '', 'branch1' => '']; // fallback

/* ---------------------------------
   2.  HANDLE FORM SUBMISSION
----------------------------------*/
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $about_us = $_POST['about_us'] ?? '';
    $branch1  = $_POST['branch1']  ?? '';

    $updateSql  = "UPDATE footer_content
                   SET about_us = ?, branch1 = ?
                   WHERE id = 1";
    $updateStmt = mysqli_prepare($conn, $updateSql);
    mysqli_stmt_bind_param($updateStmt, "ss", $about_us, $branch1);

    if (mysqli_stmt_execute($updateStmt)) {
        echo "<script>alert('Content updated successfully!'); 
              window.location.href='footer-changes.php';</script>";
        exit;
    } else {
        echo "<script>alert('Error updating content!');</script>";
    }
}
?>

<!doctype html>
<html lang="en">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>Admin</title>
  <link rel="shortcut icon" type="image/png" href="../assets/images/logos/favicon.png">
  <link rel="stylesheet" href="../assets/css/styles.min.css">
</head>

<body>
<div class="page-wrapper" id="main-wrapper" data-layout="vertical"
     data-navbarbg="skin6" data-sidebartype="full"
     data-sidebar-position="fixed" data-header-position="fixed">

  <!-- Sidebar -->
  <?php include 'aside.php'; ?>

  <div class="body-wrapper">
    <!-- Header -->
    <?php include 'header.php'; ?>

    <div class="container-fluid mt-5">
      <h2 class="mb-4">Update Website Content</h2>

      <!-- ----------  FORM  ---------- -->
      <form action="" method="post">
        <!-- About Us -->
        <div class="mb-3">
          <label class="form-label">About Us</label>
          <textarea class="form-control" name="about_us" rows="3"
                    required><?= htmlspecialchars($data['about_us']) ?></textarea>
        </div>

        <!-- Branch 1 Address -->
        <div class="mb-3">
          <label class="form-label">Branch 1 Address</label>
          <input type="text" class="form-control" name="branch1" 
                 value="<?= htmlspecialchars($data['branch1']) ?>" required>
        </div>

        <button type="submit" class="btn btn-primary">Update Content</button>
      </form>
    </div>
  </div>
</div>

<script src="../assets/libs/jquery/dist/jquery.min.js"></script>
<script src="../assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
<script src="../assets/js/sidebarmenu.js"></script>
<script src="../assets/js/app.min.js"></script>
<script src="../assets/libs/simplebar/dist/simplebar.js"></script>
</body>
</html>
