Guest User

Untitled

a guest
Jan 21st, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. //retorna informação do quiz!
  2. $quiz = array();
  3.  
  4. $infoQuiz = $this->db->select('quiz.id AS id_quiz, quiz.nome_quiz,
  5. perg.pergunta,
  6. resp.resposta');
  7. $infoQuiz = $this->db->join('squiz_perguntas AS perg', 'perg.id_quiz = quiz.id');
  8. $infoQuiz = $this->db->join('squiz_respostas AS resp', 'resp.id_pergunta = perg.id');
  9. $infoQuiz = $this->db->order_by('quiz.id DESC');
  10. $infoQuiz = $this->db->where('quiz.enabled','1');
  11. $infoQuiz = $this->db->get('squiz_quiz AS quiz');
  12.  
  13. print_r($infoQuiz->result_array());
  14. exit();
Add Comment
Please, Sign In to add comment