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"]["email"].value;
    if (y == "") {
        alert("Email must be filled out");
        return false;
    }
 var z = document.forms["myForm"]["msg"].value;
    if (z == "") {
        alert("Message must be filled out");
        return false;
    }
 var i = document.forms["myForm"]["website"].value;
    if (i == "") {
        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: <input type="text" name="fname">
Email:<input type="text" name="email">
Message:<input type="text" name="msg">
Website:<input type="text" name="website">
<input type="submit" value="Submit">
</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,
email VARCHAR(30) NOT NULL,
website VARCHAR(40),
message VARCHAR(100)
)";
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["email"]', '$_POST["msg"]','$_POST["website"]')";
}
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 name like 's%'";
$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>