MySQLConnection::Close($GLOBALS['mysqli']);
echo json_encode($retval);
});
$app->get('/getcategorylist/', function () {
require_once 'common/dbconnection.php';
$GLOBALS['mysqli'] = MySQLConnection::Open();
require_once 'category.php';
$retval = CategoryFactory::GetCategories();
MySQLConnection::Close($GLOBALS['mysqli']);
echo json_encode($retval);
});
$app->get('/getpublishedcategorylist/', function () {
require_once 'common/dbconnection.php';
$GLOBALS['mysqli'] = MySQLConnection::Open();
require_once 'category.php';
$retval = CategoryFactory::GetPublishedCategories();
MySQLConnection::Close($GLOBALS['mysqli']);
cors();
echo json_encode($retval);
});
$app->get('/getcategoryblogs/:categoryid', function ($categoryid) {
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::GetBlogsByCategory($categoryid);
MySQLConnection::Close($GLOBALS['mysqli']);
echo json_encode($retval);
