Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function recuperaMembros(){
- $query = "
- SELECT
- u.nome, u.id
- FROM
- usuarios AS u
- JOIN
- membros AS m
- ON
- u.id = m.id_membro
- ";
- $stmt = $this->db->prepare($query);
- $stmt->bindValue(':id_membro',$this->__get('id_membro'));
- $stmt->execute();
- return $stmt->fetchAll(PDO::FETCH_ASSOC);
- }
- Array
- (
- [0] => Array
- (
- [nome] => kaue33
- [id] => 24
- )
- [1] => Array
- (
- [nome] => kaue44
- [id] => 25
- )
- )
- $membros = $membro->recuperaMembros();
- $this->view->membros = $membros;
Add Comment
Please, Sign In to add comment