prepare(" SELECT u.id, u.name, u.company_name, u.company_logo, u.profile_image, u.company_description, u.created_at, COUNT(CASE WHEN j.status = 'approved' THEN j.id END) as job_count FROM users u LEFT JOIN jobs j ON u.id = j.employer_id $where GROUP BY u.id, u.name, u.company_name, u.company_logo, u.profile_image, u.company_description, u.created_at ORDER BY CASE WHEN COUNT(CASE WHEN j.status = 'approved' THEN j.id END) > 0 THEN 0 ELSE 1 END, COALESCE(u.company_name, u.name) ASC "); $stmt->execute($params); $companies = $stmt->fetchAll(); $alphabetStmt = $pdo->query(" SELECT DISTINCT UPPER(LEFT(COALESCE(company_name, name), 1)) as letter FROM users WHERE role = 'employer' ORDER BY letter "); $availableLetters = $alphabetStmt->fetchAll(PDO::FETCH_COLUMN); $totalCompanies = count($companies); $companiesWithJobs = count(array_filter($companies, fn($c) => $c['job_count'] > 0)); require_once 'includes/header.php'; ?>

Company Directory

Explore top employers and their job opportunities

ALL

compan found ( with active jobs)

No companies found

No companies starting with "" were found. No companies matching "" were found. No companies are registered yet.

View All Companies

100 ? substr($company['company_description'], 0, 100) . '...' : $company['company_description']) : ''; ?>

0): ?> Job No Active Jobs

0): ?> View Jobs View Profile