diff options
| author | Thomas Lange <code@nerdmind.de> | 2018-04-01 16:18:47 +0200 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2018-04-01 16:18:47 +0200 |
| commit | 2a017afea40941f6cc18208a6f595ee129ae143c (patch) | |
| tree | 9e922b86b12071cc74241d521eb69a677f54c5ea /core/namespace/Page/Item.php | |
| parent | 1da2c1e38a3b47840243b2021b41130ac667eba5 (diff) | |
| download | blog-2a017afea40941f6cc18208a6f595ee129ae143c.tar.gz blog-2a017afea40941f6cc18208a6f595ee129ae143c.tar.xz blog-2a017afea40941f6cc18208a6f595ee129ae143c.zip | |
Add method "getSearchResults" to Page and Post class
Diffstat (limited to 'core/namespace/Page/Item.php')
| -rw-r--r-- | core/namespace/Page/Item.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/core/namespace/Page/Item.php b/core/namespace/Page/Item.php index 4206f2f..cd2c94f 100644 --- a/core/namespace/Page/Item.php +++ b/core/namespace/Page/Item.php @@ -41,6 +41,20 @@ class Item extends \Item { } #=============================================================================== + # Return search results as Page\Attribute + #=============================================================================== + public static function getSearchResults($search, \Database $Database): array { + $Statement = $Database->prepare(sprintf("SELECT * FROM %s WHERE + MATCH(name, body) AGAINST(? IN BOOLEAN MODE) LIMIT 20", Attribute::TABLE)); + + if($Statement->execute([$search])) { + return $Statement->fetchAll($Database::FETCH_CLASS, 'Page\Attribute'); + } + + return []; + } + + #=============================================================================== # Return associated User\Attribute #=============================================================================== public function getUserAttribute() { |