Untitled

<form method='post' action='re.php'>

<form method='post' action='<?php echo $_SERVER["PHP_SELF"];?>'>

<?php

$hostname = 'localhost';
$username = 'Ciara';
$password = 'mypass';
$database = 'users';

$conn = mysqli_connect($hostname,$username, $password, $database);
if (!$conn) {
    die ("Databas connect failed: " . mysqli_connect_error());
} else {
    echo "Connected successfully. <br>";
}

echo <<<_END
<html>
    <head>
        <title>Register</title>
    </head>
    <body><center>
        <form method='post' action='<?php echo $_SERVER["PHP_SELF"];?>'>
        Firstname: <input type='text' name='firstname'><br>
        Lastname: <input type='text' name='lastname'><br>
        E-mail: <input type='text' name='email'><br>
        Gender: <input type='radio' value='female' name='gender'>Female
                <input type='radio' value='male' name='gender'>Male<br>
        Username: <input type='text' name='username'><br>
        Password: <input type='text' name='password'><br>
        <input type='submit' value='Submit Form'>
        </form></center>

_END;

if (isset($_POST['firstname']) &&
    isset($_POST['lastname']) &&
    isset($_POST['email']) &&
    isset($_POST['gender']) &&
    isset($_POST['username']) &&
    isset($_POST['password'])) {

    $firstname = get($conn, 'firstname');
    $lastname = get($conn, 'lastname');
    $email = get($conn, 'email');
    $gender = get($conn, 'gender');
    $username = get($conn, 'username');
    $password = get($conn, 'password');

    $query = "insert into useracc values" . "(null, '$firstname','$lastname','$email','$gender','$username','$password')";

    if (mysqli_query($conn, $query)) {
        echo "You have successfully registered! <br>";
    } else {
        echo "Failed to register." . mysqli_error($conn);
    }
}

mysqli_close($conn);
echo "</body></html>";

function get($conn, $var) {
     return mysqli_real_escape_string($conn, $_POST[$var]);
}
?>