<?php
session_start();
include 'config.php';

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

error_log("Training Portal - Session data: " . print_r($_SESSION, true), 3, "debug.log");

$valid_roles = ['admin', 'superadmin'];
if (!isset($_SESSION['username']) || !in_array(strtolower($_SESSION['role'] ?? ''), $valid_roles)) {
    header("Location: logout.php");
    exit;
}

if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST['action'])) {
    $action       = $_POST['action'];
    $title        = $_POST['title'];
    $description  = $_POST['description'] ?? '';
    $trainer_name = $_POST['trainer_name'];
    $venue        = $_POST['venue'];
    $place        = $_POST['place'];
    $start_date   = $_POST['start_date'];
    $end_date     = $_POST['end_date'];
    $created_by   = $_POST['created_by'];

    try {
        if ($action === "create") {
            $sql  = "INSERT INTO training (title, description, trainer_name, venue, place, start_date, end_date, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
            $stmt = $conn->prepare($sql);
            if (!$stmt) throw new Exception("Prepare failed: " . $conn->error);
            $stmt->bind_param("ssssssss", $title, $description, $trainer_name, $venue, $place, $start_date, $end_date, $created_by);
            if (!$stmt->execute()) throw new Exception("Execute failed: " . $stmt->error);
            $_SESSION['message'] = "Training added successfully.";
            $stmt->close();
        } elseif ($action === "update") {
            $id   = $_POST['id'];
            $sql  = "UPDATE training SET title=?,description=?,trainer_name=?,venue=?,place=?,start_date=?,end_date=?,created_by=? WHERE id=?";
            $stmt = $conn->prepare($sql);
            if (!$stmt) throw new Exception("Prepare failed: " . $conn->error);
            $stmt->bind_param("ssssssssi", $title, $description, $trainer_name, $venue, $place, $start_date, $end_date, $created_by, $id);
            if (!$stmt->execute()) throw new Exception("Execute failed: " . $stmt->error);
            $_SESSION['message'] = "Training updated successfully.";
            $stmt->close();
        } elseif ($action === "delete") {
            $id   = $_POST['id'];
            $sql  = "DELETE FROM training WHERE id=?";
            $stmt = $conn->prepare($sql);
            if (!$stmt) throw new Exception("Prepare failed: " . $conn->error);
            $stmt->bind_param("i", $id);
            if (!$stmt->execute()) throw new Exception("Execute failed: " . $stmt->error);
            $_SESSION['message'] = "Training deleted successfully.";
            $stmt->close();
        }
    } catch (Exception $e) {
        error_log("Training Portal - Error: " . $e->getMessage(), 3, "debug.log");
        $_SESSION['error'] = "Database error: " . $e->getMessage();
    }
    header("Location: training_dashboard.php");
    exit();
}

$sql = "SELECT t.id, t.title, t.description, t.trainer_name, t.venue, t.place, t.start_date, t.end_date, t.created_by, u.first_name, u.last_name
        FROM training t JOIN users u ON t.created_by = u.id ORDER BY t.start_date DESC";
$result = $conn->query($sql);

$users_sql    = "SELECT id, first_name, last_name FROM users WHERE status = 'active'";
$users_result = $conn->query($users_sql);

$username_session = $_SESSION['username'] ?? '';
function h($s){ return htmlspecialchars($s ?? '', ENT_QUOTES, 'UTF-8'); }
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
<title>MPC · Training Portal</title>
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=Sora:wght@300;400;500;600;700&family=JetBrains+Mono:wght@400;500&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
<style>
*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }
:root {
  --ink: #0f172a; --ink-2: #334155; --muted: #94a3b8; --border: #e2e8f0;
  --surface: #ffffff; --bg: #f1f5f9; --sidebar-bg: #0f172a;
  --sidebar-w: 260px; --radius: 12px;
  --shadow: 0 1px 3px rgba(15,23,42,.06), 0 4px 16px rgba(15,23,42,.06);
  font-family: 'Sora', system-ui, sans-serif;
}
html, body { height: 100%; }
body { background: var(--bg); color: var(--ink); font-size: 14px; line-height: 1.6; -webkit-font-smoothing: antialiased; }
.layout { display: flex; min-height: 100vh; }

.sidebar {
  width: var(--sidebar-w); background: var(--sidebar-bg);
  position: fixed; inset: 0 auto 0 0; z-index: 200;
  display: flex; flex-direction: column;
  overflow-y: auto; overflow-x: hidden;
  transition: transform .3s cubic-bezier(.4,0,.2,1); scrollbar-width: none;
}
.sidebar::-webkit-scrollbar { display: none; }
.sidebar.hidden { transform: translateX(-100%); }
.sidebar-brand {
  padding: 24px 20px 16px; display: flex; align-items: center; gap: 10px;
  border-bottom: 1px solid rgba(255,255,255,.06); margin-bottom: 8px;
}
.brand-logo {
  width: 36px; height: 36px; background: linear-gradient(135deg,#3b82f6,#6366f1);
  border-radius: 8px; display: flex; align-items: center; justify-content: center;
  font-size: 16px; font-weight: 700; color: #fff; flex-shrink: 0;
}
.brand-name { font-size: 15px; font-weight: 700; color: #fff; }
.brand-sub  { font-size: 10px; color: rgba(255,255,255,.4); letter-spacing: 1.5px; text-transform: uppercase; margin-top: 1px; }
.nav-section { padding: 0 12px 6px; }
.nav-item { list-style: none; }
.nav-link, .nav-dropdown-toggle {
  display: flex; align-items: center; gap: 10px; padding: 8px 10px; border-radius: 8px;
  color: rgba(255,255,255,.65); text-decoration: none; font-size: 13px; font-weight: 500;
  cursor: pointer; border: none; background: none; width: 100%; text-align: left;
  transition: background .15s, color .15s;
}
.nav-link:hover, .nav-dropdown-toggle:hover { background: rgba(255,255,255,.07); color: #fff; }
.nav-link.active { background: rgba(59,130,246,.2); color: #60a5fa; }
.nav-link i, .nav-dropdown-toggle i { width: 16px; text-align: center; font-size: 13px; }
.nav-dropdown-toggle .arrow { margin-left: auto; transition: transform .2s; font-size: 10px; }
.nav-dropdown-toggle.open .arrow { transform: rotate(180deg); }
.nav-submenu { list-style: none; overflow: hidden; max-height: 0; transition: max-height .3s ease; padding-left: 26px; }
.nav-submenu.open { max-height: 600px; }
.nav-submenu .nav-link { font-size: 12px; padding: 6px 10px; color: rgba(255,255,255,.5); }
.nav-submenu .nav-link:hover { color: #fff; background: rgba(255,255,255,.05); }
.sidebar-footer { margin-top: auto; padding: 12px; border-top: 1px solid rgba(255,255,255,.06); }

.content { flex: 1; margin-left: var(--sidebar-w); min-width: 0; display: flex; flex-direction: column; transition: margin .3s cubic-bezier(.4,0,.2,1); }
.content.expanded { margin-left: 0; }

.topbar {
  height: 60px; background: var(--surface); border-bottom: 1px solid var(--border);
  display: flex; align-items: center; gap: 12px; padding: 0 24px;
  position: sticky; top: 0; z-index: 100;
}
.hamburger-btn {
  width: 36px; height: 36px; border-radius: 8px; border: 1px solid var(--border);
  background: var(--surface); display: flex; align-items: center; justify-content: center;
  cursor: pointer; color: var(--ink-2); font-size: 15px; flex-shrink: 0; transition: background .15s;
}
.hamburger-btn:hover { background: var(--bg); }
.topbar-breadcrumb { display: flex; align-items: center; gap: 6px; font-size: 13px; color: var(--muted); }
.topbar-breadcrumb .current { color: var(--ink); font-weight: 600; }
.topbar-spacer { flex: 1; }
.topbar-user { display: flex; align-items: center; gap: 8px; font-size: 13px; color: var(--ink-2); font-weight: 500; }
.topbar-avatar {
  width: 30px; height: 30px; border-radius: 50%;
  background: linear-gradient(135deg,#3b82f6,#6366f1);
  display: flex; align-items: center; justify-content: center; color: #fff; font-size: 12px; font-weight: 700;
}

.page { padding: 24px; flex: 1; }
.page-header { margin-bottom: 20px; }
.page-title   { font-size: 22px; font-weight: 700; color: var(--ink); letter-spacing: -.4px; }
.page-subtitle { font-size: 13px; color: var(--muted); margin-top: 2px; }

.alert {
  padding: 12px 16px; border-radius: 10px; font-size: 13px; font-weight: 500;
  display: flex; align-items: flex-start; gap: 10px; margin-bottom: 20px;
  border: 1px solid transparent; animation: fadeUp .25s ease;
}
.alert-success { background: #d1fae5; border-color: #6ee7b7; color: #065f46; }
.alert-danger  { background: #fee2e2; border-color: #fca5a5; color: #991b1b; }
@keyframes fadeUp { from { opacity: 0; transform: translateY(6px); } to { opacity: 1; transform: none; } }

.card { background: var(--surface); border: 1px solid var(--border); border-radius: var(--radius); box-shadow: var(--shadow); overflow: hidden; margin-bottom: 24px; }
.card-header { display: flex; align-items: center; gap: 8px; padding: 16px 20px; border-bottom: 1px solid var(--border); }
.card-title { font-size: 15px; font-weight: 700; color: var(--ink); }
.card-body { padding: 24px; }

.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 16px; }
.form-group { margin-bottom: 0; }
.form-group.full { grid-column: 1 / -1; }
.form-label { display: block; font-size: 11px; font-weight: 700; text-transform: uppercase; letter-spacing: .8px; color: var(--muted); margin-bottom: 6px; }
.form-select, .form-input, .form-textarea {
  width: 100%; border: 1px solid var(--border); border-radius: 8px;
  padding: 0 12px; font-size: 13px; font-family: 'Sora', sans-serif;
  color: var(--ink); background: var(--bg); outline: none;
  transition: border-color .15s, box-shadow .15s;
}
.form-select, .form-input { height: 42px; }
.form-textarea { padding: 10px 12px; resize: vertical; min-height: 80px; }
.form-select:focus, .form-input:focus, .form-textarea:focus {
  border-color: #3b82f6; box-shadow: 0 0 0 3px rgba(59,130,246,.12); background: var(--surface);
}

.btn { height: 38px; border-radius: 8px; border: none; font-size: 13px; font-weight: 700; font-family: 'Sora', sans-serif; cursor: pointer; display: inline-flex; align-items: center; justify-content: center; gap: 6px; padding: 0 16px; transition: opacity .15s; }
.btn-primary { background: #1d4ed8; color: #fff; }
.btn-warning { background: #f59e0b; color: #fff; }
.btn-danger  { background: #ef4444; color: #fff; }
.btn:hover   { opacity: .88; }
.btn-submit  { width: 100%; height: 42px; margin-top: 16px; }

.table-wrap { overflow-x: auto; }
table { width: 100%; border-collapse: collapse; font-size: 13px; }
thead th { background: var(--ink); color: #fff; padding: 12px 14px; text-align: left; font-weight: 600; font-size: 12px; letter-spacing: .3px; }
tbody td { padding: 12px 14px; border-bottom: 1px solid var(--border); color: var(--ink-2); vertical-align: top; }
tbody tr:last-child td { border-bottom: none; }
tbody tr:hover td { background: #f8fafc; }
.empty-row td { text-align: center; color: var(--muted); padding: 32px; font-size: 13px; }

.edit-form { display: flex; flex-direction: column; gap: 6px; min-width: 220px; }
.edit-form .form-select, .edit-form .form-input, .edit-form .form-textarea { font-size: 12px; }
.edit-form .form-select, .edit-form .form-input { height: 36px; }
.btn-row { display: flex; gap: 6px; margin-top: 4px; }

@media (max-width: 768px) {
  .sidebar { transform: translateX(-100%); }
  .sidebar:not(.hidden) { transform: none; }
  .content { margin-left: 0; }
  .page { padding: 16px; }
  .form-grid { grid-template-columns: 1fr; }
}
</style>
</head>
<body>
<div class="layout">

<!-- SIDEBAR -->
<nav class="sidebar" id="sidebar">
  <div class="sidebar-brand">
    <div class="brand-logo">M</div>
    <div>
      <div class="brand-name">MPC</div>
      <div class="brand-sub">Admin Portal</div>
    </div>
  </div>
  <nav class="nav-section">
    <ul style="list-style:none">
      <li class="nav-item"><a href="dashboard_admin.php" class="nav-link"><i class="fas fa-sitemap"></i> Organisation Chart</a></li>
      <li class="nav-item">
        <button class="nav-dropdown-toggle" onclick="toggleMenu(this)"><i class="fas fa-folder-open"></i> DAP<i class="fas fa-chevron-down arrow"></i></button>
        <ul class="nav-submenu">
          <li><a href="manage_users.php"         class="nav-link"><i class="fas fa-users"></i>        Employee Details</a></li>
          <li><a href="manage_documents.php"     class="nav-link"><i class="fas fa-file-alt"></i>     Policies Rolled Out</a></li>
          <li><a href="division_designation.php" class="nav-link"><i class="fas fa-tag"></i>          Division / Designation</a></li>
          <li><a href="digital.php"              class="nav-link"><i class="fas fa-check-circle"></i> Acceptance Confirmed</a></li>
          <li><a href="change_password.php"      class="nav-link"><i class="fas fa-key"></i>          Change Password</a></li>
        </ul>
      </li>
      <li class="nav-item">
        <button class="nav-dropdown-toggle" onclick="toggleMenu(this)"><i class="fas fa-calendar-alt"></i> CAB<i class="fas fa-chevron-down arrow"></i></button>
        <ul class="nav-submenu">
          <li><a href="attendance.php"              class="nav-link"><i class="fas fa-clock"></i>             Attendance Dashboard</a></li>
          <li><a href="payroll.php"                 class="nav-link"><i class="fas fa-money-bill"></i>        Payroll Dashboard</a></li>
          <li><a href="mobile_attendance.php"       class="nav-link"><i class="fas fa-mobile-alt"></i>       Daily Attendance Report</a></li>
          <li><a href="task_dashboard.php"          class="nav-link"><i class="fas fa-tasks"></i>            Task Dashboard</a></li>
          <li><a href="daily_reports_dashboard.php" class="nav-link"><i class="fas fa-chart-line"></i>       Daily Report Dashboard</a></li>
          <li><a href="company_holidays.php"        class="nav-link"><i class="fas fa-star"></i>             Company Holidays</a></li>
          <li><a href="hr_approval_salary.php"      class="nav-link"><i class="fas fa-hand-holding-usd"></i> Advance Dashboard</a></li>
          <li><a href="expense_dashboard.php"       class="nav-link"><i class="fas fa-receipt"></i>          Expenses Dashboard</a></li>
          <li><a href="leave_dashboard.php"         class="nav-link"><i class="fas fa-umbrella-beach"></i>   Leave Dashboard</a></li>
          <li><a href="grievance_dashboard.php"     class="nav-link"><i class="fas fa-comment-alt"></i>      Grievance Dashboard</a></li>
        </ul>
      </li>
      <li class="nav-item">
        <button class="nav-dropdown-toggle" onclick="toggleMenu(this)"><i class="fas fa-user-tie"></i> PEP<i class="fas fa-chevron-down arrow"></i></button>
        <ul class="nav-submenu">
          <li><a href="individual_rr.php"     class="nav-link"><i class="fas fa-trophy"></i>   Individual R &amp; R</a></li>
          <li><a href="individual_kpi.php"    class="nav-link"><i class="fas fa-bullseye"></i> Individual KPI</a></li>
          <li><a href="https://pupa.mypeopleconnect.app/" class="nav-link"><i class="fas fa-id-card"></i> PEP Login</a></li>
        </ul>
      </li>
      <li class="nav-item">
        <button class="nav-dropdown-toggle open" onclick="toggleMenu(this)"><i class="fas fa-book-open"></i> L&amp;D<i class="fas fa-chevron-down arrow"></i></button>
        <ul class="nav-submenu open">
          <li><a href="incident_employee.php"  class="nav-link"><i class="fas fa-exclamation-triangle"></i> Incident Portal</a></li>
          <li><a href="training_dashboard.php" class="nav-link active"><i class="fas fa-chalkboard-teacher"></i> Training Portal</a></li>
          <li><a href="rr.php"                 class="nav-link"><i class="fas fa-award"></i>                Rewards &amp; Recognition</a></li>
        </ul>
      </li>
      <li class="nav-item">
        <button class="nav-dropdown-toggle" onclick="toggleMenu(this)"><i class="fas fa-star"></i> AAA<i class="fas fa-chevron-down arrow"></i></button>
        <ul class="nav-submenu">
          <li><a href="employee_tiy.php"      class="nav-link"><i class="fas fa-user-check"></i> Employee TIY</a></li>
          <li><a href="login_credentials.php" class="nav-link"><i class="fas fa-id-card"></i>    Login Credentials</a></li>
        </ul>
      </li>
    </ul>
  </nav>
  <div class="sidebar-footer">
    <a href="logout.php" class="nav-link" style="color:#f87171;"><i class="fas fa-sign-out-alt"></i> Logout</a>
  </div>
</nav>

<!-- CONTENT -->
<div class="content" id="content">
  <div class="topbar">
    <button class="hamburger-btn" onclick="toggleSidebar()"><i class="fas fa-bars"></i></button>
    <div class="topbar-breadcrumb">
      <span>L&amp;D</span>
      <i class="fas fa-chevron-right" style="font-size:10px;color:var(--border)"></i>
      <span class="current">Training Portal</span>
    </div>
    <div class="topbar-spacer"></div>
    <div class="topbar-user">
      <div class="topbar-avatar"><?php echo strtoupper(substr($username_session ?: 'A', 0, 1)); ?></div>
      <?php echo h($username_session ?: 'Admin'); ?>
    </div>
  </div>

  <div class="page">
    <div class="page-header">
      <div class="page-title">Training Portal</div>
      <div class="page-subtitle">Manage training programs and schedules</div>
    </div>

    <?php if (isset($_SESSION['message'])): ?>
      <div class="alert alert-success"><i class="fas fa-check-circle"></i> <?php echo h($_SESSION['message']); unset($_SESSION['message']); ?></div>
    <?php endif; ?>
    <?php if (isset($_SESSION['error'])): ?>
      <div class="alert alert-danger"><i class="fas fa-exclamation-circle"></i> <?php echo h($_SESSION['error']); unset($_SESSION['error']); ?></div>
    <?php endif; ?>

    <!-- ADD TRAINING FORM -->
    <div class="card">
      <div class="card-header">
        <i class="fas fa-plus-circle" style="color:var(--muted)"></i>
        <div class="card-title">Add New Training</div>
      </div>
      <div class="card-body">
        <form method="POST">
          <input type="hidden" name="action" value="create">
          <div class="form-grid">
            <div class="form-group">
              <label class="form-label">Training Title</label>
              <input type="text" name="title" class="form-input" placeholder="Training Title" required>
            </div>
            <div class="form-group">
              <label class="form-label">Trainer Name</label>
              <input type="text" name="trainer_name" class="form-input" placeholder="Trainer Name" required>
            </div>
            <div class="form-group">
              <label class="form-label">Venue</label>
              <input type="text" name="venue" class="form-input" placeholder="Venue" required>
            </div>
            <div class="form-group">
              <label class="form-label">Place</label>
              <input type="text" name="place" class="form-input" placeholder="Place" required>
            </div>
            <div class="form-group">
              <label class="form-label">Start Date</label>
              <input type="date" name="start_date" class="form-input" required>
            </div>
            <div class="form-group">
              <label class="form-label">End Date</label>
              <input type="date" name="end_date" class="form-input" required>
            </div>
            <div class="form-group">
              <label class="form-label">Created By</label>
              <select name="created_by" class="form-select" required>
                <option value="">— Select Creator —</option>
                <?php if ($users_result) while ($u = $users_result->fetch_assoc()): ?>
                  <option value="<?php echo h($u['id']); ?>"><?php echo h($u['first_name'].' '.$u['last_name']); ?></option>
                <?php endwhile; $users_result->data_seek(0); ?>
              </select>
            </div>
            <div class="form-group full">
              <label class="form-label">Description</label>
              <textarea name="description" class="form-textarea" placeholder="Training description (optional)"></textarea>
            </div>
          </div>
          <button type="submit" class="btn btn-primary btn-submit"><i class="fas fa-save"></i> Add Training</button>
        </form>
      </div>
    </div>

    <!-- TRAINING TABLE -->
    <div class="card">
      <div class="card-header">
        <i class="fas fa-chalkboard-teacher" style="color:var(--muted)"></i>
        <div class="card-title">Training List</div>
      </div>
      <div class="card-body" style="padding:0">
        <div class="table-wrap">
          <table>
            <thead>
              <tr>
                <th>ID</th><th>Title</th><th>Description</th><th>Trainer</th><th>Venue</th><th>Place</th><th>Start</th><th>End</th><th>Created By</th><th>Actions</th>
              </tr>
            </thead>
            <tbody>
              <?php if ($result && $result->num_rows > 0): while ($row = $result->fetch_assoc()): ?>
              <tr>
                <td><?php echo h($row['id']); ?></td>
                <td><?php echo h($row['title']); ?></td>
                <td><?php echo h($row['description']??''); ?></td>
                <td><?php echo h($row['trainer_name']); ?></td>
                <td><?php echo h($row['venue']); ?></td>
                <td><?php echo h($row['place']); ?></td>
                <td><?php echo h($row['start_date']); ?></td>
                <td><?php echo h($row['end_date']); ?></td>
                <td><?php echo h($row['first_name'].' '.$row['last_name']); ?></td>
                <td>
                  <form method="POST" class="edit-form">
                    <input type="hidden" name="action" value="update">
                    <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                    <input type="text"  name="title"        class="form-input"    value="<?php echo h($row['title']); ?>" required>
                    <textarea           name="description"  class="form-textarea"><?php echo h($row['description']??''); ?></textarea>
                    <input type="text"  name="trainer_name" class="form-input"    value="<?php echo h($row['trainer_name']); ?>" required>
                    <input type="text"  name="venue"        class="form-input"    value="<?php echo h($row['venue']); ?>" required>
                    <input type="text"  name="place"        class="form-input"    value="<?php echo h($row['place']); ?>" required>
                    <input type="date"  name="start_date"   class="form-input"    value="<?php echo h($row['start_date']); ?>" required>
                    <input type="date"  name="end_date"     class="form-input"    value="<?php echo h($row['end_date']); ?>" required>
                    <select name="created_by" class="form-select" required>
                      <?php $users_result->data_seek(0); while ($u = $users_result->fetch_assoc()): ?>
                        <option value="<?php echo h($u['id']); ?>" <?php echo $u['id']==$row['created_by']?'selected':''; ?>><?php echo h($u['first_name'].' '.$u['last_name']); ?></option>
                      <?php endwhile; ?>
                    </select>
                    <div class="btn-row">
                      <button type="submit" class="btn btn-warning"><i class="fas fa-pen"></i> Update</button>
                    </div>
                  </form>
                  <form method="POST" style="margin-top:6px">
                    <input type="hidden" name="action" value="delete">
                    <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
                    <button type="submit" class="btn btn-danger" onclick="return confirm('Delete this training record?')"><i class="fas fa-trash"></i> Delete</button>
                  </form>
                </td>
              </tr>
              <?php endwhile; else: ?>
              <tr class="empty-row"><td colspan="10"><i class="fas fa-inbox" style="margin-right:6px"></i>No training records found</td></tr>
              <?php endif; ?>
            </tbody>
          </table>
        </div>
      </div>
    </div>
  </div>
</div>
</div>

<script>
function toggleSidebar() {
  document.getElementById('sidebar').classList.toggle('hidden');
  document.getElementById('content').classList.toggle('expanded');
}
function toggleMenu(btn) {
  btn.nextElementSibling.classList.toggle('open');
  btn.classList.toggle('open');
}
</script>
</body>
</html>
<?php $conn->close(); ?>