function registerRoom($id, $rtype, $floor, $prize) { include "select_Room.php"; $value = selectRoom($id); if ($value == false) { mysql_query("INSERT INTO rooms (id,rtype,floor,prize) VALUES ('" . $id . "','" . $rtype . "','" . $floor . "','" . $prize . "');"); return true; } else { return false; } }
<tr> <td bgcolor="#D9D9FF" align="center">3 pm</td> <?php selectRoom('S1500'); timeLine('S1500', 'Saturday 3:00pm', $checked); timeLine('S1510', 'Saturday 3:10pm', $checked); timeLine('S1520', 'Saturday 3:20pm', $checked); timeLine('S1530', 'Saturday 3:30pm', $checked); timeLine('S1540', 'Saturday 3:40pm', $checked); timeLine('S1550', 'Saturday 3:50pm', $checked); ?> </tr> <tr> <td bgcolor="#6699FF" align="center">4 pm</td> <?php selectRoom('S1600'); timeLine('S1600', 'Saturday 4:00pm', $checked); timeLine('S1610', 'Saturday 4:10pm', $checked); timeLine('S1620', 'Saturday 4:20pm', $checked); timeLine('S1630', 'Saturday 4:30pm', $checked); timeLine('S1640', 'Saturday 4:40pm', $checked); timeLine('S1650', 'Saturday 4:50pm', $checked); ?> </tr> </table> <input type="submit" value="Update" name="Update"> <input type="submit" value="Clear Schedule" name="Reset"> </form> <?php footer("Return to Event Selection", "AdminSchedule.php"); ?>
?> " name="EventID"/> <input type="hidden" value="<?php print $SchedID; ?> " name="SchedID"/> <input type="submit" value="Update" name="Save"/> </td> <td colspan="2">Day: <?php selectDay(substr($_REQUEST['StartTime'], 0, 1)); ?> Time: <?php selectTime($_REQUEST['StartTime']); ?> Room<?php selectRoom($_REQUEST['RoomID']); print $error; ?> </td> </tr> <?php } $cntResult = $db->query("select count(*)\n from {$EventScheduleTable} s,\n {$RoomsTable} r\n where s.EventID = '{$EventID}'\n and s.RoomID = r.RoomID\n order by StartTime") or die("Unable to get schedule information for event:" . sqlError()); if ($cntResult->fetchColumn() > 0) { $cntResult = $db->query("select s.StartTime,\n s.EndTime,\n r.RoomName,\n s.RoomID,\n s.SchedID\n from {$EventScheduleTable} s,\n {$RoomsTable} r\n where s.EventID = '{$EventID}'\n and s.RoomID = r.RoomID\n order by StartTime") or die("Unable to get schedule information for event:" . sqlError()); while ($cntRow = $cntResult->fetch(PDO::FETCH_ASSOC)) { // $moveSuccessful or // $_REQUEST['MoveEventID'] != $EventID // $_REQUEST['StartTime'] != $cntRow['StartTime'] // $_REQUEST['RoomID'] != $cntRow['RoomID'] if (isset($_REQUEST['MoveEventID'])) {