<?php

// section 1
// connect to the db

require_once("./inc/connect_db.php");


// section 2
// do inserts, updates and deletes
/********************************************************************
if ($submit == "Update") {

	$title = addslashes($title);
	$descrip = addslashes($descrip);
	$rprice = addslashes($rprice);
	$bicycles_id = addslashes($bicycles_id);

	if ($bicycles_id == -1) {
		$query = "INSERT INTO bicycles
		SET title = '$title',
		descrip = '$descrip',
		regular_price = '$rprice' ";
		//print("$query");
		$mysql_result = mysql_query($query,$mysql_link);
		$id = mysql_insert_id($mysql_link);
	} else {
		$query = "UPDATE bicycles
		SET title = '$title',
		descrip = '$descrip',
		regular_price = '$rprice'
		WHERE id = '$bicycles_id' ";
		//print("$query");
		$mysql_result = mysql_query($query,$mysql_link);
	}



}

if ($submit == "Delete") {

	$bicycles_id = addslashes($bicycles_id);

	$query = "DELETE FROM bicycles
	WHERE id = '$bicycles_id' ";
	//print("$query");
	$mysql_result = mysql_query($query,$mysql_link);

	$id = "";

}
********************************************************************/
// section 3


// section 4
// print the data

require_once("./header.php");

print("<form id=\"form1\" name=\"form1\" method=\"post\" action=\"index.php\">
<p>
<label for=\"id\">Select Name:</label>
<select name=\"id\" id=\"id\">
");

$query = "SELECT id, name_first, name_last
FROM invitation
ORDER BY name_first ASC";
//print("$query");
$mysql_result = mysql_query($query,$mysql_link);
while($row = mysql_fetch_row($mysql_result)) {
		$invitation_id = stripslashes($row[0]);
		$invitation_name_first = stripslashes($row[1]);
		$invitation_name_last = stripslashes($row[2]);

	if ($invitation_id == $id) {
		$selected = " selected=\"selected\"";
	} else {
		$selected = "";
	}

	print("<option value=\"$invitation_id\"$selected>$invitation_name_first $invitation_name_last</option>
	");
}



print("</select>
<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"GO\" />
<input type=\"submit\" name=\"submit\" id=\"submit2\" value=\"Add New Bicycle\" />
</p>
");

if ($submit == "Add New Bicycle") {
	$id = $bicycles_id = -1;

	/*
	$bicycles_id = -1;
	$id = $bicycles_id;

	$bicycles_id = -1;
	$id = -1;
	*/
	$bicycles_title = "";
	$bicycles_descrip = "";
	$bicycles_regular_price = 0.00;
}


if ($id) {

	$query = "SELECT id, name_first, name_last, num_guests, date_rsvp
	FROM invitation
	WHERE id = '$id' ";
	//print("$query");
	$mysql_result = mysql_query($query,$mysql_link);
	while($row = mysql_fetch_row($mysql_result)) {
		$invitation_id = stripslashes($row[0]);
		$invitation_name_first = stripslashes($row[1]);
		$invitation_name_last = stripslashes($row[2]);
		$invitation_num_guests = stripslashes($row[3]);
		$invitation_date_rsvp = stripslashes($row[4]);

	}

	print("<p>
	<label for=\"name_first\">First Name:</label>
	<br />
	<input type=\"text\" name=\"name_first\" id=\"name_first\" value=\"$invitation_name_first\" />
	</p>
	<p>
	<label for=\"name_last\">Last Name:</label>
	<br />
	<input type=\"text\" name=\"name_last\" id=\"name_last\" value=\"$invitation_name_last\" />
	</p>
	<p>
	<label for=\"date_rsvp\">Date RSVP:</label>
	<br />
	<input type=\"text\" name=\"date_rsvp\" id=\"date_rsvp\" value=\"$invitation_date_rsvp\" />
	</p>
	<p>
	<label for=\"num_guests\">Guests:</label>
	<br />
	<select name=\"num_guests\" id=\"num_guests\">
	");

	for ($x=0;$x<=5;++$x) {
		print("<option value=\"$x\"$selected>$x</option>
		");
	}

	print("</select>
	</p>


	<p>
	<input type=\"submit\" name=\"submit\" id=\"submit3\" value=\"Update\" />
	<input type=\"submit\" name=\"submit\" id=\"submit4\" value=\"Delete\" />
	<input type=\"hidden\" name=\"invitation_id\" id=\"invitation_id\" value=\"$invitation_id\" />
	</p>
	");
}


print("</form>
");

require_once("./footer.php");


?>