while ($row = OCI_Fetch_Array($result, OCI_BOTH)) { echo "<tr><td>" . $row["NAME"] . "</td><td>" . $row["MAXSIZE"] . "</td><td>" . $row["PRICE"] . "</td></tr>"; } echo "</table>"; } function printActivityUseTable($result) { echo "<table class=\"myTable\">"; echo "<tr>\n\t\t\t\t<th>Activity ID</th>\n\t\t\t\t<th>Name</th>\n\t\t\t\t<th>Day</th><th></th><th></th>\n\t\t\t\t<th>Start Time</th><th></th><th></th>\n\t\t\t\t<th>End Time</th><th></th>\n\t\t\t\t<th>Room</th>\n\t\t\t</tr>"; while ($row = OCI_Fetch_Array($result, OCI_BOTH)) { echo "<tr><td>" . $row["ACTIVITY_ID"] . "</td><td>" . $row["NAME"] . "</td><td>" . $row["DAY"] . "</td><td>" . "</td><td>" . "</td><td>" . $row["START_TIME"] . "</td><td>" . "</td><td>" . "</td><td>" . $row["END_TIME"] . "</td><td>" . "</td><td>" . $row["ROOMNUM"] . "</td></tr>"; } echo "</table>"; } if ($db_conn) { dropDownFromQuery($attr_name, $table, "activities.php"); // Display Activity_Info and Activity_Uses entires $activityInfoCmd = "select * from Activity_Info"; $activityUseCmd = "select * from Activity_uses"; if ($_POST["activityName"] != "") { $activityInfoCmd = "select * from Activity_Info where name like '%" . $_POST["activityName"] . "%'"; $activityUseCmd = "select * from Activity_uses where name like '%" . $_POST["activityName"] . "%'"; } echo '<h2>Activity Info</h2>'; $result1 = executePlainSQL($activityInfoCmd); printActivityInfoTable($result1); echo '<h2>Activity Uses</h2>'; $result2 = executePlainSQL($activityUseCmd); printActivityUseTable($result2); } ?>
// echo $queryString . "<br>"; $result = executePlainSQL($queryString); printResultTable($result, "Classes", $attributes[1], $attributes[2]); } if ($db_conn) { // Generate form for user input echo "<h2>Filter Classes</h2>"; generateClassForm(); if ($_GET["select"] == "Search...") { echo "<b>ERROR: Not a valid search term</b> <br>"; } elseif (array_key_exists("selectMode", $_GET)) { executeClassQuery(projectionConditions(), $_GET["selectMode"]); } // Create Dropdown Menu echo "<h2>Class Names</h2>"; dropDownFromQuery($attr_name, $table, "classes.php"); // Display Class_Info and Class_Uses entires $classInfoCmd = "select * from class_info"; $classUseCmd = "select c.activity_ID, c.name, c.day, c.start_time, c.end_time, c.repeatedOn, c.NumOfSessions, c.roomNum, t.name as InstructorName from class_uses c, teaches t where c.activity_id = t.activity_id"; if ($_POST["activityName"] != "") { $classInfoCmd = "select * from class_info where name like '%" . $_POST["activityName"] . "%'"; $classUseCmd = "select c.activity_ID, c.name, c.day, c.start_time, c.end_time, c.repeatedOn, c.NumOfSessions, c.roomNum, t.name as InstructorName from class_uses c, teaches t where c.name like '%" . $_POST["activityName"] . "%' and c.activity_id = t.activity_id"; } echo '<h2>Class Info</h2>'; $result1 = executePlainSQL($classInfoCmd); printClassInfoTable($result1); echo '<h2>Class Uses</h2>'; $result2 = executePlainSQL($classUseCmd); printClassUseTable($result2); } ?>