function getScripturesByBook($book_id = "-1") { global $test; if ($book_id == "-1") { $scriptures = getScriptures(); } else { $query = ' SELECT Scriptures.scripture_id, Scriptures.chapter, Scriptures.verse, Scriptures.content, Books.name FROM Scriptures INNER JOIN Books ON Scriptures.book_id = Books.book_id WHERE Scriptures.book_id = :book_id ORDER BY Books.name'; $statement = $test->prepare($query); $statement->bindValue(":book_id", $book_id); $statement->execute(); $scriptures = $statement->fetchAll(); $statement->closeCursor(); } return $scriptures; }
$topics[] = $topic; } $scripture["book_id"] = $book["book_id"]; $scripture["chapter"] = $chapter; $scripture["verse"] = $verse; $scripture["content"] = $content; require_once 'model/scriptures.php'; insertScripture($scripture, $topics); header('location: /?action=searchscriptures'); break; case "scripture_result": require_once 'private/dbtest.php'; require_once 'model/scriptures.php'; $book = filter_input(INPUT_POST, 'book'); if (!isset($book) || $book == "all") { $scriptures = getScriptures(); } else { $scriptures = getScripturesByBook($book); } $max = count($scriptures); require_once 'model/topics.php'; for ($i = 0; $i < $max; $i++) { $topics = getTopicsByScripture($scripture["scripture_id"]); $scriptures[$i]["topics"] = $topics; echo "<!--" . $scriptures[$i]["scripture_id"] . count($topics) . "-->"; } $title = "Scripture Results"; $active = "assignments"; include 'view/head.php'; include 'view/header.php'; if (isset($scriptures[0])) {