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()); }