function add_schedule($host, $date, $start_time, $end_time, $note) { $host = mysql_real_escape_string($host); $date = mysql_real_escape_string($date); $start_time = mysql_real_escape_string($start_time); $end_time = mysql_real_escape_string($end_time); $note = mysql_real_escape_string($note); if (($timestamp = strtotime($date)) !== false) { $day_insert = date("l", $timestamp); $insert = "INSERT INTO schedule VALUES (id, '" . $date . "', '" . $day_insert . "', '" . $start_time . "', '" . $end_time . "', '" . $host . "', '" . $note . "', 'n')"; $result = mysql_query($insert); } else { echo 'invalid timestamp!'; } if (!$result) { echo $insert . "<br>"; die('Error Inserting into Database.'); } echo "<div class=\"center\"><h1>Success!</h1>" . "<h3>New Schedule for " . $host . " on " . $date . " has been saved</h3>" . "<hr width=75%>"; display_schedule(get_schedule(mysql_insert_id())); echo "</div>"; }
$host = $_POST['host']; $date = $_POST['date']; $start_time_submit = $_POST['start_time_submit']; $end_time_submit = $_POST['end_time_submit']; $start_time = $_POST['end_time']; $end_time = $_POST['end_time']; $note = $_POST['note']; $start_time = validate_time($start_time_submit, $id, "start_time"); $end_time = validate_time($end_time_submit, $id, "end_time"); if (!$host || !$date || !$start_time || !$end_time) { echo '<div class="top-spacer_20 center error">Error - missing required value(s)</div>'; } else { $result = update_schedule($id, $host, $date, $start_time, $end_time, $note); if ($result) { echo '<div class="top-spacer_20 center"><h1>Update was successful!</h1>'; display_schedule(get_schedule($id)); echo "</div>"; } } } ?> <div class="top-spacer_20"> <a href="schedule_view_all.php">View all Schedules</a> <p> <a href="cp.php">Control Panel</a> </div> </div> </div> <!-- end of row div --> <?php } require "partials/_footer.php";