Available Training Courses
if($register_off == 1){
echo '
Online registration available again in on Wednesday, April 8th. Please come back then. Sorry for the issue...
';
} else {
?>
| Class |
Class Date |
Location |
Students/Slots |
Class Itinerary |
Register |
$today = date("Y-m-d");
$table = 'scheduled_classes';
$query = "SELECT * FROM $table WHERE sced_date > '$today' and cancelled = '0' ORDER BY sced_date";
//echo $query;
$result = $mysqli->query($query)
or die('Could not select: '.$query.'
' .$mysqli->error);
$num_rows = $result->num_rows;
while($row = $result->fetch_assoc()){
$class_location_array = what_class_location($row['class_number'],$mysqli);
echo "";
echo "| ".$class_location_array['class_name']." | ";
echo "";
echo convert_udate($row['sced_date'])." - ";
$second = date("m-d-Y",strtotime($row['sced_date']) + 25*60*60);
echo $second;
echo " | ";
echo "".$class_location_array['city']." | ";
if(student_class_count($row['rec_num'],$mysqli) >= $class_location_array['max_students'])
echo "Class Full | ";
else
echo "".student_class_count($row['rec_num'],$mysqli)."/".$class_location_array['max_students']." | ";
echo " | ";
if(student_class_count($row['rec_num'],$mysqli) >= $class_location_array['max_students']){
echo "- | ";
} else {
if($register_off == 0)
echo " | ";
else {
echo "Coming Soon... | ";
}
}
echo "
";
}
?>
Advanced/Special Classes
| Class |
Date |
City |
Students/Slots |
Class Itinerary |
Register |
$table = 'special';
$result = $mysqli->query("SELECT * FROM $table WHERE class_date > '$today' and cancelled = '0' and closed = '0' ORDER BY class_date")
or die('Could not select: '.$query.'
' .$mysqli->error);
$num_rows = $result->num_rows;
while($row = $result->fetch_assoc()){
echo "";
echo "| ".$row['class_name']." | ";
echo "".convert_udate($row['class_date'])." | ";
echo "".$row['city']." | ";
echo "".student_class_count_special($row['rec_num'],$mysqli)."/".$row['max_students']." | ";
echo " | ";
echo " | ";
echo "
";
}
if($num_rows == 0){
echo "";
echo "| No Classes Available At This Time | ";
echo " | ";
echo " | ";
echo " | ";
echo " | ";
echo "
";
}
?>
Unscheduled Classes
The following classes are not currently scheduled, but we will schedule them for groups. Please contact us for details.
| Class |
City |
Maximum Class Size |
Minimum Class Size |
Per Student Fee |
Class Itinerary |
$table = 'unsched';
$result = $mysqli->query("SELECT * FROM $table ORDER BY class_name")
or die('Could not select: '.$query.'
' .$mysqli->error);
$num_rows = $result->num_rows;
while($row = $result->fetch_assoc()){
echo "";
echo "| ".$row['class_name']." | ";
echo "".$row['city']." | ";
echo "".$row['max_students']." | ";
echo "".$row['min_students']." | ";
echo "$".$row['fee']." | ";
echo " | ";
echo "
";
}
if($num_rows == 0){
echo "";
echo "| No Classes Available At This Time | ";
echo " | ";
echo " | ";
echo " | ";
echo "
";
}
?>
}
?>