public function recuperarTopico($id_topico){ $query ="SELECT tbl_topico.topico AS topico, tbl_topico.disciplina AS disciplina, tbl_topico.descricao AS descricao FROM tbl_topico WHERE tbl_topico.topico = $id_topico "; $banco = $this->getBancoDados(); $topico = NULL; $retorno = $banco->executaSQL($query); if($retorno != NULL) { if ($banco->numRows($retorno) == 0){ throw new Exception("Nenhuma topico encontrado.",0); } while($linha = $banco->fetchArray($retorno)) { $sessionFacade = new SessionFacade($banco); $obj_disciplina = $sessionFacade->recuperarDisciplina($linha["disciplina"]); $topico = new Topico(); $topico->setId($linha['topico']); $topico->setDisciplina($obj_disciplina); $topico->setDescricao($linha["descricao"]); } return $topico; } else { throw new Exception("Erro ao recuperar Topico ($query)"); } }
############################################################################## ############## CADASTRAR / ALTERAR ############## ############################################################################## if (isset($_POST['btn_acao']) AND strlen(trim($_POST['btn_acao']))>0) { $topico = addslashes(trim($_POST['topico'])); $disciplina = addslashes(trim($_POST['disciplina'])); $descricao = addslashes(trim($_POST['descricao'])); try { $obj_disciplina = $sessionFacade->recuperarDisciplina($disciplina); $topic = new Topico(); $topic->setId($topico); $topic->setDisciplina($obj_disciplina); $topic->setDescricao($descricao); $sessionFacade->gravarTopico($topic); $banco->desconecta(); header("Location: cadastro.topico.php?topico=".$topic->getId()."&msg_codigo=1"); exit; } catch(Exception $e) { //header("location: cadastrarCliente.php?msg=".$e->getMessage()); array_push($msg_erro,$e->getMessage()); #exit; } } ##############################################################################