// Specify domains from which requests are allowed
header( 'Access-Control-Allow-Origin: *' );
// Specify which request methods are allowed
header( 'Access-Control-Allow-Methods: GET, POST, OPTIONS' );
// Additional headers which may be sent along with the CORS request
// The X-Requested-With header allows jQuery requests to go through
header( 'Access-Control-Allow-Headers: X-Requested-With' );
// Set the age to 1 day to improve speed/caching.
header( 'Access-Control-Max-Age: 86400' );
// Exit early so the page isn't fully loaded for options requests
if ( strtolower( $_SERVER[ 'REQUEST_METHOD' ] ) == 'options' ) {
exit();
}
// If raw post data, this could be from IE8 XDomainRequest
// Only use this if you want to populate $_POST in all instances
if ( isset( $HTTP_RAW_POST_DATA ) ) {
$data = explode( '&', $HTTP_RAW_POST_DATA );
foreach ( $data as $val ) {
if ( !empty( $val ) ) {
list( $key, $value ) = explode( '=', $val );
$_POST[ $key ] = urldecode( $value );
}
}
}
function displayCourse($val) {
echo '
'.$val['CourseName'].''.
($val['Honors'] == true ? "
" : "").
($val['Certified'] == true ? "
" : "").
($val['Mobile'] == true ? "
" : "").
($val['Preview'] == true ? "
" : "").
'';
}
function displayMSCourse($val) {
echo ''.$val['CourseName'].''.
($val['Honors'] == true ? "
" : "").
($val['Certified'] == true ? "
" : "").
($val['Mobile'] == true ? "
" : "").
($val['Preview'] == true ? "
" : "").
'';
}
$myServer = "localhost";
$myUser = "myflvs_courses";
$myPass = "LWnpUGuP8pm9";
$myDB = "myflvs_courses";
$connection = mysqli_connect($myServer, $myUser, $myPass, $myDB);
// Check connection
if ($connection -> connect_errno) {
echo "Failed to connect to MySQL: " . $connection -> connect_error;
exit();
}
?>
$query = "SELECT `id`, `CourseName`, `hideFromCatalog`, `Honors`, `Certified`, `Mobile`, `Preview`, `SubjectId`, `CourseId`
FROM `full_time`
WHERE `GradeLevel` = 'H' AND `hideFromCatalog` = false
ORDER BY `CourseName`";
$result = $connection -> query($query);
while ($row = $result->fetch_assoc()) {
$SubjectId = $row['SubjectId'];
$CourseId = $row['id'];
if($SubjectId == 4 || $SubjectId == 6 || $SubjectId == 7 || $SubjectId == 8 || $SubjectId == 10 || $SubjectId == 11 || $SubjectId == 39 || $SubjectId == 101 || $SubjectId == 105){
$courses[$SubjectId][$CourseId] = $row;
}else{
$courses["elective"][$CourseId] = $row;
}
}
//print_r($courses);
$result->free();
?>
English
foreach($courses[4] as $key => $val) { displayCourse($val); } ?>
Mathematics
foreach($courses[8] as $key => $val) { displayCourse($val); } ?>
Science
foreach($courses[10] as $key => $val) { displayCourse($val); } ?>
Social Studies
foreach($courses[11] as $key => $val) { displayCourse($val); } ?>
Health/Physical Education
foreach($courses[7] as $key => $val) { displayCourse($val); } ?>
World Languages
foreach($courses[6] as $key => $val) { displayCourse($val); } ?>
//sort($courses["elective"]);
$numElectives = count($courses["elective"]);
$perCol = ceil($numElectives / 3);
$iCol = 0;
foreach($courses["elective"] as $key => $val) {
if($iCol==$perCol){
$iCol=0;
?>
}
displayCourse($val);
$iCol++;
}
?>
Through these courses, students learn skills to equip them for a successful future and are able to obtain industry credentials to prepare for various college and career paths. Please note: the honors courses in this section are only offered on the honors level. Learn more about CTE with FLVS.
//sort($courses[39]);
$numCapeElectives = count($courses[39]);
$perCol = ceil($numCapeElectives / 3);
$iCol = 0;
foreach($courses[39] as $key => $val) {
if($iCol==$perCol){
if($numCapeElectives == 4){
$perCol = 1; //if the number of courses equals 4, this divides it out over 3 columns instead of just 2
}
$iCol=0;
?>
}
displayCourse($val);
$iCol++;
}
?>
(AP courses are college level and approved by the College Board.)
//sort($courses[101]);
$numAP = count($courses[101]);
$perCol = ceil($numAP / 3);
$iCol = 0;
foreach($courses[101] as $key => $val) {
if($iCol==$perCol){
$iCol=0;
?>
}
displayCourse($val);
$iCol++;
}
?>
//sort($courses[39]);
$numCapeElectives = count($courses[105]);
$perCol = ceil($numCapeElectives / 3);
$iCol = 0;
foreach($courses[105] as $key => $val) {
if($iCol==$perCol){
if($numCapeElectives == 4){
$perCol = 1; //if the number of courses equals 4, this divides it out over 3 columns instead of just 2
}
$iCol=0;
?>
}
displayCourse($val);
$iCol++;
}
?>
Courses subject to availability.
$query = "SELECT `id`, `CourseName`, `hideFromCatalog`, `Honors`, `Certified`, `Mobile`, `Preview`, `SubjectId`, `CourseId`, `MiddleOrder`, `GradeLevel`
FROM `full_time`
WHERE `GradeLevel` = 'M' AND `hideFromCatalog` = false OR `GradeLevel` = 'B' AND `hideFromCatalog` = false
ORDER BY `SubjectId`, `MiddleOrder`";
$result = $connection -> query($query);
$courses = null;
while ($row = $result->fetch_assoc()) {
if($row['SubjectIdOverride']){
$SubjectId = $row['SubjectIdOverride'];
}else{
$SubjectId = $row['SubjectId'];
}
$CourseId = $row['id'];
if($SubjectId == 4 || $SubjectId == 8 || $SubjectId == 10 || $SubjectId == 11){
$courses[$SubjectId][$CourseId] = $row;
}else{
$courses["elective"][$CourseId] = $row;
}
}
function sortByOrder($a, $b) {
return $a['MiddleOrder'] - $b['MiddleOrder'];
}
usort($courses["elective"], 'sortByOrder'); // sorts electives differently since they are not all in the same category (high school courses)
//print_r($courses["elective"]);
$result->free();
?>
English
foreach($courses[4] as $key => $val) { displayMSCourse($val); } ?>
Mathematics
foreach($courses[8] as $key => $val) { displayMSCourse($val); } ?>
Science
foreach($courses[10] as $key => $val) { displayMSCourse($val); } ?>
Social Studies
foreach($courses[11] as $key => $val) { displayMSCourse($val); } ?>
//sort($courses["elective"]);
$numElectives = count($courses["elective"]);
$perCol = ceil($numElectives / 3);
$iCol = 0;
foreach($courses["elective"] as $key => $val) {
if($iCol==$perCol){
$iCol=0;
?>
}
displayMSCourse($val);
$iCol++;
}
?>
* High school credit course. Courses subject to availability.
$query = "SELECT `id`, `CourseName`, `hideFromCatalog`, `Honors`, `Certified`, `Mobile`, `Preview`, `SubjectId`, `CourseId`, `MiddleOrder`
FROM `full_time`
WHERE `GradeLevel` = 'E' AND `hideFromCatalog` = false
ORDER BY `SubjectId`, `MiddleOrder`";
$result = $connection -> query($query);
$courses = null;
while ($row = $result->fetch_assoc()) {
if($row['SubjectIdOverride']){
$SubjectId = $row['SubjectIdOverride'];
}else{
$SubjectId = $row['SubjectId'];
}
$CourseId = $row['id'];
$courses[$SubjectId][$CourseId] = $row;
}
usort($courses["elective"], 'sortByOrder'); // sorts electives differently since they are not all in the same category (high school courses)
//print_r($courses["elective"]);
$result->free();
?>
Language Arts
foreach($courses[4] as $key => $val) { displayMSCourse($val); } ?>
Mathematics
foreach($courses[8] as $key => $val) { displayMSCourse($val); } ?>
Science
foreach($courses[10] as $key => $val) { displayMSCourse($val); } ?>
Social Studies
foreach($courses[11] as $key => $val) { displayMSCourse($val); } ?>
Art
foreach($courses[103] as $key => $val) { displayMSCourse($val); } ?>
Physical Education (PE)
foreach($courses[7] as $key => $val) { displayMSCourse($val); } ?>
Spanish
foreach($courses[102] as $key => $val) { displayMSCourse($val); } ?>
Computer Science
foreach($courses[104] as $key => $val) { displayMSCourse($val); } ?>
Courses subject to availability.
$connection->close(); ?>