Guest User

Untitled

a guest
Feb 3rd, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. <?php
  2. $dbhost = "localhost";
  3. $dbuser = "root";
  4. $dbpass = "";
  5. $dbname = "login";
  6. $conn = new mysqli($dbhost,$dbuser,$dbpass,$dbname);
  7. if($conn->connect_error){
  8. die("Could not connect to the database!" . $conn->connect_error);
  9. }
  10. else {
  11. echo "Connected successfully";
  12. }
  13. // $uname = check_input($_POST['uname']);
  14. // $pass = check_input($_POST['pass']);
  15. // $pass = sha1($pass);
  16. //// echo "$uname";
  17. // echo "$pass";
  18. if(isset($_POST['action']) && $_POST['action'] == 'register'){
  19. $uname = check_input($_POST['uname']);
  20. $email = check_input($_POST['email']);
  21. $pass = check_input($_POST['pass']);
  22. $cpass = check_input($_POST['cpass']);
  23. $pass = sha1($pass);
  24. $cpass = sha1($cpass);
  25. $created = date('Y-m-d');
  26.  
  27. if($pass!= $cpass){
  28. echo "Password did not matched!";
  29. exit();
  30. }
  31. else{
  32. $sql = $conn -> prepare("SELECT * FROM users WHERE username=? OR email = ?");
  33. $sql -> bind_param('ss',$uname, $email);
  34. $sql -> execute();
  35. $result = $sql -> get_result();
  36. $row=$result -> fetch_array(MYSQLI_ASSOC);
  37. if ($result['username'] == $uname) {
  38. echo "Username not availabe try different";
  39. }
  40. elseif ($result['email']==$email) {
  41. echo "email is already taken diiferent";
  42. }
  43. else {
  44. $stmt = $conn -> prepare("INSERT INTO users (username, email, pass, created) VALUES (?, ?, ?, ?)");
  45. $stmt -> bind_param('ssss', $username, $email, $pass, $created);
  46. if ($stmt->execute()) {
  47. echo "Registrated sucessfully. Login Now!";
  48. $stmt->close();
  49. $conn->close();
  50.  
  51. }
  52. else {
  53. echo "Something went wrong. Please try again";
  54. }
  55. }
  56. }
  57.  
  58. }
  59. function check_input($data){
  60. $data = trim($data);
  61. $data = stripslashes($data);
  62. $data = htmlspecialchars($data);
  63. return $data;
  64. }
  65. ?>
Add Comment
Please, Sign In to add comment