Backend for songs.zachdecook.com
verse searching: Slightly improve
Zach DeCook 2022-05-11
parent 6288883 · commit b3fd4dd
-rw-r--r--laravel/app/Song.php2
-rwxr-xr-xlaravel/public/searchVerse.gmi2
2 files changed, 2 insertions, 2 deletions
diff --git a/laravel/app/Song.php b/laravel/app/Song.php
index 6705dfa..98f11c3 100644
--- a/laravel/app/Song.php
+++ b/laravel/app/Song.php
@@ -17,7 +17,7 @@ class Song extends Model
$book = explode(' ',$passage)[0];
$chapter = (int)explode(' ', $passage)[1];
- return Song::where('verse', 'LIKE', "$book $chapter:%")->orWhere('verse',"$book $chapter");
+ return Song::where('verse', 'LIKE', "$book $chapter:%")->orWhere('verse',"$book $chapter")->orWhere('verse', 'LIKE', "%; $book $chapter:%");
}
public function textTranspose($key)
{
diff --git a/laravel/public/searchVerse.gmi b/laravel/public/searchVerse.gmi
index d779988..c7f6b5f 100755
--- a/laravel/public/searchVerse.gmi
+++ b/laravel/public/searchVerse.gmi
@@ -24,6 +24,6 @@ if (!count($results)) {
printf("20 text/gemini\r\n");
?>
<?php foreach($results as $song): ?>
-=> /song.gmi.php/<?=$song->id?> <?= $song->verse ?>: <?= $song->title ?>
+=> gemini://<?=getenv('HOSTNAME')?>/song.gmi.php/<?=$song->id?> <?= $song->verse ?>: <?= $song->title ?>
<?php endforeach; ?>