//หน้า insert_account.php

Code (PHP)

<?php

require 'connect_mysqli.php';


$email = isset($_POST['email']) ? trim($_POST['email']) : "";

 $sqli = "select * from usertable where Login ='{$email}' ";
 
 $result = $mysqli->query($sqli);
 if(mysqli_num_rows($result)>0)
{
 
 
 /* echo 'Please enter a new duplicate emails',"<br><br>"; */
 echo "<script>alert('Please enter a new duplicate emails');window.location='index.php';</script>";
 exit(0);
}




 $sqli = " insert into usertable (Login, Password)
 values 
 (
 '{$mysqli->escape_string($_POST['email'])}'
 , '{$mysqli->escape_string($_POST['inputPassword'])}' 
 
 );
 ";
 
 $result = $mysqli->query($sqli);
 

 
 if($result){
 
 
 echo "<script>alert('successful');window.location='continue.php';</script>";
 
 
 }else{
 
 echo 'unsuccessful',"<br><br>";
 echo '<a href="index.php">Try Again</a>';
 exit(0);
 
 }


?>

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
//หน้า madallogin.php

<meta charset="UTF-8">
<title>Login to Everdwell</title>


<link rel="stylesheet" href="bootstrap-3.3.4/css/bootstrap.min.css">
<!-- Optional theme -->
<link rel="stylesheet"
href="bootstrap-3.3.4/css/bootstrap-theme.min.css">
<!-- Latest compiled and minified JavaScript -->

<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="bootstrap-3.3.4/js/bootstrap.min.js"></script>
<script src="bootstrap-3.3.4/js/validator.js"></script>

<link
 href="//maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css"
 rel="stylesheet">

 <div id="login-overlay" class="modal-dialog">
 <div class="modal-content">
 <div class="modal-header">
 <button type="button" class="close" data-dismiss="modal">
 <span aria-hidden="true">?</span><span class="sr-only">Close</span>
 </button>
 <h4 class="modal-title" id="myModalLabel">Login to site.com</h4>
 </div>



 <div class="modal-body">
 <div class="row">
 <div class="col-xs-6">
 <div class="well">
 <form data-toggle="validator" role="form" action="" method="post"
 id="login">
 <div class="form-group">
 <label for="inputName" class="control-label">Email</label> <input
 type="email" class="form-control" id="mail" name="mail"
 placeholder="Enter Email" required>
 </div>


 <div class="form-group">
 <label for="inputName" class="control-label">Password</label> <input
 type="password" class="form-control" id="pass" name="pass"
 placeholder="Enter Password" required>
 </div>


 <div id="loginErrorMsg" class="alert alert-error hide">Wrong
 username og password</div>
 <div class="checkbox">
 <label> <input type="checkbox" name="remember" id="remember">
 Remember login
 </label>
 <p class="help-block">(if this is a private computer)</p>
 </div>
 <button type="submit" class="btn btn-primary btn-block">Login</button>
 <a href="/forgot/" class="btn btn-default btn-block">Forgot
 Password</a>
 </form>
 </div>
 </div>




 <div class="col-xs-6">
 <form data-toggle="validator" role="form" id="register" name="register"
 action="insert_account.php" method="post">
 <div class="form-group">
 <label for="inputName" class="control-label">Email</label> <input
 type="email" class="form-control" id="email" name="email"
 placeholder="Enter Email" required>
 </div>


 <div class="form-group">
 <label for="inputPassword" class="control-label">Password</label>
 <input type="password" data-minlength="6" class="form-control"
 id="inputPassword" name="inputPassword" placeholder="Password"
 required> <span class="help-block">Minimum of 6 characters</span>
 </div>



 <div class="form-group ">
 <label for="inputPassword" class="control-label">Confirm
 Password</label> <input type="password" class="form-control"
 id="inputPasswordConfirm" name="inputPasswordConfirm"
 data-match="#inputPassword"
 data-match-error="Whoops, these don't match"
 placeholder="Confirm" required>
 <div class="help-block with-errors"></div>
 </div>



 <div id="loginErrorMsg" class="alert alert-error hide">Wrong
 username og password</div>
 <div class="checkbox">
 <p>&nbsp;</p>
 </div>
 <button type="submit" class="btn btn-primary btn-block" id="btnSubmit">Create My
 Account</button>
 
 </div>


 </form>

 </div>
 </div>
 </div>
 </div>

--------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://drive.google.com/file/d/0Bz0wpJT7XoWscUZ6VTVEblN3OU0/view?usp=sharing