Untitled

<html>
<head>
	<h1>User Index</h1>
	<link rel="stylesheet" type="text/css" href="style.css">
		Index Form
		<br></br>
	<form action="index.php" method="post">
	<label id="first"> First name:</label><br/>
	<input type="text" placeholder= "insert firstname here" name="username"><br/>

	<label id="first">Last Name</label><br/>
	<input type="first" placeholder= "insert lastname here" name="password"><br/>

	<label id="first">Email:</label><br/>
	<input type="text" placeholder= "insert email here" name="email"><br/>

   <button type="submit" name="save">save</button><br/>
</head>
<body>


<!--PHP scriptet sender username og password til databasen for at logge ind og modtage information-->
<?php


ini_set('display_errors', 1);

$servername = "localhost";
$username = "datauser";
$password = "raspberry";
$dbname = "data1";

$conn = new mysqli($servername, $username, $password, $dbname);
 if ($conn->connect_error) {
	 die("connection failed: " . $conn->connect_error);

}

 $sql = "SELECT id, firstname, lastname, email FROM myData";
 $result = $conn->query($sql);


 if ($result->num_rows > 0) {
	 while($row = $result->fetch_assoc()) {
		 echo "id: " . $row["id"]. " - Name: " . $row["firstname"]." " . $row["lastname"]. " - " . $row["email"]." " . "<br>";
	}
 } else {
	 echo "0 results";
}
 $conn->close();
?>
<!--Dette er formlen der skal bruges til at kalde på databasen og send info til den-->
</body>
<footer>
	<?php
	$conn = new mysqli($servername, $username, $password, $dbname);
	    if ($conn->connect_error) {
			die("connection failed: " . $conn->connect_error);
		}


	if(isset($_POST['save']))
	{
		$sql = "INSERT INTO myData (firstname, lastname, email)
		VALUES ('".$_POST["username"]. "','".$_POST["password"]."','".$_POST["email"]."')";

		$result = mysqli_query($conn,$sql);

	}
	?>
  <br/>
  <br/>
  <br/>
  <a href="https://www.staggeringbeauty.com">Don't click</a>
  </form>

	</table>
</footer>
</html>