Untitled

<?php include ('connection.php');


$nameError = "";
$emailError = "";
$passwordError = "";
$username = "";
$email = "";
$password = "";

if (isset ( $_POST["add"] ) ) {


    function validateFormData ($formData){

        $formData = trim (stripslashes( htmlspecialchars( $formData ) ) );
        return $formData;
     }


    if( !$_POST["username"]){
       $nameError = "Please enter your username <br>";
    } else {
        $username = validateFormData ($_POST["username"]);
    }


    if( !$_POST["email"]){
        $emailError = "Please enter your email <br>";
    } else {
        $email = validateFormData ($_POST["email"]);
    }


    if( !$_POST["password"]){
        $passwordError = "Please enter your password <br>";
    } else {
        $password = validateFormData ($_POST["password"]);
    }

    if( $username && $email && $password ){

        if( mysqli_query ($conn, $query ) ){
              echo "New record in database!";
           } else {

              echo "Error: ". $query . "</br>" . mysqli_error($conn);
          }


    }


    $query = "INSERT INTO users (id, username, password, signup_date, email, biography)
            VALUES (NULL, '$username', '$password', CURRENT_TIMESTAMP, '$email', NULL)";


    if( mysqli_query ($conn, $query ) ){
              echo "New record in database!";
           } else {

              echo "Error: ". $query . "</br>" . mysqli_error($conn);
          }

}


?>

<!DOCTYPE html>
<html>
   <head>
       <title>MySQL Insert </title>
       <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.5/css/bootstrap.min.css" integrity="sha384-AysaV+vQoT3kOAXZkl02PThvDr8HYKPZhNT5h/CXfBThSRXQ6jW5DO2ekP5ViFdi" crossorigin="anonymous">
   </head>


   <body>

       <div class="container">

        <h1>MySQL Insert</h1>

           <?php


           ?>


           <p class="text-danger">* Required fields</p>

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


               <small class="text-danger">* <?php echo $nameError; ?></small>
               <input type="text" placeholder="Username" name="username"><br><br>

               <small class="text-danger">* <?php echo $emailError; ?></small>
               <input type="text" placeholder="Email" name="email"><br><br>

               <small class="text-danger">* <?php echo $passwordError; ?></small>
               <input type="password" placeholder="Password" name="password"><br><br>

               <input type="submit" name="add" value="Add Entry">

            </form>


       </div>


   </body>


</html>