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 Home Page</title>
<link href="styles.css" rel="stylesheet" type="text/css">
</head>

<body>
<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 class='current_page_item'><a href='#'>Home</a></li>
				<li><a href='reservations.php'>Reservations</a></li>
    		</ul>
		</div>
	</div>

	<div id='tables'>
    <h1>Games</h1>
    <table>
            <tr>
                        <th>Game ID</th>
                        <th>Genre</th>
                        <th>Game Name</th>
                        <th>Game Description</th>
                        <th>Rental Cost per day</th>
            </tr>


<?php
        $count = 0;
        $file = fopen('games.csv', 'r');
			while(($text[] = fgetcsv($file)) !== FALSE){
        		$count = $count + 1;
	}

	fclose($file);

        for($row =0; $row<= 7; $row++) {
                echo"<tr>";
                for($col =0; $col <= 4; $col++) {
                        if ($col == 4) {
                                echo"<td> £".$text[$row][$col]."</td>";
                        }else{
                                echo"<td>". $text[$row][$col]."</td>";
				}
	}
        echo"</tr>";
	echo "<br>";


	}
                ?>
     </table>


    </div>


</div>

</body>
</html>


<!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>
<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>
    	<p>Please fill out the form below with all the requested details.</p>
        <?php
	$count = 0; //Count loop is asigned the number 0 in order to be initialised.
	function find_user($games, $query1) {
	$file = fopen('games.csv', 'r'); //The file games.csv is read and opened.
	    $result = false;
    while ($row = fgetcsv($f)) {
        if ($row[1] == $query1) {
            $result = $row[0];
            break;
	while(($games[] = fgetcsv($file)) !== FALSE){ //For all of the games in the file the count loop will have 1 added. (but it starts from 0) it is stored in the array $games
	$count = $count + 1; //The count loop is made equal to 1 + the previous value of count.
		}


        }
    }
	echo $result;
}


	fclose($file); //The file is closed.


$name = $gameID = $start = $reserve = ""; //All of these variables are made equal to an empty string.
$nameErr = $gameIDErr = $startrErr = $reserveErr =""; //As are all of these.

if ($_SERVER["REQUEST_METHOD"] == "POST") { //If something is missing from the field then an error message will be displayed.
  	if(empty($_POST["name"])) {
   	$nameErr = "Name is required"; //The variables xErr are made equal to error messages.
  } else {
   	$name = $_POST["name"]; //If there is nothing missing then the variable name is made equal to what the user puts in the form.
  }
	if(empty($_POST["gameID"])) {
   $gameIDErr = "gameID is required";
  } else {
   $gameID = $_POST["gameID"];
  }
	if(empty($_POST["start"])) {
   $startErr = "start is required";
  } else {
	$start = $_POST["start"];
  }
  if(empty($_POST["reserve"])) {
  $reserveErr = "reserve is required";
  }else{
	$reserve = $_POST["reserve"];
  }


	$match = "no" ; //Match needs to be asigned a value before being used. It is "no" by default.
	$number_of_records = $count - 1 ; //The number of records is made equal to my count loop - 1
	for ($i = 0;$i<$number_of_records;$i++) { // i is set as 0 and will have 1 added to it if it's value is smaller than the number of records. $i++ is the syntax to have 1 added to the variable i.
		if ($gameID == $games[$i][0]) { //If the gameID is equal to the the maximum record or bellow execute the code below.
			$match = "yes";  //The variable match is set to yes if the above condition is met.
			$gamename = $games[$i][2]; //the name of the game which is chosen is the found by going down to the right row and making 										$game name equal to the name in the column, hence the [2], which indicates the second column (game name) being in use.
			$price = $games[$i][4]; //The price is the row of the game chosen and then the 5th column, which is where the price is in the table (the column and rows first start at 0.
			$validgameID = $games[$i][0]; //The ValidgameID is the number which is in the first column of the table.(Rows and columns in PHP start at 0).


		} //End of if loop.
	} //End of for loop.
	if($match == "no"){ //If match is 0 it means that an invalid game ID was inputed.
		$gameIDErr = "Game ID does not exist"; //The appropriate message is displayed to the user.
	}

	$enddate = date('Y-m-d',strtotime($start." +{$reserve}days")); //The end date is calculated here using the function "date" and "strtotime".
	echo $enddate; //The end date is printed so that the user can see what they have selected.


	$servername = "localhost"; //My server name is called "localhost"
	$username = "vaudibert1"; //The username to my server is "vaudibert1"
	$password = "ebscs"; //The password to my database is "ebscs"
	$dbname = "vaudibert"; //The name of my database is "vaudibert"
	if ($match == "yes") { //Proving the game ID exists then the code bellow will be executed.

	$conn = new MySQLi($servername, $username, $password, $dbname); //The variable "conn" connects me to my database by inputed my login details.
	if ($conn->connect_error) { //If there is an error in one of my details then there will be a connection error.
		die("connection failed: " . $conn->connect_error);//If there is an error then it will say connection failed and the system will stop trying to connect to the server.
	}

		$CheckSQL = //This is the variable where I will see if a reservation is to be placed or not.
		//The code will select the game ID from my database called "reservations" where the start date is between the start date and end date or where the end date is between teh start date and end date. If the following is true that means that the reservations are overlaping and that somebody has already placed a reservation.
		"SELECT gameID
		FROM reservation
		WHERE (start BETWEEN '".$start."' AND '".$enddate."' OR enddate BETWEEN '".$start."' AND '".$enddate."')
		AND gameID = '".$gameID."'";

		$result = $conn->query($CheckSQL); //The results of the above are stored in the variable "results"
		echo"number of rows found ".$result->num_rows."<br>"; //The number of matches will be displayed to the user

			if ($result->num_rows>0){ //If the result is greater than one that means that 1 match or more was found.
				echo "already found, try again"; //The user is told to try another date.

	} else { //If the above is not true then the code bellow will be executed.

		//The inputs of the user (their name, gameID, start date or reservation, the number of days the game will be reserved for and the end date will be stored into my database.
		$sql = "INSERT INTO reservation (name, gameID, start, reserve, enddate)
		VALUES('".$name."','".$gameID."','".$start."','".$reserve."','".$enddate."')";
			if($conn->query($sql) === TRUE ) {
				echo "New record successfully created"; //the user is told their details were saved successfully.
			} else {
				echo "Error: ". $sql . "<br>" .$conn->error; //An error message is displayed if there is an error.
			}

	$conn->close(); //once the above has been done the connection is terminated.
		}
	}
} else {
	echo "error, gameID not real"; //If the above is not true then the gameID must be false.
}
?>
<style>
	.error {color: #FF0000;}
</style>
<?php
//The code below is the form and form validation.
//Name will be displayed above the text box which corresponds to the variable name, so that the user is aware of what they are meant to enter in each box.
//If there is an error due to an invalid input then the variable "nameErr" will be called down, which displays an error message.
//The same is applied to all of the variables which the user has to input.
?>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">

  <p>Please enter your first and second name:</p>
  <p>
  <input type="text" name="name">
    <span class="error">* <?php echo $nameErr;?></span>
    <br><br>
    Please enter the GameID:</p>
  <p>
    <input type="text" name="gameID">
    <span class="error">* <?php echo $gameIDErr;?></span>
    <br><br>
    Please enter the start date of yourreservation: </p>
  <p>
    <input type="date" name="start">
    <span class="error">* <?php echo $startErr;?></span>
    <br>
  <p>Please enter the number of days the game will be reserved:<br>
  <p>
    <input type="number" name="reserve" min="1" max="5">
    <span class="error">* <?php echo $reserveErr;?></span>
    <br><br>
  <p>
  <p>Search for a game:<p>
  <input type="text" name="query1">
    <span class="error">* <?php echo $query1;?></span>
    <br><br>
   <input type="submit" name="submit" value="Submit">
    </p>
    <br><br>
  </p>
</form>


<?php


//The below displays all of the users inputs so they can check over them.
echo "<h2>Your Input:</h2>";
echo $name;
echo"<br>";
echo $gameID;
echo"<br>";
echo $start;
echo"<br>";
echo $reserve;
echo"<br>";
echo $query1;
echo"<br>";
echo "The game name is: ". $gamename; //It displays the name of the chosen game (Which corresponds to the gameID)
$totalprice = $price * $reserve; //The total price is the price of the game * the days it is reserved for
echo "<br>";
echo "The price for ".$reserve." days is £".$totalprice."."; //The price for x days is y price.


?>


</div>

</body>
</html>