query($sql);
// Get the count value
$totalVacancies = 0;
if ($result && $row = $result->fetch_assoc()) {
$totalVacancies = $row['total_vacancies'];
}
$sql1 = "SELECT COUNT(*) as total_contact FROM contact_book";
$result1 = $conn->query($sql1);
$totalContact = 0;
if ($result1 && $row1 = $result1->fetch_assoc()) {
$totalContact = $row1['total_contact'];
}
$sql2 = "SELECT COUNT(*) as total_reg FROM emp_reg";
$result2 = $conn->query($sql2);
$totalEmpReg = 0;
if ($result2 && $row2 = $result2->fetch_assoc()) {
$totalEmpReg = $row2['total_reg'];
}
$sql3 = "SELECT COUNT(*) as total_appointment FROM emp_reg where status='Yes'";
$result3 = $conn->query($sql3);
$totalAppointment = 0;
if ($result3 && $row3 = $result3->fetch_assoc()) {
$totalAppointment = $row3['total_appointment'];
}
$sql4 = "SELECT COUNT(*) as total_post FROM post";
$result4 = $conn->query($sql4);
$totalPOST = 0;
if ($result4 && $row4 = $result4->fetch_assoc()) {
$totalPOST = $row4['total_post'];
}
$sql5= "SELECT COUNT(*) as total_Emp FROM applications";
$result5 = $conn->query($sql5);
$totalEmp = 0;
if ($result5 && $row5 = $result5->fetch_assoc()) {
$totalEmp = $row5['total_Emp'];
}
$sql7= "SELECT COUNT(*) as total_Emp FROM applications where status='Selected'";
$result7 = $conn->query($sql7);
$totalSELEmp = 0;
if ($result7&& $row7 = $result7->fetch_assoc()) {
$totalSELEmp = $row7['total_Emp'];
}
$sql6= "SELECT COUNT(*) as total_Emp FROM applications where status='Reject'";
$result6 = $conn->query($sql6);
$totalEmp6 = 0;
if ($result6 && $row6 = $result6->fetch_assoc()) {
$totalEmp6 = $row6['total_Emp'];
}
?>