Untitled

<html>
	<head>
		<title>Registration</title>
		<meta charset="UTF-8">
		<link rel="stylesheet" href="style.css?4">
	</head>
	<body>
	<?php
		if(isset($_GET['verify'])) {
			$conn = new mysqli('127.0.0.1', 'root', 'wxsZQdc2NCV2qErJEuCajsYD', 'auth');
			if($conn->connect_error) ! die(json_encode(array('msg' => $conn->connect_error)));
			$res = $conn->query("SELECT * FROM users WHERE verify_key='".$conn->real_escape_string($_GET['verify'])."'");
			if($res->num_rows != 0) {
				$row = $res->fetch_assoc();
				if($row['verified'] == 0) {
					$conn->query("UPDATE users SET verified=1 WHERE username='".$row['username']."'");
					echo '<div class="alert alert-success" style="display: block">Sikeres megerősítés!</div>';
				} else {
					echo '<div class="alert alert-danger" style="display: block">Már egyszer meg lett erősítve!</div>';
				}
			}
		} else {
	?>
		<div class="login-page" method="POST">
			<img src="icon.png" alt="Icon" class="icon-img">
			<div class="form">
				<form class="register-form" onsubmit="return false;">
					<div class="alert alert-danger"></div>
					<div class="alert alert-success"></div>
					<input type="text" id="username" name="username" placeholder="Username">
					<input type="email" id="email" name="email" placeholder="E-mail">
					<input type="password" id="password" name="password" placeholder="Password">
					<input type="password" id="password2" name="password2" placeholder="Password">
					<div class="g-recaptcha" data-sitekey="6LfLF54UAAAAANS8J1Jkl_8FPcCOCnX8vBTR5wUj"></div>
					<p class="icon-img">A regisztráció gombra kattintás után kérlek várj addig amíg ki nem írja, hogy sikeres regisztráció!<br>Lehetséges, hogy spam formájában kapod meg az emailt.</p>
					<br>
					<button type="submit" name="register_button">Register</button>
				</form>
			</div>
		</div>
		<script src='https://code.jquery.com/jquery-3.2.1.min.js'></script>
		<script src='https://www.google.com/recaptcha/api.js'></script>
		<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.0/jquery.min.js'></script>

		<script>
			$('.register-form').on('submit', function() {
				$.post('/php/auth.php', {action: 'register', recaptcha: grecaptcha.getResponse(), username: $('#username').val(), email: $('#email').val(), password: $('#password').val(), password2: $('#password2').val()}, function(data, status) {
					err = $('.alert-danger');
					succ = $('.alert-success');
					err.hide();
					succ.hide();
					console.log(data);
					if(status == 'success') {
						data = JSON.parse(data);
						if(data.success) {
							succ.html(data.msg);
							succ.show();
						} else {
							err.html(data.msg);
							err.show();
						}
					} else {
						err.html('Hiba történt! HTTP' + status);
						err.show();
					}
					grecaptcha.reset();
				});
			});
		</script>
		<?php }?>
	</body>
</html>