Blocked::query PHP Method

query() public method

public query ( $postdata = null )
    public function query($postdata = null)
    {
        $sth = $this->db->query('SELECT blocks.id AS block_id, blocks.blockid, blocks.comment, ' . implode(',', User::getDefaultFields()) . ' FROM blocks LEFT JOIN users ON blocks.blockid = users.id WHERE userid = ' . $this->user->getId());
        $result = array();
        while ($row = $sth->fetch(PDO::FETCH_ASSOC)) {
            $friend["user"] = $this->user->generateUserObject($row);
            $friend["id"] = $row["block_id"];
            $friend["comment"] = $row["comment"];
            $friend["user"]["last_access"] = $row["last_access"];
            array_push($result, $friend);
        }
        return $result;
    }

Usage Example

Ejemplo n.º 1
0
     break;
 case validateRoute('POST', 'friends'):
     $friends = new Friends($db, $user);
     httpResponse($friends->create($postdata));
     break;
 case validateRoute('DELETE', 'friends/\\d+'):
     $friends = new Friends($db, $user);
     httpResponse($friends->delete((int) $params[1]));
     break;
 case validateRoute('PATCH', 'friends/\\d+'):
     $friends = new Friends($db, $user);
     httpResponse($friends->update((int) $params[1]), $postdata);
     break;
 case validateRoute('GET', 'blocked'):
     $blocked = new Blocked($db, $user);
     httpResponse($blocked->query());
     break;
 case validateRoute('POST', 'blocked'):
     $blocked = new Blocked($db, $user);
     httpResponse($blocked->create($postdata));
     break;
 case validateRoute('DELETE', 'blocked/\\d+'):
     $blocked = new Blocked($db, $user);
     httpResponse($blocked->delete((int) $params[1]));
     break;
 case validateRoute('GET', 'bookmarks'):
     $bookmarks = new Bookmarks($db, $user);
     httpResponse($bookmarks->query(null));
     break;
 case validateRoute('POST', 'bookmarks'):
     $bookmarks = new Bookmarks($db, $user);