$spacesAvailable = intval($sectionData['spaces_available']);
$seatOpen = 0;
$instructor = "";
$temp = (array) $sectionData['instructor']->last_name;
if (!empty($temp)) {
$instructor = $sectionData['instructor']->first_name . " " . $sectionData['instructor']->last_name;
}
$publishedCourseName = $departmentData->OfferedCourses->course["{$courseIndex}"]->PublishedCourseID . ": " . $departmentData->OfferedCourses->course["{$courseIndex}"]->CourseData->title . " section " . $sectionNumber;
// begin checking tables if data is already present
mysqli_query($link, "START TRANSACTION");
// check if dept exists for this term in departments table
$query = "SELECT deptAbbreviation FROM departments WHERE term=" . $term . " AND deptAbbreviation='" . $deptAbbreviation . "'";
$result = mysqli_query($link, $query);
if (mysqli_num_rows($result) == 0) {
$targetURL = "http://web-app.usc.edu/ws/soc/api/session/001/{$term}";
$servResponse = curlURL($targetURL);
if ($servResponse == FALSE) {
sqlCommRollChanges(1, $link, $publishedCourseName);
}
$jsonTermResponse = json_decode($servResponse);
$expDate = strtotime($jsonTermResponse->end_of_session);
// insert the dept and term into the departments table
$insertQuery = "INSERT INTO departments (term, deptAbbreviation, department, courseDataURL, expDate) VALUES (" . $term . ",'" . $deptAbbreviation . "','" . $department . "','" . $courseDataURL . "'," . $expDate . ")";
mysqli_query($link, $insertQuery);
if (mysqli_errno($link) != 0) {
sqlCommRollChanges(1, $link, $publishedCourseName);
}
}
// check if course exists for this term in the courses table
$query = "SELECT deptAbbreviation FROM courses WHERE term=" . $term . " AND deptAbbreviation='" . $deptAbbreviation . "' AND sectionNumber=" . $sectionNumber;
$result = mysqli_query($link, $query);
<?php
// edit
require_once "../../global/includes/gbFunctions.php";
$targetURL = "http://web-app.usc.edu/ws/soc/api/classes/" . $_GET['dept'] . "/" . $_GET['term'];
$offeredCourses = json_decode(curlURL($targetURL))->OfferedCourses->course;
$listData = "";
$sectionData = "";
$courseIndex = 0;
$listData .= "<ul class='ui-drop-menu ui-select' id='ui-course-select'>";
foreach ($offeredCourses as $course) {
$sequence = "";
$suffix = "";
$courseNumber = $course->CourseData->number;
$courseTitle = $course->CourseData->title;
$deptName = $course->CourseData->prefix;
// check if sequence is there
if (gettype($course->CourseData->sequence) != object) {
$sequence = $course->CourseData->sequence;
}
// check if suffix is there
if (gettype($course->CourseData->suffix) != object) {
$suffix = $course->CourseData->suffix;
}
// add li element with course data
$courseID = "{$courseNumber}{$sequence}{$suffix}";
$listData .= "<li id='{$deptName}-{$courseID}'>{$courseID}: {$courseTitle}</li>";
// Build sectionData
$deptName = $course->CourseData->prefix;
$courseNumber = $course->CourseData->number;
// OPEN CONTAINMENT DIV TAG
</div>
<div id='master-wrapper' class='unselectable'>
<!-- ******************************************************************************** -->
<!-- ****************************** Inline Course Browser *************************** -->
<!-- ******************************************************************************** -->
<div id='add-class-container'>
<div id='select-term-container' class='unselectable'>
<span id='selected-term'>Select Term</span>
<span class='down-arrow'></span>
<input type='hidden' id='selected-term-number'/>
</div>
<a id='close-add-container' href='/'><div class='ui-x-icon'></div></a>
<div id='term-container'>
<ul class='ui-drop-menu' id='ui-term-select'>
<?php
$servResponse = curlURL("http://web-app.usc.edu/ws/soc/api/terms");
$jsonResponse = json_decode($servResponse);
foreach ($jsonResponse->term as $term) {
$semester = "";
switch (intval(substr($term, -1))) {
case 1:
$semester = "SPRING ";
break;
case 2:
$semester = "SUMMER ";
break;
case 3:
$semester = "FALL ";
break;
}
$semester .= substr($term, 0, -1);
