include 'includes/body.php';
?>
<script type="text/javascript">
function getTermValue(sel){
var value = (sel.options[sel.selectedIndex].value);
var text = (sel.options[sel.selectedIndex].innerHTML);
var a = document.getElementById('termlink'); //or grab it by tagname etc
a.href = "suggest.php?termname=" + text + "&termid=" + value;
}
</script>
<font size=5><b>Search Course Schedule</b></font><br><br>
Choose a Term: <select name="term" id = "term" onChange='getTermValue(this)'>
<?php
//preload all the term
loadTerm();
?>
</select>
<br><br>
<a href="suggest.php?termid=1&termname=Fall 2013" id="termlink" style="padding:5px; background:white;">Search</a>
<br><br>
<font size=5><b>An Overview of Completed Requirements</b></font><br><br>
<?php
$allrequired = 'SELECT TypeName, TotalCredit, GID, GroupAlternetive, Graded, ClassAlternetive, CID, CName, Credit FROM TrackClasses WHERE MID = ? ORDER BY TypeName, GID, ClassAlternetive, CName';
printSchedule($allrequired, $keys);
$mysqli->close();
?>
<?php
include 'includes/footer.php';
$classes_to_save[] = $a_class_to_save;
}
}
// build the array of fields to pass through
$fields = array();
if (isset($classes_to_save[0]) && count($classes_to_save[0]) > 0) {
foreach ($classes_to_save[0] as $k => $v) {
$fields[] = $k;
}
} else {
echo "no classes";
return "no classes";
}
saveData($semester, $year, $subclasses_to_save, $fields, "subclass_identifier", "classes", array("last_mod_time"), array("crn" => "0"));
return saveData($semester, $year, $classes_to_save, $fields, "crn", "classes", array("last_mod_time"), array("parent_class" => "0"));
}
if (!open_db()) {
echo "failed to connect to database, aborting";
return FALSE;
}
$term = loadTerm(getNextTerm());
while ($term !== NULL) {
echo "===============================================================================\n";
echo "===============================================================================\n";
echo "..." . $term["name"] . "\n";
echo "...subjects\n";
saveSubjects($term);
echo "...classes\n";
saveClasses($term);
$term = loadTerm(getNextTerm());
}