Untitled

<html>
<?php
	$errday=$errmonth=$erryear=$hourerr="";
	$day=$month=$year=$hour="";
	function test_input($data)
	{
		$data = trim($data);
		$data = stripslashes($data);
		$data = htmlspecialchars($data);
		return $data;
	}


		if ($_SERVER["REQUEST_METHOD"] == "POST")
		{
			if (empty($_POST["day"]))
			{
				$errday="Fill in the day";
			}
			else
				$day=$_POST["day"];

			if (empty($_POST["month"]))
			{
				$errmonth="fill in the month";
			}
			else
				$month=$_POST["month"];

			if (empty($_POST["year"]))
			{
				$erryear="fill in the year";
			}
			else
				$year=$_POST["year"];

			if (empty($_POST["hour"]))
			{
				$errhour="fill in the hour";
			}
			else
				$hour=$_POST["hour"];

		/* $servername="localhost";
		$username="root";
		$password="heythere";
		$dbname="tetsdb"; */

		$conn = new mysqli($servername, $username, $password, $dbname);

		if ($conn->connect_error)
		{
			die("Connection failed: " . $conn->connect_error);
        }
		$sql="SELECT * FROM TIME WHERE Day = '$day' AND Month = '$month' AND Year = '$year' AND Hour = '$hour' ";
		$result = $conn->query($sql);
		if ($result->num_rows > 0)
		{
			// output data of each row
			while($row = $result->fetch_assoc())
			{
			echo "temp: " . $row["Temp"]. " - Current: " . $row["Current"] . "&nbsp at the time- ".$row["Hour"].":".$row["Minute"].":".$row["Second"];
				echo "<br>";
			}
		}
		else
		{
			if ($day!=""&&$month!=""&&$year!="")
			{
				echo "Sorry no result of this date :( ";
			}
		}
	$conn->close();
		}
?>
    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="POST">
	DAY:<br>
	<select name="day">
	<?php
		for ($i=1;$i<=31;$i++)
		{?>
		 <option value="<?php echo $i; ?>"> <?php echo $i; ?></option>
		<?php }
	?> <?php echo $day; ?></select><br><br>
	MONTH:<br>
	<select name="month">
	<?php
		for ($i=1;$i<=12;$i++)
		{?>
		 <option value="<?php echo $i; ?>"> <?php echo $i; ?></option>
		<?php }
	?> <?php echo $month; ?> </select> <br><br>
	YEAR:<br>
	<select name="year">
	<?php
		for ($i=2016;$i<=2050;$i++)
		{?>
		 <option value="<?php echo $i; ?>"> <?php echo $i; ?></option>
		<?php }
	?><?php echo $year; ?> </select><br><br>

	HOUR:<br>
	<select name="hour">
	<?php
		for ($i=1;$i<=24;$i++)
		{?>
		 <option value="<?php echo $i; ?>"> <?php echo $i; ?></option>
		<?php }
	?><?php echo $hour; ?> </select><br><br>
	<input type="submit" value="submit">
 </form>
</html>