All pastes #942927 Raw Edit

Anonymous

public text v1 · immutable
·published 2008-03-14 20:57 UTC
rendered paste body
<?php

$err = '';

if($_POST['submit'])

{

	$ms = mysql_pconnect("localhost", "merter_calendar", "calendar");

	if ( !$ms )

		echo "Error connecting to database.\n";

	mysql_select_db ("merter_calendar");


	$title = mysql_real_escape_string($_POST['title']);
	$description = mysql_real_escape_string($_POST['description']);
	$timestamp = mysql_real_escape_string($_POST['YEAR'])."-".mysql_real_escape_string($_POST['MONTH'])."-".mysql_real_escape_string($_POST['DAY'])." ".mysql_real_escape_string($_POST['HOURS']).":".mysql_real_escape_string($_POST['MINUTES']);
	$startunix = strtotime($timestamp);
	$endunix = $startunix + ($_POST['HOURSADDED'] * 3600) + ($_POST['MINUTESADDED'] * 60);
	$endtime = date("Y-m-d H:i:s",$endunix);
	
	if ( !$title || !$description || !$timestamp || !$_POST['HOURS'] || !$_POST['MINUTES'])

		$err = "Please fill in all of the required fields.";
		
	else if (!is_numeric($_POST['YEAR']))
	
		$err = "Invalid Year Entered";
	
	else if (checkdate($_POST['MONTH'], $_POST['DAY'], $_POST['YEAR']) == FALSE)
	
		$err = "Invalid Date Entered";
		
	else if ($_POST['HOURS'] < 0 || $_POST['HOURS'] > 23 || $_POST['MINUTES'] < 0 || $_POST['MINUTES'] > 59  || !is_numeric($_POST['HOURS']) || !is_numeric($_POST['MINUTES']))
	
		$err = "Invalid Time Entered";
		
	else {
	
	$sql = mysql_query("INSERT INTO events (title, description, timestamp, endtime) VALUES ('$title', '$description', '$timestamp', '$endtime')");

	$err = '<p class="bodytext"> Your event has been added to the calendar. </p>';
	
	}

}

?>

<div>

<?php

if($err)

	echo $err;

?>

<form action="" method="post">

<span>Title</span><br /><input type="text" maxlength="30" name="title" size="31" /><br /><br />

<span>Date</span><br />

<select NAME="DAY">
	<option VALUE="01">01</option>
    <option VALUE="02">02</option>
    <option VALUE="03">03</option>
    <option VALUE="04">04</option>
    <option VALUE="05">05</option>
    <option VALUE="06">06</option>
    <option VALUE="07">07</option>
    <option VALUE="08">08</option>
    <option VALUE="09">09</option>
    <option VALUE="10">10</option>
    <option VALUE="11">11</option>
    <option VALUE="12">12</option>
    <option VALUE="13">13</option>
    <option VALUE="14">14</option>
    <option VALUE="15">15</option>
    <option VALUE="16">16</option>
    <option VALUE="17">17</option>
    <option VALUE="18">18</option>
    <option VALUE="19">19</option>
    <option VALUE="20">20</option>
    <option VALUE="21">21</option>
    <option VALUE="22">22</option>
    <option VALUE="23">23</option>
    <option VALUE="24">24</option>
    <option VALUE="25">25</option>
    <option VALUE="26">26</option>
    <option VALUE="27">27</option>
    <option VALUE="28">28</option>
    <option VALUE="29">29</option>
    <option VALUE="30">30</option>
    <option VALUE="31">31</option>
</select>

<select name="MONTH">
		<option value="01">Jan</option>
		<option value="02">Feb</option>
		<option value="03">Mar</option>
		<option value="04">Apr</option>
		<option value="05">May</option>
		<option value="06">Jun</option>
		<option value="07">Jul</option>
		<option value="08">Aug</option>
		<option value="09">Sep</option>
		<option value="10">Oct</option>
		<option value="11">Nov</option>
		<option value="12">Dec</option>
	</select>
    
<input type="text" maxlength="4" name="YEAR" size="2" /> <br /><br />

<span class="bodytext">Time (24h)</span><br /><input type="text" maxlength="15" name="HOURS" size="2" /> : <input type="text" maxlength="15" name="MINUTES" size="2" /><br /><br />

<span>Duration</span><br />
<select name="HOURSADDED">
	<option value="00">0</option>
	<option value="01">1</option>
    <option value="02">2</option>
    <option value="03">3</option>
</select>&nbsp;&nbsp;&nbsp;
<select name="MINUTESADDED">
	<option value="00">00</option>
	<option value="15">15</option>
    <option value="30">30</option>
    <option value="40">45</option>
</select><br />
Hours&nbsp;&nbsp;&nbsp; Minutes<br /><br />


<span class="bodytext">Event Description</span></span><br /><textarea name="description" rows="10" cols="70"></textarea><br /><br />

<input type="submit" value="Send" name="submit" />

</form>
</div>