connect_error) { die("Connection failed: " . $conn->connect_error); } // Fetch distinct evaluation dates from the evaluations table and order them $sql = "SELECT DISTINCT evaluation_date FROM evaluations ORDER BY evaluation_date"; $result = $conn->query($sql); $dates = array(); while ($row = $result->fetch_assoc()) { $dates[] = $row['evaluation_date']; } // Fetch distinct employee names from the evaluations table $sql = "SELECT DISTINCT employeeName FROM evaluations"; $result = $conn->query($sql); $employeeNames = array(); while ($row = $result->fetch_assoc()) { $employeeNames[] = $row['employeeName']; } $conn->close(); ?>
Employee Name | Total | Score | Detail | |
---|---|---|---|---|
query($sql); $totalScore = $result->fetch_assoc()['total_score']; $totalSumForRow += $totalScore; $conn->close(); ?> | 9) { $scoreClass = 'green'; } elseif ($score > 6 && $score < 9) { $scoreClass = 'yellow'; } elseif ($score > 5.009 && $score < 8) { $scoreClass = 'orange'; } ?> | View Details |