Advertisement
Guest User

Untitled

a guest
Feb 26th, 2018
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. <?php
  2. require_once 'config/Database.php';
  3. error_reporting(0);
  4. if (isset($_POST['register'])) {
  5.  
  6. $error = "";
  7.  
  8. if (empty($_POST['username']) || empty($_POST['email'] || empty($_POST['password']) || empty($_POST['repeatpassword']))) {
  9. $error = 'please input username email password and repeat password';
  10. }
  11. elseif($_POST['password'] === $_POST['repeatpassword']){
  12. $error = 'please password and repeat password same';
  13. }
  14.  
  15.  
  16. try {
  17. $stmt = $conn->prepare('SELECT * FROM users WHERE username=:username');
  18. $query_params = [':username' => $_POST['username']];
  19. $stmt->execute($query_params);
  20. } catch (PDOException $e) {
  21. die('query failed'.$e->getMessage());
  22. }
  23. $row = $stmt->fetch(PDO::FETCH_ASSOC);
  24. if ($row) {
  25. $error = 'username has used';
  26. }
  27.  
  28. if (!filter_var($_POST['email'],FILTER_VALIDATE_EMAIL)) {
  29. $error = 'please use valid email';
  30. }
  31. try {
  32. $stmt = $conn->prepare('SELECT * FROM users WHERE email=:email');
  33. $query_params = [':email' => $_POST['email']];
  34. $stmt->execute($query_params);
  35. } catch (PDOException $e) {
  36. die('error query1'.$e->getMessage());
  37. }
  38. $row = $stmt->fetch(PDO::FETCH_ASSOC);
  39. if($row){
  40. $error ="email has used";
  41. }
  42.  
  43. $password = hash('sha256',$_POST['password']);
  44.  
  45. try {
  46. $stmt = $conn->prepare('INSERT INTO users (username, email , password) VALUES (:username, :email , :password)');
  47. $query_params = [
  48. ':username' => $_POST['username'],
  49. ':email' => $_POST['email'],
  50. ':password' => $password
  51. ];
  52. $stmt->execute($query_params);
  53. } catch (PDOException $e) {
  54. die('error query2'.$e->getMessage());
  55. }
  56. if($stmt){
  57. header('location: login.php');
  58. }else{
  59. return false;
  60. }
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67. }
  68.  
  69.  
  70.  
  71. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement