[PHP | MySQL ] User Registration & User login System

Repository

https://github.com/kibriakk/lotto

PicsArt_10-10-09.37.32.png

What Will You Learn?

After complete the full tutorial you will learn

How to create a simple lotto web application
How to create online payment methood
How to create user and admin system in a site
How to secure a site
How to build a respinsive backend template

What Will You Learn from This part

From this part of my tutorial you will learn -

How to create a login page
How to create a registration page
How to connect login & registration page with database

Requirements

Php server
MySQL database
Knowledge about PHP, HTML, CSS and MySQL

Difficulty

Intermediate

Tutorial Contents

Hello steemians,

This is my third part of the tutorial. Today I will teach everyone how we can create a login, registration & forget password page. It is nessesary for every website / applications.

This part is so large. So we work partically. The theory is not nessesary for this part. I will describe shortly every function. I am really sorry that my English speech is not so good.

So lets start the tutorial-

Previous part I write the tutorial - how to create database for user managememt.

At first go to the 'root' folder of your web application.
create 2 new file and named them 'login.php', 'registration.php' ,
Open the 'login.php' with any text editor. Then write the following code

 
require_once('function.php');
connectdb();
session_start();   // for database connection

if (is_user()) {
    redirect("$baseurl/dashboard");
}
?>

Here first three line is for connecting database. last two line is for redirect logged user to dashboard. So, the logged user can not access login page.

Then write this code

<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
  <meta name="description" content="">
  <meta name="author" content="">
  <link rel="shortcut icon" href="/images/fav.png" type="image/png">       // (site icon) Change it to your favicon url  
    
    <title>Sign In</title>

  <link href="/css/style.default.css" rel="stylesheet">  // (css stylesheet)   change it to your stylesheet
</head>

This is the head tag of your login page

Then write these html code in <body></body> tag

<form method="post" action="">
                    <h4 class="nomargin">Sign In</h4>
                    <p class="mt5 mb20">Don't have an Account? <a href="/signup"><strong>Sign Up</strong></a></p>
                                          <input type="text" class="form-control uname" name="username" placeholder="Username" />
                    <input type="password" class="form-control pword" name="password" placeholder="Password" />
               
                    <button class="btn btn-success btn-block">Sign In</button>
                    
                </form>

now visit this page with any browser you can see that there is a login form.

But the form will not working. So now we write php code after the <form> tag.


<?php 

if ($_POST){
$username = $_POST['username'];
$password = md5($_POST['password']);

$count = mysql_fetch_array(mysql_unbuffered_query("SELECT COUNT(*) FROM users WHERE username='".$username."' AND password='".$password."'"));
if ($count[0]==1) {
$uname = $_POST['username']; 
$time = time();
$si = "$uname$time";
$sid = md5($si);
$_SESSION['sid'] = $sid;
$_SESSION['username'] = $username;
mysql_query("UPDATE users SET sid='".$sid."' WHERE username='".$uname."'");
redirect("$baseurl/dashboard");
}else{
echo '

×  
Wrong username or password
';
  }
}
 ?>




                        <?php if (!empty($_GET['error'])): ?>
                                
                                <?php endif ?>

I’ve quoted every code with commenting that which line doing what & which function is using for what. As we can see first of all we’ve included the db connection so that we can have the connection while calling the db connection through a object in constructor.

So the full code of login page is

<?php
 
require_once('function.php');
connectdb();
session_start();

if (is_user()) {
    redirect("$baseurl/dashboard");
}
?>



<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
  <meta name="description" content="">
  <meta name="author" content="">
  <link rel="shortcut icon" href="/images/fav.png" type="image/png">

  <title>Sign In</title>

  <link href="/css/style.default.css" rel="stylesheet">

</head>

                
                <form method="post" action="">
                    <h4 class="nomargin">Sign In</h4>
                    <p class="mt5 mb20">Don't have an Account? Sign Up
                        



<?php 

if ($_POST){
$username = $_POST['username'];
$password = md5($_POST['password']);

$count = mysql_fetch_array(mysql_unbuffered_query("SELECT COUNT(*) FROM users WHERE username='".$username."' AND password='".$password."'"));
if ($count[0]==1) {
$uu = $_POST['username']; 
$tm = time();
$si = "$uu$tm";
$sid = md5($si);
$_SESSION['sid'] = $sid;
$_SESSION['username'] = $username;
mysql_query("UPDATE users SET sid='".$sid."' WHERE username='".$uu."'");
redirect("$baseurl/dashboard");
}else{
echo '
<div class="alert alert-danger alert-dismissable">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>  
Wrong username or password
</div>';
  }
}
 ?>




                        <?php if (!empty($_GET['error'])): ?>
                                
                                <?php endif ?>
                                
                    <input type="text" class="form-control uname" name="username" placeholder="Username" />  // username field
                    <input type="password" class="form-control pword" name="password" placeholder="Password" />  //password field
               
                    <button class="btn btn-success btn-block">Sign In</button> //sign in button
                    
                </form>
           </body>

You should add css, stylesheet and design the page.

I will add full design with script after finishing full tutorial.

The registrations and forget password page is same of this. so I just write only the code.

For register.php file

<?php
require_once('function.php');
connectdb();
session_start();

if (is_user()) {
    redirect("$baseurl/dashboard");
}
?>



<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
  <meta name="description" content="">
  <meta name="author" content="">
  <link rel="shortcut icon" href="/images/fav.png" type="image/png">

  <title>Sign Up</title>

  <link href="/css/style.default.css" rel="stylesheet">

  
</head>

<body class="signin">



                
                <form method="post" action="">
                    <h3 class="nomargin">Sign Up</h3>
                    <p class="mt5 mb20">Already have an Account? <a href="/signin"><strong>Sign In</strong></a></p>

                    
                

<?php
if(isset($_GET['ref'])) {
$ref = $_GET['ref'];
$rrr = mysql_fetch_array(mysql_query("SELECT id FROM users WHERE username='".$ref."'"));
}else{
$rrr[0] = 0;
}


//echo "$rrr[0] ----------------- ";

if($_POST)
{

$username = $_POST["username"];
$pass1 = $_POST["password1"];
$pass2 = $_POST["password2"];
$email = $_POST["email"];
$country = $_POST["country"];
$phone = $_POST["phone"];


$err1=0;
$err2=0;
$err3=0;
$err4=0;
$err5=0;
$err6=0;
$err7=0;
$err8=0;





if(trim($username)=="")
      {
$err1=1;
}

if(trim($email)=="")
      {
$err2=1;
}

if($pass1!=$pass2)
      {
$err3=1;
}

if(strlen($pass1)<="3")
      {
$err4=1;
}

$nnn = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE username='".$username."'"));

if($nnn[0]>="1")
      {
$err5=1;
}

$eee = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE email='".$email."'"));

if($eee[0]>="1")
      {
$err6=1;
}

$ppp = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE phone='".$phone."'"));

if($ppp[0]>="1")
      {
$err7=1;
}




$error = $err1+$err2+$err3+$err4+$err5+$err6+$err7;


if ($error == 0){

$passmd = md5($pass1);


if($rrr[0]=="0" || $rrr[0]==""){
    $r = 1;
}else{
    $r = $rrr[0];
}



$res = mysql_query("INSERT INTO users SET username='".$username."', email='".$email."', password='".$passmd."', phone='".$phone."', country='".$country."', ref='".$r."'");

if($res){
    echo "
×    

Register Completed Successfully!

";

///////////////////------------------------------------->>>>>>>>>Send Email

$to = "$email";
$subject = 'Welcome to lotto';

$message = 'Hi,'."\r\n Thanks For us.";

$headers = 'From: ' . "$sender \r\n" .
    'Reply-To: ' . "$sender \r\n" .
    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

///////////////////------------------------------------->>>>>>>>>Send Email

///////////////////------------------------------------->>>>>>>>>Send SMS
/*
$msg = "Thanks For Joining O";
$sendsms = "http://bulksms.hostrecline.com/gateway/?user=*************************&pass=**********&to=$phone&sender=lotto&message=$msg"; 
$getsmsstatus = file_get_contents($sendsms);
*/
///////////////////------------------------------------->>>>>>>>>Send SMS




}else{
    echo "
×    

Some Problem Occurs, Please Try Again. 

";
}
} else {
    
if ($err1 == 1){
echo "
×    

Username Can Not be Empty!!!

";
}       
    
if ($err2 == 1){
echo "
×    

Email Can Not be Empty!!!

";
}       
    
if ($err3 == 1){
echo "
×    

Passwords Don't match!!

";
}       
    
if ($err4 == 1){
echo "
×    
Password Can not be less than 4 Letter 
";
}       
    
if ($err5 == 1){
echo "
×    
Username Already Exist !
";
}       
    
if ($err6 == 1){
echo "
×    
Email Already Exist !
";
}       
    
if ($err7 == 1){
echo "
×    
Phone Number Already Exist !
";
}       

}







}

?>

                  <input type="text" class="form-control uname" name="username" placeholder="Username" />   //username field
                    <input type="text" class="form-control email" name="email" placeholder="Email" />   // email field

                    <input type="text" class="form-control phn" name="phone" placeholder="Mobile eg: 8801XXXXXXXXX" />  //phone number field

                   <select class="form-control input-lg"  name="country">

                  <option Value="Bangladesh">Bangladesh</option>
                  <option Value="India">India</option>
                  <option Value="Pakistan">Pakistan</option>
                  <option Value="USA">USA</option>
                  <option Value="Canada">Canada</option>
                  <option Value="UK">UK</option>


                </select> // country option. you can add more country.



                    <input type="password" class="form-control pword" name="password1" placeholder="Password" />   //password field
                    <input type="password" class="form-control pword" name="password2" placeholder="Retype Password" />  // confirm pass field

                    
                    <button class="btn btn-success btn-block">Sign Up</button>  //signup button
                    
                </form>  // form end tag

</body>
</html>

All codes are too easy to realize. No need to change anything. You can change variables for security. If you have any question, please put a comment here. Note that here sid and password will store with md5 encryption.

Curriculum

Prove of work