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>