function getOfferingBySidOrderByAscent($sid) { $result = getStu_offeringBySid($sid); $oidArray = array(); $timeTable = array(); while ($row = mysql_fetch_array($result)) { $oid = $row['oid']; array_push($oidArray, $oid); } $timeTable = array(); array_push($timeTable, getOfferingByOidArray($oidArray, "Mon")); array_push($timeTable, getOfferingByOidArray($oidArray, "Tue")); array_push($timeTable, getOfferingByOidArray($oidArray, "Wed")); array_push($timeTable, getOfferingByOidArray($oidArray, "Thu")); array_push($timeTable, getOfferingByOidArray($oidArray, "Fri")); array_push($timeTable, getOfferingByOidArray($oidArray, "Sat")); array_push($timeTable, getOfferingByOidArray($oidArray, "Sun")); //print_r($timeTable); return $timeTable; }
for ($i = 0; $i < count($error); $i++) { echo $i + 1; echo "."; echo $error[$i]; echo "<br/>"; } ?> <a href="javascript:history.back()">back</a> <a href="displayCourse.php">home page</a> <!--</div>--> </p> <?php } else { //echo "xx"; $temp = getStu_offeringBySid($sid); $timeTable = array(); //#1.遍历该学生所选的offering,将该学生的课程时间放入一个临时的表里 while ($row = mysql_fetch_array($temp)) { //print_r($row); $offeringResult = getOfferingById($row['oid']); $offeringRow = mysql_fetch_array($offeringResult); // print_r($offeringRow); $timeTable = setOfferingTimeTable($offeringRow, $timeTable); } // print_r($timeTable); if (isOccupied($lecOid, $timeTable) == true) { // echo 1; if ($labOid != null) { if (isOccupied($labOid, $timeTable) == true) { // echo 1;
<br><br> <div style="position:relative; left:100px"> <b> Course taken:</b><br> <table border="1" width="710" > <tr> <th height="20">Course ID</th> <th height="20">Course Title</th> <th height="20">Instructor Name</th> <th height="20">Class Time</th> <th height="20">Classroom</th> <th height="20">Taken in</th> <th height="20">Grade</th> </tr> <?php $result = getStu_offeringBySid($sid); while ($row = mysql_fetch_array($result)) { // echo $row['oid']; $innerResult = getOfferingById($row['oid']); // echo $innerResult; $innerRow = mysql_fetch_array($innerResult); echo "<tr>"; // echo "<td>"; // echo $innerRow['oid']; // echo "</td>"; echo "<td height='35'>"; echo $innerRow['cid'] . "<br/>" . strtoupper($innerRow['component']); echo "</td>"; echo "<td>"; echo ucwords($innerRow['courseTitle']); echo "</td>";