function renderEmployeePageContent($pageName) { //$db = new Database("107.180.51.84","fcncContent","Fcnc@915","fcncContent"); $db = new Database("localhost", "root", "root", "FCNC_v3.0"); $db->setTable("employeePages"); // If varables have not been set, display the home page if ($pageName == '') { $queryString = ['pageName' => 'home']; $pageTileResults = $db->retrieveStrict($queryString); displayContent($pageTileResults->getRow()); } else { $queryString = ['pageName' => $pageName]; $pageTileResults = $db->retrieveStrict($queryString); displayContent($pageTileResults->getRow()); } }
function displayPageContent($category, $pageName) { //$db = new Database("107.180.51.84","fcncContent","Fcnc@915","fcncContent"); $db = new Database("localhost", "root", "root", "FCNC_v3.0"); $db->setTable("contentTiles"); // If varables have not been set, display the home page if ($category == '' && $pageName == '') { $queryString = ['category' => 'index', 'pageName' => 'index']; $pageTileResults = $db->retrieveStrict($queryString); displayHTML($pageTileResults->getRow()); } else { if (isset($category)) { //error check if category and pageName exitst!!!!! $queryString = ['category' => $category, 'pageName' => $pageName]; $pageTileResults = $db->retrieveStrict($queryString); // This can probably be cleaned up // if page exists display it // else display 404 error page if (pageExists(count($pageTileResults->getRow()))) { displayHTML($pageTileResults->getRow()); } else { display404Error($db); } } else { //error check if pageName does not exist!!!!! $queryString = ['category' => "", 'pageName' => $pageName]; $pageTileResults = $db->retrieveStrict($queryString); if (count($pageTileResults->getRow()) == 0) { // Page not found... display 404 error page $queryString['pageName'] = '404'; $pageTileResults = $db->retrieveStrict($queryString); displayHTML($pageTileResults->getRow()); } else { displayHTML($pageTileResults->getRow()); } } } }