Untitled

<!DOCTYPE html>
<html>
<head>
<script>
function validateForm() {
    var x = document.forms["myForm"]["fname"].value;
    if (x == "") {
        alert("Name must be filled out");
        return false;
    }
 var y = document.forms["myForm"]["gender"].value;
    if (y == "") {
        alert("Email must be filled out");
        return false;
    }
 var z = document.forms["myForm"]["email"].value;
    if (z == "") {
        alert("Message must be filled out");
        return false;
    }
 var i = document.forms["myForm"]["age"].value;
    if (i == "") {
        alert("Website must be filled out");
        return false;
    }
var h = document.forms["myForm"]["lang"].value;
    if (h == "") {
        alert("Website must be filled out");
        return false;
    }
}
</script>
</head>
<body>
<form name="myForm" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>"
onsubmit="return validateForm()" method="post">
Name of Student: <input type="text" name="fname"><br><br>
<input type="radio" name="gender" value="male" checked> Male<br>
  <input type="radio" name="gender" value="female"> Female<br><br>
Address:<textarea rows="4" cols="50"></textarea><br>
Email:<input type="text" name="email"><br>
Age:<input type="number" name="age"><br>
<select>
  <option value="C++" name="lang">C++</option>
  <option value="HTML" name="lang">HTML</option>
  <option value="Java" name="lang">Java</option>
</select>
<input type="submit" value="Submit"><br>
</form>
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
$sql = 'CREATE TABLE Login (

name VARCHAR(30) NOT NULL,
gender VARCHAR(1),
address VARCHAR(100)
email VARCHAR(40),
age NUMBER(3) NOT NULL,

)'`;
if ($conn->query($sql) === TRUE) {
    echo "Table Login created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
$sql = "INSERT INTO Login (firstname, lastname, email)
VALUES ('$_POST["fname"]', '$_POST["gender"]', '$_POST["email"]','$_POST["age"]','$_POST["lang"]')";
}
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$sql = "UPDATE Login SET name='Doe' WHERE id=2";

if (mysqli_query($conn, $sql)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($conn);
}
$sql="SELECT  name FROM Login where age > 11";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
     // output data of each row
     while($row = $result->fetch_assoc()) {
         echo "<br>  Name: ". $row["name"]. "<br>";
     }
} else {
     echo "0 results";
}
mysqli_close($conn);
?>
</body>
</html>