1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / nagalandsuperleague.co.in / admin /
Filename : admin_highlights.php
back
<?php
// Database connection settings
$host    = 'localhost';
$db      = 'nagalandsuperleague';
$user    = 'nagalandsuperleague';
$pass    = 'nagalandsuperleague';
$charset = 'utf8mb4';

// Set up PDO connection
$dsn     = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
  PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
  PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  PDO::ATTR_EMULATE_PREPARES   => false,
];

try {
  $pdo = new PDO($dsn, $user, $pass, $options);
} catch (PDOException $e) {
  die("Database connection failed: " . $e->getMessage());
}

// Process form submission to update highlights
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  $leftScorer  = $_POST['leftScorer']  ?? '';
  $leftRedCard = $_POST['leftRedCard'] ?? '';
  $rightScorer = $_POST['rightScorer'] ?? '';
  $rightRedCard = $_POST['rightRedCard'] ?? '';

  $stmt = $pdo->prepare("UPDATE highlights SET leftScorer = ?, leftRedCard = ?, rightScorer = ?, rightRedCard = ? WHERE id = 1");
  $stmt->execute([$leftScorer, $leftRedCard, $rightScorer, $rightRedCard]);

  $message = "Highlights updated successfully!";
}

// Fetch the highlights record (assume id=1)
$stmt = $pdo->query("SELECT * FROM highlights WHERE id = 1");
$highlight = $stmt->fetch();
if (!$highlight) {
  // If not found, insert a default record
  $stmt = $pdo->prepare("INSERT INTO highlights (leftScorer, leftRedCard, rightScorer, rightRedCard) VALUES (?, ?, ?, ?)");
  $stmt->execute(["Marcelino Ferdinan - 32', 57'", "Justin Hubner - 89'", "Marcelino Ferdinan - 32', 57'", "Justin Hubner - 89'"]);
  $stmt = $pdo->query("SELECT * FROM highlights WHERE id = 1");
  $highlight = $stmt->fetch();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Admin - Edit Highlights</title>
  <!-- Import Google Font -->
  <link href="https://fonts.googleapis.com/css2?family=Roboto:wght@400;500;700&display=swap" rel="stylesheet">
  <style>
    /* Global Styles */
    body {
      font-family: 'Roboto', sans-serif;
      background: linear-gradient(135deg, #e0f7fa, #80deea);
      padding: 20px;
      margin: 0;
      color: #333;
    }
    .admin-container {
      max-width: 900px;
      margin: auto;
      background: #fff;
      padding: 30px;
      border-radius: 10px;
      box-shadow: 0 8px 20px rgba(0,0,0,0.1);
    }
    h1 {
      text-align: center;
      margin-bottom: 20px;
    }
    fieldset {
      border: none;
      margin-bottom: 20px;
      padding-bottom: 10px;
      border-bottom: 1px solid #ddd;
    }
    legend {
      font-size: 1.5em;
      font-weight: 700;
      color: #4CAF50;
      margin-bottom: 10px;
    }
    label {
      display: block;
      margin-top: 10px;
      color: #555;
    }
    input[type="text"] {
      width: 100%;
      padding: 10px;
      margin-top: 5px;
      border: 1px solid #ccc;
      border-radius: 5px;
    }
    button {
      background: #4CAF50;
      border: none;
      color: #fff;
      padding: 12px 20px;
      font-size: 1em;
      border-radius: 5px;
      cursor: pointer;
      margin-top: 20px;
      display: inline-block;
    }
    button:hover {
      background: #45a049;
    }
    .message {
      text-align: center;
      color: #388e3c;
      font-weight: bold;
      margin-bottom: 20px;
    }
    /* Highlights Preview Styles */
    .highlights-preview {
      margin-top: 30px;
      background: #f9f9f9;
      padding: 20px;
      border-radius: 10px;
      box-shadow: 0 4px 12px rgba(0,0,0,0.1);
    }
    .highlights-container {
      display: flex;
      align-items: center;
      justify-content: center;
      flex-wrap: wrap;
    }
    .left-column, .right-column {
      flex: 1;
      min-width: 250px;
      text-align: center;
    }
    .divider-container {
      width: 20px;
      display: flex;
      align-items: center;
      justify-content: center;
    }
    .divider {
      width: 2px;
      height: 80%;
      background: #ccc;
    }
    .highlight-section {
      margin: 10px 0;
      font-size: 1.1em;
      display: flex;
      align-items: center;
      justify-content: center;
    }
    .highlight-section span {
      margin-right: 10px;
    }
    .red-card {
      width: 20px;
      height: 30px;
      background: red;
      border: 1px solid #900;
    }
  </style>
</head>
<body>
  <div class="admin-container">
    <h1>Edit Highlights</h1>
    <?php if(isset($message)) { echo "<div class='message'>$message</div>"; } ?>
    <form method="post" action="">
      <fieldset>
        <legend>Left Column Highlights</legend>
        <label for="leftScorer">Scorer (Left Column):</label>
        <input type="text" id="leftScorer" name="leftScorer" value="<?php echo htmlspecialchars($highlight['leftScorer']); ?>">
        
        <label for="leftRedCard">Red Card (Left Column):</label>
        <input type="text" id="leftRedCard" name="leftRedCard" value="<?php echo htmlspecialchars($highlight['leftRedCard']); ?>">
      </fieldset>
      <fieldset>
        <legend>Right Column Highlights</legend>
        <label for="rightScorer">Scorer (Right Column):</label>
        <input type="text" id="rightScorer" name="rightScorer" value="<?php echo htmlspecialchars($highlight['rightScorer']); ?>">
        
        <label for="rightRedCard">Red Card (Right Column):</label>
        <input type="text" id="rightRedCard" name="rightRedCard" value="<?php echo htmlspecialchars($highlight['rightRedCard']); ?>">
      </fieldset>
      <div style="text-align:center;">
        <button type="button" onclick="updatePreview()">Update Preview</button>
        <button type="submit">Save Changes</button>
      </div>
    </form>
    <div class="highlights-preview">
      <h2>Highlights Preview</h2>
      <div id="highlightsPreview" class="highlights-container">
        <!-- Left Column -->
        <div class="left-column">
          <div class="highlight-section">
            <span id="previewLeftScorer"><?php echo htmlspecialchars($highlight['leftScorer']); ?></span>
            ⚽
          </div>
          <div class="highlight-section">
            <span id="previewLeftRedCard"><?php echo htmlspecialchars($highlight['leftRedCard']); ?></span>
            <div class="red-card"></div>
          </div>
        </div>
        <!-- Divider -->
        <div class="divider-container">
          <div class="divider"></div>
        </div>
        <!-- Right Column -->
        <div class="right-column">
          <div class="highlight-section">
            <span id="previewRightScorer"><?php echo htmlspecialchars($highlight['rightScorer']); ?></span>
            ⚽
          </div>
          <div class="highlight-section">
            <span id="previewRightRedCard"><?php echo htmlspecialchars($highlight['rightRedCard']); ?></span>
            <div class="red-card"></div>
          </div>
        </div>
      </div>
    </div>
  </div>

  <script>
    function updatePreview() {
      document.getElementById('previewLeftScorer').textContent = document.getElementById('leftScorer').value;
      document.getElementById('previewLeftRedCard').textContent = document.getElementById('leftRedCard').value;
      document.getElementById('previewRightScorer').textContent = document.getElementById('rightScorer').value;
      document.getElementById('previewRightRedCard').textContent = document.getElementById('rightRedCard').value;
    }
  </script>
</body>
</html>