$page = 'home'; $pageTitle = 'Nursing Jobs';
require_once __DIR__ . '/includes/header.php';
$totalJobs = $pdo->query("SELECT COUNT(*) FROM jobs WHERE status='open'")->fetchColumn();
$totalHosp = $pdo->query("SELECT COUNT(*) FROM employers")->fetchColumn();
$totalNurses = $pdo->query("SELECT COUNT(*) FROM candidates")->fetchColumn();
$totalVac = $pdo->query("SELECT COALESCE(SUM(vacancies),0) FROM jobs WHERE status='open'")->fetchColumn();
$latest = $pdo->query("
SELECT j.*, e.hospital_name
FROM jobs j JOIN employers e ON e.id = j.employer_id
WHERE j.status='open'
ORDER BY j.created_at DESC LIMIT 6
")->fetchAll();
$cities = $pdo->query("SELECT DISTINCT city FROM jobs WHERE status='open' ORDER BY city")->fetchAll(PDO::FETCH_COLUMN);
?>
ICU, OT, ward and community positions from verified hospitals — filtered by your qualification, city and experience.
Warning: Undefined variable $totalVac in /home/u489391397/domains/job.udaaninstitute.org/public_html/index.php on line 25
0 vacancies open right now
Your next nursing role, without the endless scrolling.
Freshly posted by verified hospitals