X-Git-Url: https://git.cweiske.de/grauphel.git/blobdiff_plain/93298095b3c4455aa1a4c676d6e2f9915ca06caa..2b5ff5d48b4ec80e0e0e18188689edefaeefe91d:/lib/notestorage.php?ds=inline diff --git a/lib/notestorage.php b/lib/notestorage.php index 0aeef9e..951bf06 100644 --- a/lib/notestorage.php +++ b/lib/notestorage.php @@ -271,6 +271,29 @@ class NoteStorage return $row['note_guid']; } + /** + * Search for a note + * + * @param string $query Query string + * + * @return array Database rows with note_guid and note_title + */ + public function search($query) + { + $result = \OC_DB::executeAudited( + 'SELECT `note_guid`, `note_title`' + . ' FROM `*PREFIX*grauphel_notes`' + . ' WHERE note_user = ? AND note_title LIKE ?', + array($this->username, '%' . $query . '%') + ); + + $notes = array(); + while ($row = $result->fetchRow()) { + $notes[] = $row; + } + return $notes; + } + /** * Save a note into storage. *