public function savePage() { $page_id = sanitize($_POST['pageId']); $page_js = htmlentities($_POST['pageJS']); $page_content = htmlentities($_POST['pageContent']); $dbh = new PDO("mysql:host=" . $GLOBALS['db_host'] . ";dbname=" . $GLOBALS['db_db'], $GLOBALS['db_user'], $GLOBALS['db_pass']); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $stmt = $dbh->prepare("select * from pages where PageID = :pageId and PageContent = :pageContent"); $stmt->execute(array('pageId' => $page_id, "pageContent" => $page_content)); if ($stmt->rowCount()) { // Already exists! echo json_error_msg("Already exists"); } else { $stmt = $dbh->prepare("update pages set PageContent = :pageContent, PageJS = :pageJS where PageID = :pageId"); $stmt->execute(array("pageContent" => $page_content, "pageJS" => $page_js, "pageId" => $page_id)); if ($stmt->rowCount()) { echo json_success_msg("Page Saved Sucessfully"); } else { echo json_error_msg("Page NOT Saved Sucessfully"); } } }
public function logout() { session_start(); unset($_SESSION); $_SESSION['userID'] = null; $_SESSION['userAdminStatus'] = null; session_destroy(); echo json_success_msg("You have sucessfully been logged out!" . $_SESSION['userID']); }