Guest User

Untitled

a guest
Sep 15th, 2018
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.35 KB | None | 0 0
  1. Can't find the Unexpected T_STRING
  2. Parse error: syntax error, unexpected T_STRING in /var/www/html/registerBackend.php on line 118
  3.  
  4. $query = "INSERT INTO User (Name,Email,Password,Port) VALUES ('$name', '$email','$password','$port')";
  5. mysql_query($query) or die('Error, insert query failed');
  6.  
  7. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  8.  
  9. $dbname ='hidden';
  10. mysql_select_db($dbname);
  11.  
  12. //Check if Username has been used before
  13. $query = "SELECT * FROM User where Name='$name'";
  14. $result=mysql_query($query) or die('Error, insert query failed');
  15. $countName=mysql_num_rows($result);
  16.  
  17. //Check if email has been used before
  18. $query = "SELECT * FROM User where Email='$email'";
  19. $result=mysql_query($query) or die('Error, insert query failed');
  20. $countEmail=mysql_num_rows($result);
  21.  
  22. if($countName < 1 && $countEmail < 1){
  23.  
  24. //Assign their port number
  25. $query = "SELECT * FROM login;
  26. $countPort=mysql_num_rows($result);
  27. $port = 20000 + $countPort;
  28.  
  29.  
  30. $query = "INSERT INTO User (Name,Email,Password,Port) VALUES ('$name', '$email','$password','$port')";
  31. mysql_query($query) or die('Error, insert query failed');
  32.  
  33.  
  34. $query = "SELECT username, password FROM login WHERE username = '$username' AND password = '$password'";
  35. $result = mysql_query($query);
  36.  
  37. print "<center><div id=newAREA>You have been signed up!<br>";
  38. while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
  39. echo "Minecraft Username:{$row['Name']} <br>" .
  40. "Email:{$row['Email']} <br>" .
  41. "Password:{$row['Password']} <br>".
  42. "Port:{$row['Port']} <br>";
  43.  
  44. }
  45. } elseif ($countName > 1) {
  46. print "Someone has already used this Minecraft IGN! E-mail Stolen@freeminecrafthost.com to prove it is yours!";
  47. } elseif ($countEmail > 1) {
  48. print "Email has been used before!";
  49. }
  50.  
  51. $query = "SELECT * FROM login;
  52.  
  53. $query = "SELECT * FROM login";
  54.  
  55. $query = "INSERT INTO User (Name,Email,Password,Port) VALUES ('" . mysql_real_escape_string($name) . "', '" . mysql_real_escape_string($email) . "','" . mysql_real_escape_string($password) . "','" . mysql_real_escape_string($port) . "')";
  56. mysql_query($query) or die('Error, insert query failed');
  57.  
  58. $query = "SELECT * FROM login;
  59.  
  60. $query = "SELECT * FROM login";
  61.  
  62. //Assign their port number
  63. $query = "SELECT * FROM login;
  64. $countPort=mysql_num_rows($result);
  65. $port = 20000 + $countPort;
  66.  
  67. $query = "SELECT * FROM login";
Add Comment
Please, Sign In to add comment