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)"); } }
$fonte = addslashes(trim($_POST['fonte'])); $ativa = addslashes(trim($_POST['ativa'])); try { $banco->iniciarTransacao(); $obj_tipo_pergunta = $sessionFacade->recuperarTipoPergunta($tipo_pergunta); $obj_topico = $sessionFacade->recuperarTopico($topico); $obj_curso = $sessionFacade->recuperarCurso($curso); $obj_disciplina = $sessionFacade->recuperarDisciplina($disciplina); if (strlen($topico_descricao)>0){ $obj_topico = new Topico(); $obj_topico->setDisciplina($obj_disciplina); $obj_topico->setDescricao($topico_descricao); $sessionFacade->gravarTopico($obj_topico); } $perg = new Pergunta(); $perg->setId($pergunta); $perg->setTopico($obj_topico); $perg->setTitulo($titulo_pergunta); $perg->setTipoPergunta($obj_tipo_pergunta); $perg->setDificuldade($dificuldade); $perg->setFonte($fonte); $perg->setAtiva($ativa); $qtde_respostas = 0; if (is_object($obj_tipo_pergunta)){
############## 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; } } ############################################################################## ############## INCLUDES : CABECALHO ############## ##############################################################################