Advertisement
Guest User

Untitled

a guest
Oct 10th, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.37 KB | None | 0 0
  1. function right_answer($username, $password)
  2. {
  3.  
  4. // OR instead of overloading the function
  5. // you can globalize username and password.
  6. // assuming they are already logged in. Like this:
  7. global $username;
  8. gloabl $password;
  9.  
  10. $connection = @mysql_connect("xxxxx", "xxxxx", "xxxxx") or die(mysql_error());
  11. mysql_select_db("user_db", $connection);
  12. $result = mysql_query("SELECT math_score FROM `user_info` WHERE user_name='$username' AND user_pass='$password'");
  13. while($row = mysql_fetch_array($result))
  14.   {
  15.   $row['math_score'];
  16.   }
  17. $new_score = $row['math_score'] + 5;
  18. $update_user = "UPDATE `user_db`.`user_info` SET math_score='$new_score' WHERE user_name='$username' AND user_pass='$password'";
  19. $edited = @mysql_query($update_user, $connection) or die(mysql_error());
  20. }
  21.  
  22. function wrong_answer($username, $password)
  23. {
  24.  
  25. $connection = @mysql_connect("xxxxx", "xxxxx", "xxxxx") or die(mysql_error());
  26. mysql_select_db("user_db", $connection);
  27. $result = mysql_query("SELECT math_score FROM `user_info` WHERE user_name='$username' AND user_pass='$password'");
  28. while($row = mysql_fetch_array($result))
  29.   {
  30.   $row['math_score'];
  31.   }
  32. $new_score = $row['math_score'] - 2;
  33. $update_user = "UPDATE `user_db`.`user_info` SET math_score='$new_score' WHERE user_name='$username' AND user_pass='$password'";
  34. $edited = @mysql_query($update_user, $connection) or die(mysql_error());
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement