<?php
$prevAllCourses = Array();
function generate_prev_courses_arrays($studentID) {
	
	//finds all core classes in the students prior degree. Will be used for comparison
	$queryPrevDegreeCore = "SELECT courseID
							FROM Core
							WHERE majorID = (SELECT prevMajor
											FROM Degree
							WHERE studentID = " . $studentID . ")";
							
	//finds all elect classes in the students prior degree. Will be used for comparison
	$queryPrevDegreeElect = "SELECT courseID
						FROM Elective
						WHERE majorID = (SELECT prevMajor
										FROM Degree
										WHERE studentID = " . $studentID . ")";						
			
	//finds all cogn classes in the students prior degree. Will be used for comparison
	$queryPrevDegreeCogn = "SELECT courseID
							FROM Cognate
							WHERE majorID = (SELECT prevMajor
											FROM Degree
											WHERE studentID = " . $studentID . ")";		

	//connects to server
	include 'connect.php';
		$connect = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or 
		die("Unable to connect to 'pi.cs.oswego.edu'");		

	//use above queries
	$previousCoreClasses = mysqli_query($connect, $queryPrevDegreeCore);
	$previousElectClasses = mysqli_query($connect, $queryPrevDegreeElect);
	$previousCognClasses = mysqli_query($connect, $queryPrevDegreeCogn);

	if(!mysqli_query($connect,$queryPrevDegreeCore) && mysqli_query($connect,$queryPrevDegreeCore) != NULL) {
				printf("Error in second query:%s\n", mysqli_error($connect));
				exit();
	} else if(!mysqli_query($connect,$queryPrevDegreeElect) && mysqli_query($connect,$queryPrevDegreeElect) != NULL) {
				printf("Error in second query:%s\n", mysqli_error($connect));
				exit();
	} else if(!mysqli_query($connect,$queryPrevDegreeCogn) && mysqli_query($connect,$queryPrevDegreeCogn) != NULL) {
				printf("Error in second query:%s\n", mysqli_error($connect));
				exit();
	} else {
		global $prevCoreCourses, $prevElectCourses, $prevCognCourses;
		
		$prevCore = mysqli_fetch_all($previousCoreClasses,MYSQLI_ASSOC);
		$prevElect = mysqli_fetch_all($previousElectClasses,MYSQLI_ASSOC);
		$prevCogn = mysqli_fetch_all($previousCognClasses,MYSQLI_ASSOC);
				
		$prevCoreCourses = Array();
		//creates an array of previous taken courses for comparison
		foreach($prevCore as $idToCourse) {
			foreach($idToCourse as $courseID=>$class){
				array_push($prevCoreCourses, $class);
			}
		}
					
		$prevElectCourses = Array();
		//creates an array of previous taken courses for comparison
		foreach($prevElect as $idToCourse) {
			foreach($idToCourse as $courseID=>$class){
				array_push($prevElectCourses, $class);
			}
		}
						
		$prevCognCourses = Array();
		//creates an array of previous taken courses for comparison
		foreach($prevCogn as $idToCourse) {
			foreach($idToCourse as $courseID=>$class){
				array_push($prevCognCourses, $class);
			}
		}		
		global $prevAllCourses;
		$prevAllCourses = array_merge(array_merge($prevCoreCourses,$prevElectCourses), $prevCognCourses);
	}
}
?>