diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/extern/ExternPageCourses.php | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/lib/extern/ExternPageCourses.php b/lib/extern/ExternPageCourses.php index 1d29523..0658ebf 100644 --- a/lib/extern/ExternPageCourses.php +++ b/lib/extern/ExternPageCourses.php @@ -347,12 +347,11 @@ class ExternPageCourses extends ExternPage */ private function getSearchSQL(array &$params): string { - if ($this->sword && mb_strlen($this->sword) > 2) { - $params[':sword'] = $this->sword; + if ($this->searchtext && mb_strlen($this->searchtext) > 2) { + $params[':searchtext'] = $this->searchtext; return " - AND (`seminare`.`Name` LIKE '%:sword%' - OR `seminare`.`VeranstaltungsNummer` LIKE '%:sword%' - OR `auth_user_md5`.`Nachname`)"; + AND (`seminare`.`Name` LIKE CONCAT('%',:searchtext,'%') + OR `seminare`.`VeranstaltungsNummer` LIKE CONCAT('%',:searchtext,'%'))"; } return ''; } |