Advertisement
irishstorm

registration.js

May 9th, 2013
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. <?php
  2. mysql_connect("localhost", "root", "") or die(mysql_error());
  3. mysql_select_db("unity") or die(mysql_error());
  4.  
  5. $Username = mysql_real_escape_string($_POST['username']);
  6. $Email = mysql_real_escape_string($_POST['email']);
  7. $Password = mysql_real_escape_string($_POST['password']);
  8.  
  9. // Check to see if the user exits.
  10. $check = mysql_query("SELECT * FROM `members` WHERE username='$Username'");
  11. $rows = mysql_num_rows($check);
  12.  
  13. // if the user does not exit, then create them.
  14. if($rows == 0)
  15. {
  16. // Encrypts the users password
  17. $Password = md5($Password);
  18.  
  19. // Inserts the data into the table
  20. $createuser = mysql_query("INSERT INTO `members` (username, email, password) VALUES ('$Username', '$Email', '$Password')");
  21.  
  22. if($createuser)
  23. {
  24. echo "Account Created!";
  25. }
  26. }
  27. else
  28. {
  29. $result = mysql_query("SELECT * FROM members") or die(mysql_error());
  30. $row = mysql_fetch_array( $result );
  31.  
  32. while($row = mysql_fetch_array( $result ))
  33. {
  34. $user = $row['username'];
  35. $email = $row['email'];
  36.  
  37. if($Username == $user)
  38. {
  39. die("Username already in use!");
  40. }
  41.  
  42. if($Email == $email)
  43. {
  44. die("Email already in use!");
  45. }
  46. }
  47. }
  48. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement