Guest User

Untitled

a guest
Dec 25th, 2017
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. <?php
  2.  
  3. define('DB_HOST', 'localhost');
  4. define('DB_NAME', 'practice');
  5. define('DB_USER','root');
  6. define('DB_PASSWORD','');
  7.  
  8. $con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
  9. $db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
  10.  
  11.  
  12. function NewUser()
  13. {
  14. $fullname = $_POST['name'];
  15. $userName = $_POST['user'];
  16. $email = $_POST['email'];
  17. $password = $_POST['pass'];
  18. $query = "INSERT INTO websiteusers (fullname,userName,email,pass) VALUES ('$fullname','$userName','$email','$password')";
  19. $data = mysql_query ($query)or die(mysql_error());
  20. if($data)
  21. {
  22. echo "YOUR REGISTRATION IS COMPLETED...";
  23. }
  24. }
  25.  
  26. function SignUp()
  27. {
  28. if(!empty($_POST['user'])) //checking the 'user' name which is from Sign-Up.html, is it empty or have some text
  29. {
  30. $query = mysql_query("SELECT * FROM websiteusers WHERE userName = '$_POST[user]' AND pass = '$_POST[pass]'") or die(mysql_error());
  31.  
  32. if(!$row = mysql_fetch_array($query) or die(mysql_error()))
  33. {
  34. newuser();
  35. }
  36. else
  37. {
  38. echo "SORRY...YOU ARE ALREADY REGISTERED USER...";
  39. }
  40. }
  41. }
  42. if(isset($_POST['submit']))
  43. {
  44. SignUp();
  45. }
  46. ?>
Add Comment
Please, Sign In to add comment