/** * * @return bool|string */ public function queryArticleDownloadESD() { if (!method_exists($this, 'getDownloadEsdSelect')) { return false; } $sql = $this->getDownloadEsdSelect(); return $this->db->query($sql); }
/** * Writes a brand new Question to the database * * @param ? $instructions * @param ? $question_data * @param ? $correct_answer * @param ? $vQuestion * @return null|Model_Quiz_GeneratedQuestion */ public static function fromScratch($instructions, $question_data, $correct_answer, $vQuestion) { Model_Shell_Debug::getInstance()->log("Writing question to the database", __METHOD__); $db = Zend_Registry::get("db"); $sql = "INSERT INTO generated_questions(generated_id,instructions,question_data,correct_answer,question_basequestion_id) VALUES(NULL, " . $db->quote($instructions) . "," . $db->quote($question_data) . "," . $db->quote($correct_answer) . "," . $db->quote($vQuestion->getID()) . ")"; Model_Shell_Debug::getInstance()->log($sql); $db->beginTransaction(); $db->query($sql); //Now find the appropriate entry in the database // A safe (default) assumption for this is a query that looks for everything you just put in. $last_id = $db->lastInsertId(); $db->commit(); return Model_Quiz_GeneratedQuestion::fromID($last_id); $sql = "SELECT generated_id FROM generated_questions WHERE instructions=" . $db->quote($instructions) . " AND question_data=" . $db->quote($question_data) . " AND correct_answer=" . $db->quote($correct_answer) . " AND question_basequestion_id=" . $db->quote($vQuestion->getID()); $result = $db->query($sql); $row = $result->fetch(); if ($row['generated_id'] != null) { return Model_Quiz_GeneratedQuestion::fromID($row['generated_id']); } else { return null; //Something didn't happen } }