public function getSingleArticle($articleIdIn)
{
$myDataAccess = DataAccessMySQLi::getInstance();
$myDataAccess->getDBConn();
$myDataAccess->getSingleArticle($articleIdIn);
$row = $myDataAccess->fetchArticles();
$currentArticle = new self($myDataAccess->fetchArticleName($row), $myDataAccess->fetchArticleTitle($row), $myDataAccess->fetchArticleContent($row));
$currentArticle->articleId = $myDataAccess->fetchArticleID($row);
$currentArticle->desc = $myDataAccess->fetchArticleDesc($row);
$currentArticle->allPages = $myDataAccess->fetchArticleAllPages($row);
$currentArticle->pageOn = $myDataAccess->fetchArticlePage($row);
$currentArticle->divContainer = $myDataAccess->fetchArticleContentArea($row);
$myDataAccess->closeDBConn();
return $currentArticle;
}
public function updateTemplate()
{
$myDataAccess = DataAccessMySQLi::getInstance();
$myDataAccess->getDBConn();
$rowsAffected = $myDataAccess->updateCss($this->cssId, $this->cssName, $this->desc, $this->active, $this->theContent);
$myDataAccess->closeDBConn();
return $rowsAffected . " row(s) Affected.";
}
public function updateDiv()
{
$myDataAccess = DataAccessMySQLi::getInstance();
$myDataAccess->getDBConn();
$rowsAffected = $myDataAccess->updateDiv($this->contentId, $this->contentName, $this->divName, $this->desc, $this->pgOrder);
$myDataAccess->closeDBConn();
return $rowsAffected . " row(s) affected.";
}
public function getSinglePage($pageIdIn)
{
$myDataAccess = DataAccessMySQLi::getInstance();
$myDataAccess->getDBConn();
$myDataAccess->getSinglePage($pageIdIn);
$row = $myDataAccess->fetchPages();
$currentPage = new self($myDataAccess->fetchPageName($row), $myDataAccess->fetchPageWebName($row));
$currentPage->pageId = $myDataAccess->fetchPagePageId($row);
$currentPage->desc = $myDataAccess->fetchPageDescription($row);
$currentPage->activeCSS = $myDataAccess->fetchPageActiveCss($row);
$myDataAccess->closeDBConn();
return $currentPage;
}
public function checkLoginInfo($userIn, $pwIn)
{
$myDataAccess = DataAccessMySQLi::getInstance();
$myDataAccess->getDBConn();
$myDataAccess->checkUserLogin($userIn, $pwIn);
$row = $myDataAccess->fetchUsers();
$currentUser = new self($myDataAccess->fetchUUserName($row));
$currentUser->userID = $myDataAccess->fetchUUserID($row);
$currentUser->userFirstName = $myDataAccess->fetchUUserFName($row);
$currentUser->userLastName = $myDataAccess->fetchUUserLName($row);
$currentUser->wordPass = $myDataAccess->fetchUWordPass($row);
$currentUser->creator = $myDataAccess->fetchUCreator($row);
$currentUser->createDate = $myDataAccess->fetchUCreateDate($row);
$currentUser->modBy = $myDataAccess->fetchUModified($row);
$currentUser->modDate = $myDataAccess->fetchUModDate($row);
$myDataAccess->closeDBConn();
return $currentUser;
}
public function deleteUser()
{
$myDataAccess = DataAccessMySQLi::getInstance();
$myDataAccess->getDBConn();
$rowsAffected = $myDataAccess->deleteUser($this->userID);
return $rowsAffected . " row(s) affected";
}
