CODE EXAMPLE FOR PYTHON

lll

<?php

include_once("__DIR__ . '/../connection/conn.php");

if(isset($_POST['submit'])){

    $username = mysqli_real_escape_string($conn, $_POST['username']);
    $email = mysqli_real_escape_string($conn, $_POST['email']);
    $pass = mysqli_real_escape_string($conn, md5($_POST['password']));
    $cpass = mysqli_real_escape_string($conn, md5($_POST['cpassword']));
    $role = 'user';
    $verification_status = '0';
    $otp = mt_rand(1111,9999);    //create 4 digits otp
    $activation_code = rand(time(),10000000);  //create a user unique id
 
    $select_users = mysqli_query($conn, "SELECT * FROM `userssystem1` WHERE email = '$email' AND password = '$pass'") or die('query failed');
 
    if(mysqli_num_rows($select_users) > 0){
       $message[] = 'user already exist!';
    }else{
       if($pass != $cpass){
          $message[] = 'confirm password not matched!';
       }else{
          mysqli_query($conn, "INSERT INTO `userssystem1`(username, email, password, role, otp, activation_code, verification_status) VALUES('$username', '$email' , '$cpass' , '$role', '$otp', '$activation_code' , '$verification_status')") or die('query failed to insert');
          $message[] = 'registered successfully!';
          header('location:verify.php?code='.$activation_code);
       }
    }
 
 }

?>