public static function GetBlogsByState($state) { $retval = array(); //get all posts $posts = PostFactory::GetAllPosts(); //then filter //unpublished foreach ($posts as $post) { if ($state == 'unpublished') { if (isset($post->UnpublishDate) && $post->UnpublishDate > $post->PublishDate) { array_push($retval, $post); } } else { if ($state == 'notpublished') { if (isset($post->PublishDate) == FALSE) { array_push($retval, $post); } } else { if ($state == 'outdated') { if (isset($post->PublishDate) && $post->ModifiedDate > $post->PublishDate) { array_push($retval, $post); } } } } } return $retval; }
$retval = PostFactory::GetPost($postid); } else { $retval = PostFactory::NewPost(); } MySQLConnection::Close($GLOBALS['mysqli']); echo json_encode($retval); }); $app->get('/getallposts', function () { require_once 'common/dbconnection.php'; require_once 'category.php'; require_once 'post.php'; require_once 'posttype.php'; require_once 'userresponse.php'; require_once 'userreply.php'; $GLOBALS['mysqli'] = MySQLConnection::Open(); $retval = PostFactory::GetAllPosts(); MySQLConnection::Close($GLOBALS['mysqli']); echo json_encode($retval); }); $app->get('/deletepost/:postid', function ($postid) { require_once 'common/dbconnection.php'; require_once 'category.php'; require_once 'post.php'; require_once 'userresponse.php'; require_once 'userreply.php'; $GLOBALS['mysqli'] = MySQLConnection::Open(); $blogPost = PostFactory::GetPost($postid); $blogPost->Delete(); $ret_val['deletedpostid'] = $blogPost->ID; $ret_val['success'] = 'Blog post deleted'; MySQLConnection::Close($GLOBALS['mysqli']);