public function searchPost($searchtext) { if (!empty($searchtext)) { $sql = "SELECT * FROM posts\n WHERE MATCH (title)\n AGAINST ('" . $searchtext . "' IN NATURAL LANGUAGE MODE)"; } else { $sql = "SELECT * FROM posts "; } $query = mysqli_query($this->con, $sql); $postArray = array(); // var_dump($query); // exit; if ($query) { while ($row = mysqli_fetch_assoc($query)) { $myPost = new BlogPostModel(); $myPost->setId($row['id']); $myPost->setTitle($row['title']); $myPost->setSummary($row['body']); $myPost->setDateCreated($row['created']); array_push($postArray, $myPost); } return $postArray; } else { header('Location: ?action=search'); } }