reg form code

<!DOCTYPE html>
<html>
<head>
    <title>user registration form</title>
        <style>
            .signup {
                border:1px solid #999999;
                font: normal 14px helvetica;
                color: #444444;
            }
        </style>
        <script>

        </script>
</head>

<body>

<!-- PHP code to obtain the form submitted by the user -->
<?php

// declare variables and set to empty values
$forename = $surname = $username = $password = $age = $email = "";
$gender = "";

// declare variables to hold error messages for each field
$forenameError = $surnameError = $usernameError = $passwordError = $ageError = $emailError = "";
$genderError = "";
$foundErrors = false;


// if the form has been submitted AND the method is POST
if($_SERVER["REQUEST_METHOD"] == "POST") {

    if(empty($_POST["username"])){
        $usernameError = "Username is required";
        $foundErrors = true;
    }
    else {
        $username = clearUserInputs($_POST["username"]);
    }

    if(empty($_POST["password"])){
        $passwordError = "Password is required";
        $foundErrors = true;
    }
    else {
        $password = clearUserInputs($_POST["password"]);
    }

    if(empty($_POST["forename"])){
        $forenameError = "Forename is required";
        $foundErrors = true;
    }
    else {

    if(!preg_match("/^[a-zA-Z]*$/",$_POST["forename"])){
        $forenameError = "Only letters and white space allowed";
        $foundErrors = true;
    }
    else {
        $forename = clearUserInputs($_POST["forename"]);
        }
    }

    if(empty($_POST["surname"])){
        $surnameError = "Surname is required";
        $foundErrors = true;
    }
    else {

    if(!preg_match("/^[a-zA-Z]*$/",$_POST["surname"])){
        $surnameError = "Only letters and white space allowed";
        $foundErrors = true;
    }
    else {
        $surname = clearUserInputs($_POST["surname"]);
        }
    }

    if(empty($_POST["age"])){
        $ageError = "Age is required";
        $foundErrors = true;
    }
    else{

    if(!preg_match("/^[0-9]*$/",$_POST["age"])){
        $ageError = "Only numbers allowed";
        $foundErrors = true;
    }

    else {
        $age = clearUserInputs($_POST["age"]);
        }
    }

    if(empty($_POST["gender"])){
        $genderError = "Gender is required";
        $foundErrors = true;
    }
    else {
        $gender = clearUserInputs($_POST["gender"]);
    }

    if(empty($_POST["email"])){
        $emailError = "Email is required";
        $foundErrors = true;
    }
    else {
    // validate email address
    if(filter_var($_POST["email"], FILTER_VALIDATE_EMAIL)) {
        $email = clearUserInputs($_POST["email"]);
    }
    else {
        $emailError = "Invalid email address";
        $foundErrors = true;
        }
    }

 }


        if($foundErrors == false) {
        $servername = "localhost";
        $dbusername = "root";
        $dbpassword = "root";
        $databasename = "cmetmarketplace";

        // PHP code to save form data to the MySQL database
        try {
            $conn = new PDO("mysql:host=$servername;dbname=$databasename",
                            $dbusername, $dbpassword);
            // set the PDO error mode to exception
            $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                echo "Connected successfully <br>";
            }
            catch(PDOException $e)
            {
            echo "Connection failed: " . $e->getMessage();
            }

        }

    // prepare SQL statements to insert data
    $sql = "INSERT INTO users
        (username,
        password,
        forename,
        surname,
        age,
        gender,
        email)
        value(?, ?, ?, ?, ?, ?, ?)";

    $stmt = $conn->prepare($sql);
    $stmt->execute([$username, $password, $forename, $surname,
    $age, $gender, $email]);

    echo "New user added to the database : ";


    // function to clear userinputs
    function clearUserInputs($data){
        $data = trim($data);
        $data = stripslashes($data);
        $data = htmlspecialchars($data);
        return $data;

}


?>
<!-- End of php code -->


    <h2> Registration Form </h2>
    <hr>
    <table border="0" cellpadding="2" cellspacing="5" bgcolor="#eeeeee">
        <form method="POST" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" autocomplete="off">
            <tr>
                <td>Username</td>
                <td><input type="text" maxlength="16" name="username" value="<?php echo $username; ?>" /></td>
                <td><span class="error"> * <?php echo $usernameError; ?> </span></td>
            </tr>
            <tr>
                <td>Password</td>
                <td><input type="password" maxlength="12" name="password" value="<?php echo $password; ?>" /></td>
                <td><span class="error"> * <?php echo $passwordError; ?> </span></td>
            </tr>
            <tr>
                <td>Forename</td>
                <td><input type="text" maxlength="32" name="forename" value="<?php echo $forename; ?>" /></td>
                <td><span class="error"> * <?php echo $forenameError; ?> </span></td>
            </tr>
            <tr>
                <td>Surname</td>
                <td><input type="text" maxlength="32" name="surname" value="<?php echo $surname; ?>" /></td>
                <td><span class="error"> * <?php echo $surnameError; ?> </span></td>
            </tr>
            <tr>
                <td>Age</td>
                <td><input type="text" maxlength="32" name="age" value="<?php echo $age; ?>" /></td>
                <td><span class="error"> * <?php echo $ageError; ?> </span></td>
            </tr>
            <tr>
                <td>Gender</td>
                <td>
                    <input type="radio" name="gender" value="male"
                    <?php if(isset($gender) && $gender=="male") echo "checked"; ?>>Male

                    <input type="radio" name="gender" value="female"
                    <?php if(isset($gender) && $gender=="female") echo "checked"; ?>>Female
                </td>
                <td><span class="error"> * <?php echo $genderError; ?> </span></td>
            </tr>
            <tr>
                <td>Email</td>
                <td><input type="text" maxlength="64" name="email" value="<?php echo $email; ?>" /></td>
                <td><span class="error"> * <?php echo $emailError; ?> </span></td>
            </tr>
            <tr>
                <td colspan="2" align="center">
                    <input type="submit" value="Register" />
                </td>
            </tr>
        </form>
    </table>


    <hr>
    <h2> Your submitted information: </h2>
    <hr>

    <table border="0" cellpadding="2" cellspacing="5" bgcolor="#f1f1f1">
        <tr>
            <td> Forename entered: </td>
            <td> <?php echo $forename ?> </td>
        </tr>
        <tr>
            <td> Surname entered: </td>
            <td> <?php echo $surname ?> </td>
        </tr>
        <tr>
            <td> Username entered: </td>
            <td> <?php echo $username ?> </td>
        </tr>
        <tr>
            <td> Age entered: </td>
            <td> <?php echo $age ?> </td>
        </tr>
        <tr>
            <td> Gender selected: </td>
            <td> <?php echo $gender ?> </td>
        </tr>
        <tr>
            <td> Email entered: </td>
            <td> <?php echo $email ?> </td>
        </tr>
    </table>


</body>
</html>