adbms-gym/instructor.php at main · scoop23/adbms-gym · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123

<?php
session_start();
include "db.php";

// Check if instructor is logged in
if (!isset($_SESSION['user_id']) || $_SESSION['role'] !== 'instructor') {
    header("Location: login.php");
    exit();
}

$instructor_id = $_SESSION['user_id'];

// get instructor info
$stmt = $conn->prepare("SELECT u.first_name, u.last_name, u.email, u.phone, i.bio, i.photo, i.certifications, i.specialties
                        FROM instructors i
                        JOIN users u ON i.instructor_id = u.user_id
                        WHERE i.instructor_id = ?");
$stmt->bind_param("s", $instructor_id);
$stmt->execute();
$instructor = $stmt->get_result()->fetch_assoc();

// get instructor classes and schedules
$sql_classes = "SELECT c.name, c.description, s.schedule_id, s.start_time, s.end_time, s.location
                FROM schedules s
                JOIN classes c ON s.class_id = c.class_id
                WHERE s.instructor_id = ?
                ORDER BY s.start_time DESC";
$stmt_classes = $conn->prepare($sql_classes);
$stmt_classes->bind_param("s", $instructor_id);
$stmt_classes->execute();
$classes = $stmt_classes->get_result();

// get reviews
$sql_reviews = "SELECT r.rating, r.comment, r.review_time, u.first_name, u.last_name
                FROM reviews r
                JOIN users u ON r.user_id = u.user_id
                WHERE r.instructor_id = ?
                ORDER BY r.review_time DESC";
$stmt_reviews = $conn->prepare($sql_reviews);
$stmt_reviews->bind_param("s", $instructor_id);
$stmt_reviews->execute();
$reviews = $stmt_reviews->get_result();
?>
<!DOCTYPE html>
<html>
<head>
  <title>Instructor Dashboard | Gym Portal</title>
  <link rel="stylesheet" href="./css/instructor.css?v=<?php echo time(); ?>">
</head>
<body>
  <div class="dashboard-container">
    <h1 class="dashboard-title">Welcome, <?php echo htmlspecialchars($instructor['first_name'] . ' ' . $instructor['last_name']); ?>!</h1>
    <div class="profile-section">
      <img class="profile-photo" src="<?php echo 'uploads/' . htmlspecialchars($instructor['photo'] ?: 'https://via.placeholder.com/90'); ?>" alt="Profile Photo">
      <div class="profile-info">
        <div><b>Email:</b> <?php echo htmlspecialchars($instructor['email']); ?></div>
        <div><b>Phone:</b> <?php echo htmlspecialchars($instructor['phone']); ?></div>
        <div><b>Specialties:</b> <?php echo htmlspecialchars($instructor['specialties']); ?></div>
        <div><b>Certifications:</b> <?php echo htmlspecialchars($instructor['certifications']); ?></div>
        <div><b>Bio:</b> <?php echo htmlspecialchars($instructor['bio']); ?></div>
      </div>
    </div>

    <div class="section-title">Your Scheduled Classes
      <form method="GET" action="classes.php">
        <button type="submit">Create a Class</button>
      </form>
    </div>

    <table class="class-table">
      <tr>
        <th>Class Name</th>
        <th>Description</th>
        <th>Location</th>
        <th>Start Time</th>
        <th>End Time</th>
      </tr>
      <?php if ($classes->num_rows > 0): ?>
        <?php while($row = $classes->fetch_assoc()): ?>
          <tr>
            <td><?php echo htmlspecialchars($row['name']); ?></td>
            <td><?php echo htmlspecialchars($row['description']); ?></td>
            <td><?php echo htmlspecialchars($row['location']); ?></td>
            <td><?php echo htmlspecialchars($row['start_time']); ?></td>
            <td><?php echo htmlspecialchars($row['end_time']); ?></td>
          </tr>
        <?php endwhile; ?>
      <?php else: ?>
        <tr><td colspan="5">No scheduled classes.</td></tr>
      <?php endif; ?>
    </table>

    <div class="section-title">Recent Reviews</div>
    <table class="review-table">
      <tr>
        <th>Client</th>
        <th>Rating</th>
        <th>Comment</th>
        <th>Date</th>
      </tr>
      <?php if ($reviews->num_rows > 0): ?>
        <?php while($row = $reviews->fetch_assoc()): ?>
          <tr>
            <td><?php echo htmlspecialchars($row['first_name'] . ' ' . $row['last_name']); ?></td>
            <td class="review-rating"><?php echo str_repeat('⭐', (int)$row['rating']); ?></td>
            <td><?php echo htmlspecialchars($row['comment']); ?></td>
            <td><?php echo htmlspecialchars($row['review_time']); ?></td>
          </tr>
        <?php endwhile; ?>
      <?php else: ?>
        <tr><td colspan="4">No reviews yet.</td></tr>
      <?php endif; ?>
    </table>

    <form action="logout.php" method="POST">
      <input type="hidden" name="action" value="logout">
        <button type="submit">Logout</button>
    </form>
  </div>
</body>
</html>
<?php $conn->close(); ?>