Suggestions::query PHP Method

query() public method

public query ( $view, $limit )
    public function query($view, $limit)
    {
        $limit = (int) $limit;
        switch ($view) {
            case 'hot':
                $where = 'status = 0';
                $orderBy = 'hotpoints DESC, votes DESC';
                break;
            case 'top':
                $where = 'status != 3 AND status != 1';
                $orderBy = 'votes DESC';
                break;
            case 'new':
                $where = 'status != 3';
                $orderBy = 'id DESC';
                break;
            case 'denied':
                $where = 'status = 3';
                $orderBy = 'id DESC';
                break;
            case 'done':
                $where = 'status = 2';
                $orderBy = 'id DESC';
                break;
            default:
                $where = 'status <> -1';
                $orderBy = 'id DESC';
        }
        $sth = $this->db->query('SELECT * FROM suggestions WHERE ' . $where . ' ORDER BY ' . $orderBy . ' LIMIT ' . $limit);
        return $sth->fetchAll(PDO::FETCH_ASSOC);
    }

Usage Example

Esempio n. 1
0
 case validateRoute('POST', 'news'):
     $forum = new Forum($db, $user);
     $news = new News($db, $user, $forum);
     httpResponse($news->create($postdata));
     break;
 case validateRoute('PATCH', 'news/\\d+'):
     $news = new News($db, $user);
     httpResponse($news->update($params[1], $postdata));
     break;
 case validateRoute('DELETE', 'news/\\d+'):
     $news = new News($db, $user);
     httpResponse($news->delete($params[1]));
     break;
 case validateRoute('GET', 'suggestions'):
     $suggestions = new Suggestions($db, $user);
     $arr = $suggestions->query($_GET["view"] ?: 'top', (int) $_GET["limit"] ?: 10);
     httpResponse($arr);
     break;
 case validateRoute('POST', 'suggestions/\\d+/votes'):
     $suggestions = new Suggestions($db, $user);
     $arr = $suggestions->vote($params[1], $postdata["direction"]);
     httpResponse($arr);
     break;
 case validateRoute('POST', 'suggestions'):
     $forum = new Forum($db, $user);
     $suggestions = new Suggestions($db, $user, $forum);
     httpResponse($suggestions->create($postdata));
     break;
 case validateRoute('PATCH', 'suggestions/\\d+'):
     $forum = new Forum($db, $user);
     $suggestions = new Suggestions($db, $user, $forum);