70 lines
2.3 KiB
PHP
70 lines
2.3 KiB
PHP
<?php
|
|
require_once __DIR__ . '/includes/header.php';
|
|
|
|
$message = '';
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_team'])) {
|
|
$teamName = trim($_POST['team_name']);
|
|
if (!empty($teamName)) {
|
|
try {
|
|
$stmt = db()->prepare("INSERT INTO teams (name) VALUES (?)");
|
|
$stmt->execute([$teamName]);
|
|
$message = '<div class="alert alert-success">Team added successfully!</div>';
|
|
} catch (PDOException $e) {
|
|
if ($e->errorInfo[1] == 1062) { // Duplicate entry
|
|
$message = '<div class="alert alert-danger">Error: A team with this name already exists.</div>';
|
|
} else {
|
|
$message = '<div class="alert alert-danger">Error: ' . $e->getMessage() . '</div>';
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
// Fetch all teams
|
|
$teamsStmt = db()->query("SELECT * FROM teams ORDER BY name");
|
|
$teams = $teamsStmt->fetchAll();
|
|
|
|
?>
|
|
|
|
<div class="row">
|
|
<div class="col-md-6">
|
|
<div class="card">
|
|
<div class="card-header">
|
|
<h2>Add New Team</h2>
|
|
</div>
|
|
<div class="card-body">
|
|
<?php echo $message; ?>
|
|
<form method="POST" action="teams.php">
|
|
<div class="form-group">
|
|
<label for="team_name">Team Name</label>
|
|
<input type="text" class="form-control" id="team_name" name="team_name" required>
|
|
</div>
|
|
<button type="submit" name="add_team" class="btn btn-primary">Add Team</button>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-6">
|
|
<div class="card">
|
|
<div class="card-header">
|
|
<h2>Existing Teams</h2>
|
|
</div>
|
|
<div class="card-body">
|
|
<ul class="list-group">
|
|
<?php if (count($teams) > 0): ?>
|
|
<?php foreach ($teams as $team): ?>
|
|
<li class="list-group-item"><?php echo htmlspecialchars($team['name']); ?></li>
|
|
<?php endforeach; ?>
|
|
<?php else: ?>
|
|
<li class="list-group-item">No teams found.</li>
|
|
<?php endif; ?>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
require_once __DIR__ . '/includes/footer.php';
|
|
?>
|