<h1>Mauris vitae tempor est</h1>

<p>Mauris vitae tempor est, vitae dictum massa. Praesent tristique sapien at justo lacinia mollis. Sed tristique dolor at fringilla mattis. Aenean eu enim nec risus porta euismod quis sed mi.</p>

<section>

	<h2>Foglalás</h2>

	<?php

	$dbHost = "sql310.epizy.com";
	$dbName = "epiz_23322764_foglalasok";
	$dbUser = "epiz_23322764";
	$dbPass = "qwe12ASD";

	$db = new PDO(	"mysql:host=".$dbHost.";
					dbname=".$dbName.";
					charset=utf8mb4",
					$dbUser, $dbPass
				);


	if( isset($_POST['sendEmail']) )
	{
		$error = false;

		if( strlen($_POST['nev'])<2 )
		{
			$error = "Valós név megadása kötelező!";
		}

		if( !$error )
		{
			echo '<p class="success">Az adatok sikeresen rögzítésre kerültek!</p>';

			$sql = "INSERT INTO foglalasok VALUES(NULL, '".$_POST['nev']."' , '".$_POST['fo']."' , ".$_POST['tol']." , '".$_POST['ig']."' ,  '".$_POST['email']."')";

			$db->query($sql);
		}
		else
		{
			echo '<p class="error">'.$error.'</p>';
		}
	}

	?>

	<form method="post" action="">
		<label for="inputName">Az Ön neve</label>
		<input type="text" name="nev" id="inputName" maxlength="50">
		<label for="inputEmail">E-mail címe</label>
		<input type="email" name="email" id="inputEmail" maxlength="256">
		<label for="inputFo">Hány főre</label>
		<select name="fo" id="inputFo">
			<option value="5">5</option>
			<option value="4">4</option>
			<option value="3">3</option>
			<option value="2">2</option>
			<option value="1">1</option>
		</select>
		<label for="dateTol">Ettől</label>
		<input type="date" name="tol" value="<?php echo date('Y-m-d'); ?>" id="tol">
		<label for="dateIg">Eddig</label>
		<input type="date" name="ig" value="<?php echo date('Y-m-d'); ?>" id="ig">
		<input type="submit" name="sendEmail" value="Küldés">
	</form>

</section>