Untitled

<?php
          // define variables and set to empty values
     $nameErr = $emailErr = $userErr = $passwordErr1 = $passwordErr2 ="";
  $name = $email = $user =$password1 = $password2="";
       $servername = "localhost";
   $username = "root";
      $password = "";
    $database = "Reg_from";

      if (isset($_POST['submit'])) {
      if (empty($_POST["name"])) {
      $nameErr = "Name is required";
       } else {
   $name = test_input($_POST["name"]);
     // check if name only contains letters and whitespace
     if (!preg_match("/^[a-zA-Z ]*$/",$name)) {
       $nameErr = "Only letters and white space allowed";
   }
  }

       if (empty($_POST["email"])) {
      $emailErr = "Email is required";
      } else {
       $email = test_input($_POST["email"]);
           // check if e-mail address is well-formed
          if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
           $emailErr = "Invalid email format";
      }
      }

       if (empty($_POST["userid"])) {
           $userErr = "User-name is required";
      } else {
           $user = test_input($_POST["userid"]);
      }

         if (empty($_POST["psw1"])) {
             $passwordErr1 = "Password is required";
    } else {
       $password1 = test_input($_POST["psw1"]);
      }

    if (empty($_POST["psw2"])) {
      $passwordErr2 = "Password is required";
      } else {
        $password2 = test_input($_POST["psw2"]);
          }

         // Create connection
          $conn = new mysqli($servername, $username, $password, $database);
         // Check connection
          if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
          }
         echo "Connected successfully";

         // Create database
         $sql = "CREATE DATABASE Reg_from";
          if ($conn->query($sql) === TRUE) {
            echo "Database created successfully";
           } else {
             echo "Error creating database: " . $conn->error;
        }

         // sql to create table
         $sql = "CREATE TABLE users (
         id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
          name VARCHAR(30) NOT NULL,
          email VARCHAR(30) NOT NULL,
          userid VARCHAR(50),
         psw1 VARCHAR(50),
       psw2 VARCHAR(50),
         reg_date TIMESTAMP
           )";

         if(isset($_POST['Register'])){
         $sql = "INSERT INTO users (id,name, email, userid, psw1, psw2)
        VALUES
        ('".$_POST["id"]."','".$_POST["name"]."','".$_POST["email"]."')";

   }

}

 function test_input($data) {
 $data = trim($data);
   $data = stripslashes($data);
    $data = htmlspecialchars($data);
   return $data;
      }
   ?>

     <!DOCTYPE HTML>
     <html>
      <head>
   <style>
       .error {
       color: #FF0000;
      }
      .field {
       color: #e60000;
  }
   .file {
      background-color: #b3ffff;
      padding-left: 400px;
      height:430px;
       margin-left:-10px;
      margin-right:-10px;
      margin-top:-20px;
      margin-bottom:-20px;
   }
   </style>
  </head>
  <body>
      <div class="file">
      <h2>Registration Form</h2>
     <h4 class="field"> * All fields are mandatory </h4>
      <form method="post" action="<?php echo
   htmlspecialchars($_SERVER["PHP_SELF"]);?>">
       Name: <br>
        <input type="text" name="name" style="margin-left:50px">
       <span class="error"> <?php echo $nameErr;?></span>
         <br> <br>
         E-mail: <br>
            <input type="text" name="email" style="margin-left:50px">
         <span class="error"> <?php echo $emailErr;?></span>
         <br> <br>
            User-name:<br>
          <input type="text" name="userid" style="margin-left:50px">
      <span class="error"> <?php echo $userErr;?></span>
        <br> <br>
             Password: <br>
        <input type="password" name="psw1" style="margin-left:50px">
       <span class="error"> <?php echo $passwordErr1;?></span>
       <br><br>
       Confirm-password: <br>
         <input type="password" name="psw2" style="margin-left:50px">
         <span class="error"> <?php echo $passwordErr2;?></span>
          <br><br>
          <input type="submit" name="submit" value="Register">
     </form>
     </div>
     </body>
       </html>