Untitled

Connessione Stabilita con Successo
Notice: Undefined index: nome in C:\xampp\htdocs\cardmanager\test\prova.php on line 20

Notice: Undefined index: cognome in C:\xampp\htdocs\cardmanager\test\prova.php on line 20

Notice: Undefined index: tessera in C:\xampp\htdocs\cardmanager\test\prova.php on line 20

Notice: Undefined index: data in C:\xampp\htdocs\cardmanager\test\prova.php on line 20

Notice: Undefined index: pss in C:\xampp\htdocs\cardmanager\test\prova.php on line 20
Error: INSERT INTO dati (nome, cognome, tessera, data, password) VALUES ('', '', '', '', '')


<html>
	<head>
		<?php
			$servername = "localhost";
			$username = "cardmanager";
			$password = "manager99";
			$dbname = "cardmanager";

			//Creo la Connessione al Database
			$conn = new mysqli($servername, $username, $password, $dbname);

			//Controllo la Connessione
			if ($conn->connect_error) {
				die("Connessione Non riuscita: " . $conn->connect_error);
			}
			echo "Connessione Stabilita con Successo";

			//Inserimento Dati
			if(isset($_POST['nome']) && isset($_POST['cognome']) && isset($_POST['tessera']) && isset($_POST['data']) && isset($_POST['pss']){
				$sql = 	"INSERT INTO dati (nome, cognome, tessera, data, password) VALUES ('".$_POST['nome']."', '".$_POST['cognome']."', '".$_POST['tessera']."', '".$_POST['data']."', '".md5($_POST['pss'])."')";

				if ($conn->query($sql) === TRUE) {
					echo "New record created successfully";
				} else {
					echo "Error: " . $sql . "<br>" . $conn->error;
				}
			}
			$conn->close();
		?>
	</head>

	<body>
		<table>
			<form method="POST" action="#">
				<tr>
					<th> Nome </th>
					<th> Cognome </th>
					<th> Numero Tessera </th>
					<th> Data di Nascita </th>
					<th> Password di primo Accesso </th>
				</tr>
				<tr>
					<td><input type="text" name="nome"></td>
					<td><input type="text" name="cognome"></td>
					<td><input type="text" name="tessera"></td>
					<td><input type="date" name="data"></td>
					<td><input type="password" name="pss"></td>
				</tr>
				<tr>
					<input type="submit" >
				</tr>
			</form>
		</table>
	</body>
</html>