<!DOCTYPE html>
<html>
<head>
	<?php
	$con=mysqli_connect("localhost", "root", "", "ayyerr");
	if(!$con){
		die("Connection failed: ".mysqli_connect_error());};
	?>
	<meta charset="utf-8">
	<title></title>
	<link rel="stylesheet" href="style.css">
	<script type="text/javascript">
		window.onload = function(){
			document.getElementsByTagName("html")[0].classList.add('load');
		};
	    if (window.history.replaceState) {
	    	window.history.replaceState(null,null,window.location.href);
    	};
	</script>
</head>
<body>
	<div class="main">
		<div class="phpbox">
			<div class="phpbox2">
			<p id="phptxt">Have a good suggestion for a video?<br><span id="label-sub">Fill out this form to let me know!</span></p>
			</div>
			<div class="phpbox3">
				<form action="" id="form" method="post">
					<p id="label">Your <img src="images/yt.png" id="logo"> Youtube nickname:</p>
					<input id="form1" type="text" name="nickname"><br>
					<p id="label">Your idea: <span id="label-sub">(max. 500 characters)</span></p>
					<textarea id="form2" name="idea-content" maxlength="500"></textarea><br>
					<p id="label">Idea type:</p>
					<select id="form3" name="idea-id">
						<option value="1">Small Build</option>
						<option value="2">Big Build</option>
						<option value="3">Building Tutorial</option>
						<option value="4">Redstone Tutorial</option>
						<option value="5">Geometry Dash video</option>
						<option value="6">Other</option>
					</select><br>
					<button id="submit" type="submit">Send!</button>
				</form>
			</div>
		</div>
		<div class="phpcount">
			<?php
				$sql1=mysqli_query($con, "SELECT COUNT(id) FROM ideas");
				$row=mysqli_fetch_array($sql1);
				printf("<p>There are currently $row[0] requests!</p>");
			?>
		</div>
		<button onclick="location.href='index.html'" id="phpback">Back</button>
	</div>
	<?php
		$nickname=$_POST["nickname"];
		$idea=$_POST["idea-content"];
		$idea_id=$_POST["idea-id"];
		$sql=mysqli_query($con, "INSERT INTO ideas (nickname, idea_name, idea_id) VALUES ('$nickname', '$idea', '$idea_id');");
		mysqli_close($con);
	?>
</body>
</html>
