Generate Unique Username in PHP

Generate Unique Username in PHP and Jquery AJAX

Hi Friends today we are going to learn how to generate unique or random username using php and jquery ajax..

just follow the below step to generate unique username in php..

Generate Unique Username in PHP

=>Database Structure:

Database Name: codenair

Table Name: user

-- Table structure for table `user`

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY(id)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

Files Structure:
Create 3 files and copy paste the below codes..
1. index.html
2. script.js
3. signup.php
1. index.html

<html>
<head>
<title>AJAX Random UserName Generator using PHP MySQL</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script type="text/javascript" src="script.js"></script>
</head>
<h2>AJAX Random UserName Generator</h2>
<form method="POST" action="">
 <table>
    <tr>
   <td>Email</td>
   <td><input type="text" id="email"/></td>
 </tr>
 <tr>
   <td>PassWord</td>
   <td><input type="text" id="password"/></td>
 </tr>
 <tr>
    <td></td>
    <td><input type="button" id="submit" value="Sign Up"/><br/> </td>
 </tr>
 </table> 
</form>
<div id="success"></div>
</html>

2. script.js

$(document).ready(function(){
 $("#submit").click(function(){
  var email=$("#email").val();
  var password=$("#password").val();
  if(email==""||password==""){
   $("#success").html('<font style=color:red>Your Email or Password is Empty');
   return false;
  }else{
   $.ajax({
    url:"signup.php",
    type:"POST",
    data:{email:email,password:password},
    success:function(data){
     $("#success").html(data);
    }
   });
   return false;
  }
 });
});

3. signup.php

<?php
  $conn=new mysqli('localhost','root','','codenair');
  if(!empty($_POST['email'])&&!empty($_POST['password'])){
  $password=$_POST['password'];
  $email=$_POST['email'];
  //Checking for Email Availablity
  if(!empty($email)){
   $result=mysqli_query($conn,"SELECT*FROM user WHERE email='$email'");
   $count= $result->num_rows;
   if($count==0){
    $ok='';
   }else{
    echo 'Email Already Exist';
   }
  }
 
  if(isset($ok)){
  //Generating Random Username
  function generateRandomUsername($length = 8) {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ@#$%^&*';
    $charactersLength = strlen($characters);
    $randomString = '';
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}
$username=strtoupper(generateRandomUsername());
//End Random Username
 $result=mysqli_query($conn,"INSERT INTO user(username,password,email)VALUES('$username','$password','$email')");
 if($result){
  echo "Registration Success.Unique Username is:<font color=green><b>$username</b></font>";
 }else{
  echo "Sorry Failed to Registration.Try Again";
 }
  }
  }else{
   echo 'Your Username or Email Empty';
  }
?>

That's it how Generate Unique Username in PHP and JQuery ajax..
Keep visiting.Thank You..
also learn ..
1. PHP Generate Random Password
2. AJAX Auto Suggest

Latest

Wednesday, February 28, 2018

Generate Unique Username in PHP