Signup form using PHP and MySQL Database

Last Updated : 09 Sep, 2020

The task is to create and design a sign-up form in which if the user enters details, the HTML form data are inserted into our MySQL server database.

Approach:

First task is that we have to create our MySQL server Database and a Table according to our requirements.
We connect our MySQL server Database using PHP mysqli_connect() function which takes four arguments, i.e. our "servername", "username", "password" and "database".

Note: No CSS code is used here as we are using Bootstrap in the following PHP code. You can apply CSS and style in your web page as per your own application requirement.

PHP code to create Database connection: First and the most basic step is to create a Database connection. The PHP file name used here is "dbconnect.php" and the database name used is "geeksforgeeks".

php


 
    $servername = "localhost"; 
    $username = "root"; 
    $password = "";
 
    $database = "geeksforgeeks";
 
     // Create a connection 
     $conn = mysqli_connect($servername, 
         $username, $password, $database);
 
    // Code written below is a step taken
    // to check that our Database is 
    // connected properly or not. If our 
    // Database is properly connected we
    // can remove this part from the code 
    // or we can simply make it a comment 
    // for future reference.
 
    if($conn) {
        echo "success"; 
    } 
    else {
        die("Error". mysqli_connect_error()); 
    } 
?>

"users" table is created using MySQL phpMyAdmin tool as shown below.

PHP code to design sign-up form: Now when we have successfully connected to our Database, it is time to create the Signup form for the users. The following PHP code demonstrates the sign-up form. The MySql database table name used is "users".

php


  
$showAlert = false; 
$showError = false; 
$exists=false;
  
if($_SERVER["REQUEST_METHOD"] == "POST") {
    
    // Include file which makes the
    // Database Connection.
    include 'dbconnect.php';   
  
    $username = $_POST["username"]; 
    $password = $_POST["password"]; 
    $cpassword = $_POST["cpassword"];
          
  
    $sql = "Select * from users where username='$username'";
  
    $result = mysqli_query($conn, $sql);
  
    $num = mysqli_num_rows($result); 
  
    // This sql query is use to check if
    // the username is already present 
    // or not in our Database
    if($num == 0) {
        if(($password == $cpassword) && $exists==false) {
  
            $hash = password_hash($password, 
                                PASSWORD_DEFAULT);
              
            // Password Hashing is used here. 
            $sql = "INSERT INTO `users` ( `username`, 
                `password`, `date`) VALUES ('$username', 
                '$hash', current_timestamp())";
  
            $result = mysqli_query($conn, $sql);
  
            if ($result) {
                $showAlert = true; 
            }
        } 
        else { 
            $showError = "Passwords do not match"; 
        }      
    }// end if 
  
   if($num>0) 
   {
      $exists="Username not available"; 
   } 
  
}//end if   
  
?>
  

  



  
     
     
    
        "width=device-width, initial-scale=1, 
        shrink-to-fit=no">
  
     
    
"https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"
        integrity=
"sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk"
        crossorigin="anonymous">  

  

  

  
    if($showAlert) {
  
        echo '             alert-dismissible fade show" role="alert">
  
            Success! Your account is 
            now created and you can login. 
             
        
 '; 
    }
  
    if($showError) {
  
        echo '             alert-dismissible fade show" role="alert"> 
        Error! '. $showError.'
  
        
     
 '; 
   }
      
    if($exists) {
        echo '             alert-dismissible fade show" role="alert">
  
        Error! '. $exists.'
        
       
 '; 
     }
 
?>
  

  
    Signup Here
 
    
  
         
            Username 
        
            name="username" aria-describedby="emailHelp">    
        
  
         
            Password 
            
            id="password" name="password"> 
        
  
         
            Confirm Password 
            
                id="cpassword" name="cpassword">
  
            
            Make sure to type the same password