<?
php
require_once '../config/[Link]';
$pageTitle = 'Manage Courses';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_course'])) {
$stmt = $conn->prepare("INSERT INTO courses (course_name, description, status)
VALUES (?, ?, ?)");
$stmt->execute([
$_POST['course_name'],
$_POST['description'],
$_POST['status']
]);
header("Location: manage_courses.php");
exit;
}
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['edit_course'])) {
$stmt = $conn->prepare("UPDATE courses SET course_name=?, description=?,
status=? WHERE id=?");
$stmt->execute([
$_POST['course_name'],
$_POST['description'],
$_POST['status'],
$_POST['course_id']
]);
header("Location: manage_courses.php");
exit;
}
if (isset($_GET['delete'])) {
$stmt = $conn->prepare("DELETE FROM courses WHERE id=?");
$stmt->execute([$_GET['delete']]);
header("Location: manage_courses.php");
exit;
}
?>
<?php include 'includes/[Link]'; ?>
<div class="container-fluid">
<div class="row">
<div class="col-md-2 d-none d-md-block bg-dark text-white p-3 border-end
border-light" style="min-height: 100vh;">
<?php include 'includes/[Link]'; ?>
</div>
<div class="col-md-10 p-4">
<div class="d-flex justify-content-between align-items-center mb-3">
<h4><i class="bi bi-book"></i> Manage Courses</h4>
<button class="btn btn-primary" data-bs-toggle="modal" data-bs-
target="#addCourseModal">
<i class="bi bi-plus-lg"></i> Add Course
</button>
</div>
<div class="table-responsive">
<table id="dataTable" class="table table-bordered table-hover
datatable">
<thead class="table-dark">
<tr>
<th>#</th>
<th>Course Name</th>
<th>Description</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$stmt = $conn->prepare("SELECT * FROM courses ORDER BY id
DESC");
$stmt->execute();
$courses = $stmt->fetchAll(PDO::FETCH_ASSOC);
$i = 1;
foreach ($courses as $course):
?>
<tr>
<td><?= $i++ ?></td>
<td><?= htmlspecialchars($course['course_name']) ?
></td>
<td><?= htmlspecialchars($course['description']) ?
></td>
<td>
<span class="badge <?= $course['status'] ===
'Open' ? 'bg-success' : 'bg-secondary' ?>">
<?= $course['status'] ?>
</span>
</td>
<td>
<button class="btn btn-sm btn-warning" data-bs-
toggle="modal" data-bs-target="#editCourseModal<?= $course['id'] ?>">
<i class="bi bi-pencil-square"></i>
</button>
<a href="?delete=<?= $course['id'] ?>"
class="btn btn-sm btn-danger" onclick="return confirm('Are you sure you want to
delete this course?');">
<i class="bi bi-trash"></i>
</a>
</td>
</tr>
<!-- Edit Modal -->
<div class="modal fade" id="editCourseModal<?=
$course['id'] ?>" tabindex="-1">
<div class="modal-dialog">
<form method="POST" class="modal-content">
<input type="hidden" name="course_id"
value="<?= $course['id'] ?>">
<div class="modal-header">
<h5 class="modal-title">Edit
Course</h5>
<button type="button" class="btn-close"
data-bs-dismiss="modal"></button>
</div>
<div class="modal-body">
<div class="mb-2">
<label>Course Name</label>
<input type="text"
name="course_name" value="<?= htmlspecialchars($course['course_name']) ?>"
class="form-control" required>
</div>
<div class="mb-2">
<label>Description</label>
<textarea name="description"
class="form-control"><?= htmlspecialchars($course['description']) ?></textarea>
</div>
<div class="mb-2">
<label>Status</label>
<select name="status" class="form-
select">
<option value="Open" <?=
$course['status'] == 'Open' ? 'selected' : '' ?>>Open</option>
<option value="Closed" <?=
$course['status'] == 'Closed' ? 'selected' : '' ?>>Closed</option>
</select>
</div>
</div>
<div class="modal-footer">
<button type="submit"
name="edit_course" class="btn btn-primary">Update</button>
<button type="button" class="btn btn-
secondary" data-bs-dismiss="modal">Cancel</button>
</div>
</form>
</div>
</div>
<?php endforeach; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- Add Course Modal -->
<div class="modal fade" id="addCourseModal" tabindex="-1">
<div class="modal-dialog">
<form method="POST" class="modal-content">
<div class="modal-header">
<h5 class="modal-title">Add Course</h5>
<button type="button" class="btn-close"
data-bs-dismiss="modal"></button>
</div>
<div class="modal-body">
<div class="mb-2">
<label>Course Name</label>
<input type="text" name="course_name" class="form-control"
required>
</div>
<div class="mb-2">
<label>Description</label>
<textarea name="description" class="form-control"></textarea>
</div>
<div class="mb-2">
<label>Status</label>
<select name="status" class="form-select">
<option value="Open">Open</option>
<option value="Closed">Closed</option>
</select>
</div>
</div>
<div class="modal-footer">
<button type="submit" name="add_course" class="btn btn-
success">Add</button>
<button type="button" class="btn btn-secondary" data-bs-
dismiss="modal">Cancel</button>
</div>
</form>
</div>
</div>
<?php include 'includes/[Link]'; ?>
CREATE TABLE `courses` (
`id` int(11) NOT NULL,
`course_name` varchar(100) DEFAULT NULL,
`description` text DEFAULT NULL,
`fee` decimal(10,2) DEFAULT NULL,
`status` enum('Open','Closed') DEFAULT 'Open'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;