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');
}
}
