Blocked::create PHP Method

create() public method

public create ( $postdata )
    public function create($postdata)
    {
        $myEnemy = $this->user->get($postdata["blockid"]);
        if (!$myEnemy) {
            throw new Exception(L::get("USER_NOT_EXIST"));
        }
        $sth = $this->db->prepare('SELECT 1 FROM blocks WHERE userid = ? AND blockid = ?');
        $sth->bindValue(1, $this->user->getId(), PDO::PARAM_INT);
        $sth->bindParam(2, $myEnemy["id"], PDO::PARAM_INT);
        $sth->execute();
        if ($sth->fetch()) {
            throw new Exception(L::get("USER_ALREADY_BLOCKED"));
        }
        $sth = $this->db->prepare("INSERT INTO blocks(userid, blockid, comment) VALUES(?, ?, ?)");
        $sth->bindValue(1, $this->user->getId(), PDO::PARAM_INT);
        $sth->bindParam(2, $myEnemy["id"], PDO::PARAM_INT);
        $sth->bindParam(3, $postdata["comment"], PDO::PARAM_STR);
        $sth->execute();
    }

Usage Example

Example #1
0
     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);
     httpResponse($bookmarks->create($postdata));
     break;
 case validateRoute('DELETE', 'bookmarks/\\d+'):
     $bookmarks = new Bookmarks($db, $user);
All Usage Examples Of Blocked::create