public function makeSql($sql) { $wordsModel = new WordsModel(); if ($this->category !== 'all' && $this->type === 'all') { $sql .= " WHERE a.category_id = '" . $wordsModel->getCategoryId($this->category) . "'"; } else { if ($this->category === 'all' && $this->type !== 'all') { $sql .= " WHERE a.type_id = '" . $wordsModel->getTypeId($this->type) . "'"; } else { if ($this->category !== 'all' && $this->type !== 'all') { $sql .= " WHERE a.category_id = '" . $wordsModel->getCategoryId($this->category) . "'"; $sql .= " AND a.type_id = '" . $wordsModel->getTypeId($this->type) . "'"; } } } $sql .= " ORDER BY a.word_id"; return $sql; }