public function selectMaisVistos() { $sql = "SELECT * "; $sql .= "FROM galeria glr "; $sql .= "JOIN categorias_galeria ctg ON ctg.ctg_id = glr.glr_categoria "; $sql .= "ORDER BY glr.glr_visualizacoes DESC "; $sql .= "LIMIT 0 , 3"; $result = $this->retrieve($sql); $lista = array(); while ($qr = mysqli_fetch_array($result)) { $glr = new Galeria(); $glr->setGlr_idgaleria($qr["glr_idgaleria"]); $glr->setGlr_nome($qr["glr_nome"]); $glr->setGlr_arquivo($qr["glr_arquivo"]); $glr->setGlr_descricao($qr["glr_descricao"]); $glr->setGlr_data($qr["glr_data"]); $glr->setGlr_categoria(new CategoriaGaleria()); $glr->getGlr_categoria()->setCtg_id($qr["ctg_id"]); $glr->getGlr_categoria()->setCtg_categoria($qr["ctg_categoria"]); $glr->getGlr_categoria()->setCtg_classe($qr["ctg_classe"]); $glr->setGlr_visualizacoes($qr["glr_visualizacoes"]); array_push($lista, $glr); } return $lista; }