public static function readFirst($myID) { $db = Database::getInstance(); $query = $db->prepare("SELECT * FROM messages WHERE recipientid = ? ORDER BY readflag DESC "); $query->execute([$myID]); return $query; }
public static function isBlocked($fromID, $toID) { $db = Database::getInstance(); $query = $db->prepare('SELECT resctrictionid FROM restrictions WHERE (fromid = ? AND toid = ?)'); $query->execute([$fromID, $toID]); return $query->fetch()['resctrictionid']; }
public static function checksNewRequests($myID) { $db = Database::getInstance(); $query = $db->prepare('SELECT * FROM requests WHERE toid = ?'); $query->execute([$myID]); return $query; }
public static function getNumberOfComments($id) { $db = Database::getInstance(); $query = $db->prepare("SELECT COUNT(tweetid) AS n FROM tweetcomments WHERE tweetid = ?"); $query->execute([$id]); return $query->fetch()['n']; }
public static function getUserGalleries($userid) { $db = Database::getInstance(); $query = $db->prepare("SELECT * FROM gallery WHERE userid = ?"); $query->execute([$userid]); return $query->fetchAll(); }
public static function postComment(PhotoComment $comment) { $db = Database::getInstance(); $query = $db->prepare('INSERT INTO photocomments (photoid,userid,content) VALUES (?, ?, ?)'); $query->execute([$comment->getPhotoid(), $comment->getUserid(), $comment->getContent()]); }
public static function unfriend($firstID, $secondID) { $db = Database::getInstance(); $query = $db->prepare('DELETE FROM friends WHERE (user1 = ? AND user2 = ?) OR (user1 = ? AND user2 = ?)'); $query->execute([$firstID, $secondID, $secondID, $firstID]); }
public static function showInUsersList($userid) { $db = Database::getInstance(); $query = $db->prepare('UPDATE users SET visibility = 1 WHERE userid = ?'); $query->execute([$userid]); }
public static function getAllPhotos() { $db = Database::getInstance(); $query = $db->prepare('SELECT * FROM photo'); $query->execute(); return $query; }