Registration Form HTML CSS AND PHP

  

  
    
    
  
  
     

      
Registration Form
      

        

          Name
          
          Last Name
          
          User Name
          
          Password
          
          Confirm Password
          
          Date of Birth
          
        
        

          Mobile Number
          
          Address
          
          Pin Code:


Select State:

  Select State
  State 1
  State 2
  State 3
  


Select District:

  Select District
  


Block:

  Select Block
  


Add User Role:

  
  Main Admin


  
  State Admin


  
  District Admin


  
  Block Admin

Code copied to clipboard!

  ' . mysqli_error($conn);
    }
    
    // Close the database connection
    mysqli_close($conn);
  }
}

?>

Code copied to clipboard!

  CREATE TABLE users (
  id INT(11) NOT NULL AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  last_name VARCHAR(50) NOT NULL,
  username VARCHAR(50) NOT NULL,
  password VARCHAR(255) NOT NULL,
  dob DATE NOT NULL,
  mobile_number VARCHAR(20) NOT NULL,
  address VARCHAR(255) NOT NULL,
  pincode VARCHAR(10) NOT NULL,
  state VARCHAR(50) NOT NULL,
  district VARCHAR(50) NOT NULL,
  block VARCHAR(50) NOT NULL,
  user_role VARCHAR(50) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
);

Code copied to clipboard!