Advertisement
Guest User

Untitled

a guest
Jun 25th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. class user{
  2. // new methods don't care about this anymore so this will get deleted
  3. public $logs = array();
  4.  
  5. // ... irrelevant methods left out ...
  6.  
  7. // old method
  8. public function user_search($db_connection, $user_id=null, $username=null){
  9. $result = false;
  10. if($user_id == null && $username == null)
  11. $this->logs[] = "No information to search on has been found.";
  12. elseif($db_connection == false)
  13. $this->logs[] = "Something went wrong with the database.";
  14. else{
  15. $this->logs[] = "Searching the user in the database.";
  16. $query_user_search = $db_connection->prepare('SELECT * FROM users WHERE user_username=:user_username OR user_id=:user_id');
  17. $query_user_search->bindValue(':user_username', $username, PDO::PARAM_STR);
  18. $query_user_search->bindValue(':user_id', $user_id, PDO::PARAM_STR);
  19. $query_user_search->execute();
  20. if($result = $query_user_search->fetch())
  21. $this->logs[] = "We found the user.";
  22. else
  23. $this->logs[] = "We didn't find the user.";
  24. }
  25. return $result;
  26. }
  27.  
  28. // new method
  29. public function user_search_info($db_con, $user_id=null, $user_username=null){
  30. $query_user_search_info = $db_con->prepare('SELECT * FROM users WHERE user_username=:user_username OR user_id=:user_id');
  31. $query_user_search_info->bindValue(':user_id', $user_id, PDO::PARAM_STR);
  32. $query_user_search_info->bindValue(':user_username', $user_username, PDO::PARAM_STR);
  33. $query_user_search_info->execute();
  34. return $query_user_search_info->fetch();
  35. }
  36. }
  37.  
  38. public function return_user_search_info($search_user_variable, $search_user_value)
  39. {
  40. $user_search_info = false;
  41. if($search_user_variable == "user_id")
  42. $user_search_info = $this->user->user_search_info($this->db_con, $search_user_value, "");
  43. elseif($search_user_variable == "user_username")
  44. $user_search_info = $this->user->user_search_info($this->db_con, "", $search_user_value);
  45. return $user_search_info;
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement