Guest User

Untitled

a guest
Jan 21st, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. public function recuperaMembros(){
  2.  
  3. $query = "
  4. SELECT
  5. u.nome, u.id
  6. FROM
  7. usuarios AS u
  8. JOIN
  9. membros AS m
  10. ON
  11. u.id = m.id_membro
  12. ";
  13.  
  14. $stmt = $this->db->prepare($query);
  15. $stmt->bindValue(':id_membro',$this->__get('id_membro'));
  16. $stmt->execute();
  17.  
  18. return $stmt->fetchAll(PDO::FETCH_ASSOC);
  19. }
  20.  
  21. Array
  22. (
  23. [0] => Array
  24. (
  25. [nome] => kaue33
  26. [id] => 24
  27. )
  28.  
  29. [1] => Array
  30. (
  31. [nome] => kaue44
  32. [id] => 25
  33. )
  34.  
  35. )
  36.  
  37. $membros = $membro->recuperaMembros();
  38. $this->view->membros = $membros;
Add Comment
Please, Sign In to add comment