[], 'junior_secondary' => [], 'senior_secondary' => [], ]; $marketplaceError = ''; $subjectListError = ''; try { $subjectStmt = $pdo->query("SELECT id, name, education_level FROM subjects WHERE is_active = 1 AND education_level IN ('primary', 'junior_secondary', 'senior_secondary') ORDER BY education_level, name"); foreach ($subjectStmt->fetchAll(PDO::FETCH_ASSOC) as $subjectRow) { $level = (string)$subjectRow['education_level']; if (isset($subjectsByLevel[$level])) { $subjectsByLevel[$level][] = $subjectRow; } } } catch (Throwable $exception) { error_log('StaffRoom subject list query failed: ' . $exception->getMessage()); $subjectListError = 'The subject list is temporarily unavailable. Please try again later.'; } try { $sql = "SELECT u.id AS user_id, u.full_name, tp.headline, tp.bio, tp.state, tp.city, tp.experience_years, tp.teaching_mode, tp.hourly_rate, tp.profile_photo, tp.plan, tp.verification_status, (SELECT GROUP_CONCAT(s.name ORDER BY s.name SEPARATOR ', ') FROM teacher_subjects ts INNER JOIN subjects s ON s.id = ts.subject_id AND s.is_active = 1 WHERE ts.teacher_id = u.id) AS subject_names FROM users u INNER JOIN roles r ON r.id = u.role_id INNER JOIN teacher_profiles tp ON tp.user_id = u.id WHERE r.name = :role_name AND u.status = :user_status AND tp.is_marketplace_visible = 1 ORDER BY CASE WHEN tp.verification_status = 'verified' THEN 0 ELSE 1 END, u.full_name ASC"; $stmt = $pdo->prepare($sql); $stmt->execute([ ':role_name' => 'teacher', ':user_status' => 'active', ]); $teachers = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Throwable $exception) { error_log('StaffRoom marketplace query failed: ' . $exception->getMessage()); $marketplaceError = 'Teacher profiles are temporarily unavailable. Please try again shortly.'; } function staffroom_verification_label(string $status): string { return match ($status) { 'verified' => 'Verified', 'pending' => 'Verification pending', 'rejected' => 'Not verified', 'suspended' => 'Not verified', default => 'Not verified', }; } function staffroom_mode_label(string $mode): string { $values = array_filter(array_map('trim', explode(',', $mode))); $labels = []; foreach ($values as $value) { if ($value === 'online') $labels[] = 'Online'; if ($value === 'physical') $labels[] = 'In-person'; if ($value === 'hybrid') $labels[] = 'Hybrid'; } return $labels ? implode(' + ', array_unique($labels)) : 'Mode not specified'; } ?>
A teacher marketplace where schools and parents can discover educators by location, subject, experience, teaching mode and verified status.
Connect with vetted teachers available for physical, online, or hybrid tutoring and institutional recruitment.
No teachers listed in the marketplace yet.
Be among the first educators to register your profile below!
Subjects: = staffroom_escape($t['subject_names']) ?>
Simple and transparent hiring and tutoring connection process for schools, parents, and educators.
Register your teacher account, add your bio, experience, location, and select your teaching subjects.
Submit your credentials for verification to earn the green verified badge and gain maximum trust.
Parents and schools filter through verified educators and initiate direct contact or session bookings.
Deliver exceptional online or physical lessons and build your professional tutoring career on IntelCowry.
Are you a qualified Nigerian educator? Register your profile today to connect with schools and private clients.