Untitled

<?php
	$servername = "localhost";
    $username = "root";
    $password = "";
    $db = "paptest";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $db);

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    // echo "Connected successfully";

	$nomeint = $_POST['nome'];
	$nome = explode(' ',trim($nomeint));
	$pieces = explode(' ', $nomeint);
	$sobnome = array_pop($pieces);
	$user = $nome[0] . $sobnome;
	echo $user;

	$mysqli = new mysqli($servername, $username, $password, $db);
	$result = $mysqli->query("SELECT User FROM alunos WHERE User = $user");
	if($result->num_rows == 0) {
		$sql = "INSERT INTO alunos (User) VALUES ($user)";
	} else {
		// $mysqli = new mysqli($servername, $username, $password, $db);
		// $L_user = mysql_query("SELECT MAX('ID') FROM alunos");
		// echo $L_user;

	}
	$mysqli->close();
 ?>
<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body>
	<form method="POST">
		<input type="text" placeholder="Nome" name="nome">
		<input type="Submit" value="Submit" id="Randomizer">
	</form>
	<h1></h1>
</body>
</html>