public function editTopicBody() { $connection = Connection::getConnection(); $query = $connection->prepare("UPDATE topic SET body = :body WHERE id = {$this->id}"); $query->bindValue(':body', $this->body, \PDO::PARAM_STR); $query->execute(); }
private function getDataArr() { $connection = Connection::getConnection(); $query = $connection->prepare('SELECT * FROM users WHERE username = :username'); $query->bindValue(':username', $this->username, \PDO::PARAM_STR); $query->execute(); $this->arr = $query->fetch(); }
private function getUserTopics() { $connection = Connection::getConnection(); $query = $connection->prepare("SELECT id,title FROM topic WHERE user_id = :id"); $query->bindValue(':id', $this->id, \PDO::PARAM_INT); $query->execute(); $this->data['topics'] = $query->fetchAll(); }
public function getComments() { $connection = Connection::getConnection(); $query = $connection->prepare("SELECT comments.id, body, parent_id,user_id,topic_id,date,username FROM comments JOIN users ON comments.user_id=users.id WHERE topic_id = '{$this->topic_id}'"); $query->execute(); $this->data = $query->fetchAll(); return json_encode($this->data, JSON_UNESCAPED_UNICODE); }
private function getSearchList() { $connection = Connection::getConnection(); foreach ($this->regExpArray as $value) { $query = $connection->prepare("SELECT * FROM topic WHERE ucase(title) RLIKE ucase(:regulexp)"); $query->bindParam(':regulexp', $value, \PDO::PARAM_STR); $query->execute(); $this->searchResultArray = $query->fetchAll(); // Оставлю пока вывод только самых популярных результатов поиска. Когда будет много результатов, можно сделать расширенным. } }
public function checkUsername() { $connection = Connection::getConnection(); $query = $connection->prepare('SELECT username FROM users WHERE username = :username'); $query->bindParam(':username', $this->username, \PDO::PARAM_STR); $query->execute(); $row_count = $query->fetch(); if ($row_count == 0) { return TRUE; } $this->message = 'Вообще тут уже есть тело под логином ' . $this->username . ', ┌( ಠ‿ಠ)┘, придумай чего-нибудь другое (。◕‿◕。)'; return false; }