示例#1
0
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>";
}
示例#2
0
        $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";