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])) {
