From 94177cee799eaf7c493b0fd1137d7eeaec4fd918 Mon Sep 17 00:00:00 2001
From: Jacek Kowalski <Jacek@jacekk.info>
Date: Sat, 06 Jul 2019 00:10:00 +0000
Subject: [PATCH] Fix edge cases (no results, query empty) in find function
---
stops.php | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/stops.php b/stops.php
index 48d36b2..16eab82 100644
--- a/stops.php
+++ b/stops.php
@@ -12,7 +12,7 @@
$pdo = new PDO('sqlite:stops/stops.db', NULL, NULL, array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
));
- $st = $pdo->prepare('SELECT DISTINCT id FROM stop_search WHERE word LIKE ?');
+ $st = $pdo->prepare('SELECT DISTINCT id FROM stop_search WHERE word LIKE ? AND id LIKE \'t%\'');
// Split stop name into words
$words = split_stop_name($_GET['query']);
--
Gitblit v1.9.1