/**
* Search for blog posts based on the requested searchTerm
*/
public function indexAction()
{
//save Request variable searchTerm
$searchTerm = $this->Request()->searchTerm;
$sql = "SELECT * FROM post WHERE headline like :value OR content like :value";
$this->View()->posts = Blog()->Db()->fetchAll($sql, array("value" => "%" . $searchTerm . "%"));
//just to highlight the current menu
$this->View()->activeMenu = $this->Request()->getControllerName();
}
/**
* Will be called by default if no other action is called.
* Reads all blog posts order by creation date
*/
public function indexAction()
{
$sql = "SELECT * FROM post ORDER BY creation_date DESC ";
$posts = Blog()->Db()->fetchAll($sql);
//allocates all posts to the view so you can access them via smarty
$this->View()->posts = $posts;
//just to highlight the current menu
$this->View()->activeMenu = $this->Request()->getControllerName();
}
/**
* Will be called by default if no other action is called.
* Reads the blog post with the requested postID from the db and
* reads different three blog posts to teaser them
*/
public function indexAction()
{
//save Request variable postID
$postId = intval($this->Request()->postID);
$sql = "SELECT * FROM post WHERE id = ?";
$post = Blog()->Db()->fetchRow($sql, array($postId));
//allocates all posts to the view so you can access them via smarty
$this->View()->post = $post;
$sql = "SELECT * FROM post WHERE id != ? ORDER by creation_date LIMIT 3 ";
$posts = Blog()->Db()->fetchAll($sql, array($postId));
$this->View()->teaserPosts = $posts;
}
/**
* updates the blog post based on the request data
* @return JsonData success message
*/
public function deletePostAction()
{
$postID = $this->Request()->id;
$sql = "DELETE FROM `post` WHERE `id` = ?";
Blog()->Db()->query($sql, $postID);
echo Zend_Json::encode(array('success' => true));
}
