diff options
author | Alessandro Cosentino <cosenal@gmail.com> | 2012-07-17 21:49:38 -0400 |
---|---|---|
committer | Alessandro Cosentino <cosenal@gmail.com> | 2012-07-17 21:49:38 -0400 |
commit | 4ce35659094ed4df43ad41a198a2944aeced9784 (patch) | |
tree | 13be6588a7aa99a5a35700f4552bffb71e2e7a1d /lib/feedmapper.php | |
parent | c378e972a12ba41d252d74e509f88ea7bec2544d (diff) |
update feeds works; need to be polished
Diffstat (limited to 'lib/feedmapper.php')
-rw-r--r-- | lib/feedmapper.php | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/lib/feedmapper.php b/lib/feedmapper.php index c43ff47a5..80afcb481 100644 --- a/lib/feedmapper.php +++ b/lib/feedmapper.php @@ -16,6 +16,27 @@ class OC_News_FeedMapper { const tableName = '*PREFIX*news_feeds'; + + /** + * @brief + * @param userid + * @returns + */ + public function findAll($userid){ + $stmt = OCP\DB::prepare('SELECT * FROM ' . self::tableName . + ' JOIN ' . OC_News_FolderMapper::tableName . + ' ON ' . self::tableName. '.folder_id=' . OC_News_FolderMapper::tableName . '.id' . + ' WHERE user_id = ?'); + $result = $stmt->execute(array($userid)); + $feeds = array(); + while ($row = $result->fetchRow()) { + $url = $row['url']; + $id = $row['id']; + $folderid = $row['folder_id']; + $feeds[] = array("url" => $url, "id" => $id, "folderid" => $folderid); + } + return $feeds; + } /** * @brief Retrieve a feed from the database |