0) {
$semStart = "$semesterYear-08-01";
$semEnd = ($semesterYear + 1) . '-06-30';
$query .= " AND cgs.Start_Date >= ? AND cgs.End_Date <= ?";
}
$query .= " GROUP BY cgs.Program_ID, cgs.Group_ID, cgs.Course_ID) AS sub";
if ($stmt = $mysqli->prepare($query)) {
if ($semesterYear > 0) {
$stmt->bind_param("iss", $Teacher_ID, $semStart, $semEnd);
} else {
$stmt->bind_param("i", $Teacher_ID);
}
if ($stmt->execute()) {
$result = $stmt->get_result();
$row = $result->fetch_assoc();
echo $row['total_hours'];
} else {
echo "0";
}
$stmt->close();
} else {
echo "0";
}
} else {
echo "0";
}
?>