private function getSubjectId(Connection $conn, $benchmarkClass, $subjectName) { $stmt = $conn->prepare('SELECT id FROM subject WHERE benchmark = ? AND name = ?'); $stmt->execute([$benchmarkClass, $subjectName]); return $stmt->fetchColumn(); }