Untitled

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Games Library Reservations Page</title>
<link href="styles.css" rel="stylesheet" type="text/css">
</head>

<body>
<style>
	.error {color: #FF0000;}
</style>
<div id='main'>
 	<div id='titleImage'><img title='Home' src='images/GLLogo.png' width='700' height='190' alt='Games Library Title' /></div>
  	<div id='menu-wrapper'>
		<div id='menu'>
			<ul>

				<li><a href='index.php'>Home</a></li>
                <li class='current_page_item'><a href='#'>Reservations</a></li>
    		</ul>
		</div>
	</div>

	<div>
    	<h1>Reservations</h1>
    </div>


<?php
$file = fopen("games.csv","r");

	//stores it in games
	if(fopen("games.csv","r")) {
		while(! feof($file)){
			$games[] = fgetcsv($file);
		}
		$num_rows = count($games);


	//create the variables for the input values and give it a value of nothing
	$first_name = $last_name = $gameID = $start_reservation = $num_days = "";
	//create variabls to store the message that will display when an error is met
	$first_nameErr = $last_nameErr = $gameIDErr = $start_reservationErr = $num_daysErr = "";
	//error catching- this part checks to see if a value hasd been inputed for all the variables
	if ($_SERVER["REQUEST_METHOD"]  == "POST") {
		if (empty($_POST["first_name"])) {
			//displays an error message
			$first_nameErr = "first name is required";
		} else {
			//doesn't display an errror
			$first_name= $_POST["first_name"];
		}
		if (empty($_POST["last_name"])) {
			$last_nameErr = "Surname is required";
		} else {
			$last_name = $_POST["last_name"];
		}
		if (empty($_POST["gameID"])) {
			$gameIDErr = "GameID is required";
		} else {
			$gameID = $_POST["gameID"];
		}
		if (empty($_POST["start_reservation"])) {
			$start_reservationErr = "Start reservation date is required";
		} else {
			$start_reservation = $_POST["start_reservation"];
		}
		if (empty($_POST["num_days"])) {
			$num_daysErr = "Number of days is required";
		} else {
			$num_days = $_POST["num_days"];
		}
	}
	}
	?>

<!-- form is set up in php for the users input -->
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
	<!-- first name form type is text this allows the user to enter characters an error message will be dispalyed if nothing is inputed -->
    First name: <input name="first_name" type="text" /><span class="error">* <?php echo $first_nameErr;?></span>
    <br><br>
   	<!-- surname is the same as firstname -->
    Surname: <input name="last_name" type="text" /><span class="error">* <?php echo $last_nameErr;?></span>
    <br><br>
    <!-- gameid form type is number only allowing intergers to be entered the minimum value inforces the rule that no number less than one can be inputed -->
    GameID: <input name="gameID" type="number" min="1" /><span class="error">* <?php echo $gameIDErr;?></span>
    <br><br>
    <!-- start date reservation has a type of date, thsi displays a calender for the user to chose the date of their reservations. -->
    Start date of reservation: <input name="start_reservation" type="date" /><span class="error">* <?php echo $start_reservationErr;?></span>
    <br><br>
    <!-- the length of the resrvation is again a number and has a minimum value of 1 and a maximum value of 5. This is becasue the length of reservation can only be from 1-5 days, so this stops any other inputs removing the chances of more errors. -->
    Length of reservation: <input name="num_days" type="number" min="1" max="5" /><span class="error">* <?php echo $num_daysErr;?></span>
    <br /><br />
	<!-- this creates the submmit button allowing the users to submit their inputs -->
    <input type="submit" name="submit" value="Submit">
   </form>
<?php
	$error = false;
	$row = 0;
	while($games[$row][0] != $gameID and $row <= $num_rows) {
		$row++;
	}


	// Checks if the user clicked the submit button
	if ($_POST["submit"] == "Submit") {
		// Checks if the user did not enter anything in one of the forms, and if they didn't, it will set error to true.
		if ($_POST["num_days"] == "") {
			$error = true;
		} elseif($_POST["first_name"] == "") {
			$error = true;
		} elseif($_POST["last_name"] == "") {
			$error = true;
		} elseif($_POST["gameID"] == "") {
			$error = true;
		} elseif($_POST["start_reservation"] == "") {
			$error = true;
		// If the gameid doesn't exist it will tell the user
		} elseif($row>$num_rows) {
			$error = true;
			echo "Please enter a valid game ID.";
		} else {


			echo "<h2>Your Inputs:</h2>";
			//prints values entered into the variables
			echo $first_name;
			echo "<br />";
			echo $last_name;
			echo "<br />";
			echo $gameID;
			echo "<br />";
			echo $start_reservation;
			echo "<br />";
			echo $num_days;
			echo "<br />";
			$end_date = date('Y-m-d', strtotime($start_reservation. " + $num_days days"));
			echo "End date: ".$end_date;
			echo"<br>";
			echo "Game Name: ".$games[$row][2];
			$dayprice = $games[$row][4];
			$totalprice = $dayprice * $num_days;
			echo "<br>";
			echo "The price for ".$num_days." days is £".$totalprice.".";
				}
	}
?>
<?php
	//connect to mysql database
	$servername = "localhost";
	$username = "yneocleous";
	$password = "ebscs";
	$dbname = "yneocleous";
	//create connection
	$conn = new MySQLi($servername, $username, $password, $dbname);
	//check connection
	if ($conn->connect_error) {//if error stop loading html and display error
		die("Connection failed: " . $conn->connect_error);
	}
	//insert a form data as a new record
	$sql = "INSERT INTO Reservations (first_name, last_name, game_ID, start_reservation, num_days, end_date)
			VALUES ('".$first_name."', '".$last_name."', '".$gameID."', '".$start_reservation."', '".$num_days."', '".$end_date."')";

	if($conn->query($sql) === TRUE ) {
		echo "<br>New record successfully created";
	} else {
		echo "Error: ". $sql . "<br>" .$conn->error;
	}

	$conn->close();
?>
</div>
</body>
</html>