<?php error_reporting(0); if(isset($_POST['submit'])) { $fname=$_POST['fname']; $mnumber=$_POST['mobilenumber']; $email=$_POST['email']; $password=md5($_POST['password']); $sql="INSERT INTO tblusers(FullName,MobileNumber,EmailId,Password) VALUES(:fname,:mnumber,:email,:password)"; $query = $dbh->prepare($sql); $query->bindParam(':fname',$fname,PDO::PARAM_STR); $query->bindParam(':mnumber',$mnumber,PDO::PARAM_STR); $query->bindParam(':email',$email,PDO::PARAM_STR); $query->bindParam(':password',$password,PDO::PARAM_STR); $query->execute(); $lastInsertId = $dbh->lastInsertId(); if($lastInsertId) { $_SESSION['msg']="You are Scuccessfully registered. Now you can login "; header('location:thankyou.php'); } else { $_SESSION['msg']="Something went wrong. Please try again."; header('location:thankyou.php'); } } ?> <!--Javascript for check email availabilty--> <script> function checkAvailability() { $("#loaderIcon").show(); jQuery.ajax({ url: "check_availability.php", data:'emailid='+$("#email").val(), type: "POST", success:function(data){ $("#user-availability-status").html(data); $("#loaderIcon").hide(); }, error:function (){} }); } if (isset($_POST['register'])) { $email = $_POST['email']; $password = $_POST['password']; // เข้ารหัสรหัสผ่าน $hashed_password = password_hash($password, PASSWORD_DEFAULT); $sql = "INSERT INTO tblusers (EmailId, Password) VALUES (:email, :password)"; $query = $dbh->prepare($sql); $query->bindParam(':email', $email, PDO::PARAM_STR); $query->bindParam(':password', $hashed_password, PDO::PARAM_STR); $query->execute(); } </script> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> </div> <section> <div class="modal-body modal-spa"> <div class="login-grids"> <div class="login"> <div class="login-right"> <form name="signup" method="post" action="signup.php"> <h3>Create your account </h3> <input type="text" value="" placeholder="Full Name" name="fname" autocomplete="off" required=""> <input type="text" value="" placeholder="Mobile number" maxlength="10" name="mobilenumber" autocomplete="off" required=""> <input type="text" value="" placeholder="Email id" name="email" id="email" onBlur="checkAvailability()" autocomplete="off" required=""> <span id="user-availability-status" style="font-size:12px;"></span> <input type="password" value="" placeholder="Password" name="password" required=""> <input type="submit" name="submit" id="submit" value="CREATE ACCOUNT"> </form> </div> <div class="clearfix"></div> </div> <p>By logging in you agree to our <a href="page.php?type=terms">Terms and Conditions</a> and <a href="page.php?type=privacy">Privacy Policy</a></p> </div> </div> </section> </div> </div> </div> </div> </div> </div>