Advertisement
Guest User

Untitled

a guest
Apr 20th, 2016
237
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. Catchable fatal error: Object of class mysqli_result could not be converted to string in /hermes/bosnaweb12a/b963/ipg.matjasicborutcom1/TouchSoccer/process.php on line 18
  2.  
  3. <?php
  4. include 'dbinfo.php';
  5. $choice = $_GET['choice'];
  6. $connect = mysqli_connect($hostname, $username, $password, $database);
  7. if (mysqli_connect_errno($connect))
  8. {
  9. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  10. }
  11. switch($choice)
  12. {
  13. case "register":
  14.  
  15. $username = $_GET['username'];
  16. $password = $_GET['password'];
  17. $email = $_GET['email'];
  18. $reg_ip = $_GET['reg_ip'];
  19.  
  20.  
  21. $query = mysqli_query($connect, "SELECT username FROM Accounts WHERE username = '$username'");
  22.  
  23.  
  24. if($query)
  25. {
  26. echo "username already exists";
  27. }
  28. else {
  29.  
  30. $insert = mysqli_query($connect, "INSERT INTO Accounts (username, password, email,reg_ip, wins, looses, experience) VALUES ('$username', md5('$password'), '$email', '$reg_ip', '0','0', '0'");
  31. if($insert) {
  32. echo "account successfully created";
  33.  
  34. }
  35. else {
  36. echo "error";
  37. }
  38.  
  39. }
  40.  
  41. break;
  42.  
  43. case "login":
  44.  
  45. $username = $_GET['username'];
  46. $password = $_GET['password'];
  47.  
  48. $user = mysqli_query($connect, "SELECT username FROM Accounts WHERE username = '$username'");
  49.  
  50. if($user = $username) {
  51. $pw = mysqli_query($connect, "SELECT password FROM Accounts WHERE password = md5('$password')");
  52.  
  53. if($pw = md5($password)) {
  54. echo "login was successful!";
  55. }
  56. else {
  57. echo "incorrect password";
  58. }
  59.  
  60. }
  61. else
  62. {
  63. echo "incorrect username";
  64. }
  65.  
  66.  
  67.  
  68. break;
  69.  
  70.  
  71. }
  72.  
  73. mysqli_close($connect);
  74. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement