Guest User

Untitled

a guest
Jul 17th, 2018
573
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.14 KB | None | 0 0
  1. if(isset($_POST['username']) && isset($_POST['password']) && isset($_POST['name']) && isset($_POST['last_name']) && isset($_POST['company'])){
  2.  
  3. if($username === '') {
  4. $errMsg = "Du skal udfylde brugernavn";
  5. }
  6. elseif($password === ''){
  7. $errMsg = "Du skal udfylde password";
  8. }
  9. elseif($name === ''){
  10. $errMsg = "Du skal udfylde navn";
  11. }
  12. elseif($last_name === ''){
  13. $errMsg = "Du skal udfylde efternavn";
  14. }
  15. elseif($company === ''){
  16. $errMsg = "Du skal udfylde firma";
  17. }
  18. $sql = ("SELECT * FROM members WHERE username ='$username'");
  19. $result = mysql_query($sql) or die('error');
  20. $row = mysql_fetch_assoc($result);
  21. if(mysql_num_rows($result)) {
  22. $errMsg = 'Brugernavn findes, vælg et andet.';
  23. } else {
  24. $sql = ("INSERT INTO members (username, password, name, last_name, company, salt)VALUES('$username', '$password', '$name', '$last_name', '$company', '$salt')")or die(mysql_error());
  25.  
  26. if(mysql_query($sql))
  27. echo "Du er oprettet som profil.";
  28. }
  29.  
  30. }//End whole if
  31.  
  32. $sql = "INSERT INTO members (username, password, name, last_name, company, salt)VALUES('" . mysql_real_escape_string($username) . "', '" . mysql_real_escape_string($password) . "', '" . mysql_real_escape_string($name) . "', '" . mysql_real_escape_string($last_name) . "', '" . mysql_real_escape_string($company) . "', '$salt')";
  33.  
  34. $sql = "SELECT COUNT(*) num FROM members WHERE username = '" . mysql_real_escape_string($username) . "'";
  35. $result = mysql_query($sql) or die('error');
  36. $row = mysql_fetch_assoc($result);
  37. if($row['num']) {
  38. $errMsg = 'Username exists';
  39. }
  40.  
  41. $sql = "SELECT * FROM members WHERE username = '" . mysql_real_escape_string($username) . "'";
  42. $result = mysql_query($sql) or die('error');
  43. $row = mysql_fetch_assoc($result);
  44. if(mysql_num_rows($result)) {
  45. $errMsg = 'Username exists';
  46. }
  47.  
  48. //If anything is empty write an error.
  49. if(empty($_POST['username'])){
  50. $errMsg = "Du skal udfylde brugernavn.";
  51. }
  52. elseif(empty($_POST['password'])){
  53. $errMsg = "Du skal udfylde password.";
  54. }
  55. elseif(empty($_POST['name'])){
  56. $errMsg = "Du skal udfylde navn.";
  57. }
  58. elseif(empty($_POST['last_name'])){
  59. $errMsg = "Du skal udfylde efternavn.";
  60. }
  61. elseif(empty($_POST['company'])){
  62. $errMsg = "Du skal udfylde firma.";
  63. } else {
  64. $sql = (" SELECT * FROM users WHERE username ='.$username.'")
  65. $res = mysql_query($sql) ;
  66. while ($row = mysql_fetch_array($res) ){
  67. $errMsg = "Your error message";
  68. exit();
  69. }
  70.  
  71. $sql = ("INSERT INTO members (username, password, name, last_name, company, salt)VALUES('$username', '$password', '$name', '$last_name', '$company', '$salt')")or die(mysql_error());
  72. if(mysql_query($sql))
  73. echo "Du er oprettet som profil.";
  74. }//End if empty else
  75.  
  76. $sSelect = "SELECT FROM members WHERE username = ".$sUserName." LIMIT 1";
  77. $rResult = mysql_query($sSelect);
  78. if (mysql_num_rows($rResult) > 0) {
  79. echo 'error, it exists!';
  80. }
Add Comment
Please, Sign In to add comment