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());
}
}
}
}
* 1.) You can retrieve all of the results in an array.
* - Create a variable to hold the results and call retrieve().
* 2.) You can retrieve only results from one row.
* - Create a variable to hold results, call retrieve()
* and pass the row number (indexed 0-i).
* 3.) You can omit certain fields from the result.
* - Create an array of the columns you would like to omit.
* then call the ignore method with the array of omitted columns.
*
* To display results, create a variable to hold the result from the
* retrieve method. Next create a variable to hold the array of rows
* that is returned from the get rows method. Create a nested foreach
* loop, the inner loop will give access to the column name and its value.
*
*/
$db->setTable("test1");
$result = $db->retrieve();
/* Obtain all results from a table.
* Print all fields with thier value.
*/
$tableRows = $result->getRow();
// Gets all rows from table
foreach ($tableRows as $row) {
foreach ($row as $field => $value) {
echo $field . " => " . $value . "</br>";
}
}
/* Obtain results from certain row in table.
* Print all fields with thier value.
*/
$tableRow = $result->getRow(0);
<?php
/**
* Created by PhpStorm.
* User: Rimas
* Date: 1/27/2016
* Time: 12:03 AM
*/
require 'config.php';
require 'autoload.php';
if (!empty($_POST)) {
$validator = new Validator();
if ($validator->validateName($_POST['name']) && $validator->validateName($_POST['password'])) {
$database = new Database();
if ($database->Connect($servername, $dbname, $username, $password)) {
$database->setTable('users');
$data = $database->GetDataWhere('name', $_POST['name']);
$database->Close();
}
if ($data) {
foreach ($data as $row) {
if ($row['password'] === hash('sha256', $_POST['password'])) {
session_start();
$_SESSION['username'] = $_POST['name'];
header("Location: admin.php");
} else {
echo "Incorrect password";
}
}
} else {
echo "Incorrect name";
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/globalConfig.php';
//$db = new Database("107.180.51.84","fcncContent","Fcnc@915","fcncContent");
$db = new Database("localhost", "root", "root", "FCNC_v3.0");
$db->setTable('contentTiles');
// Return a select input with the name of all pages on website
if (isset($_GET['getPagenameList'])) {
$response = "";
$pageNames = getPageNames($db);
foreach ($pageNames as $pageName) {
$response .= "<option name='{$pageName}'>{$pageName}</option>";
}
echo $response;
}
// Return an editable content tiles
if (isset($_GET['getPageTiles'])) {
$response = '';
$results = $db->retrieve();
$tableRow = $results->getRow();
$tileArray = array();
// Get tiles assocaited with given page
foreach ($tableRow as $tile) {
if ($tile['pageName'] == $_GET['pageName']) {
array_push($tileArray, $tile);
}
}
// Sort Tiles by tileOrder
//uasort($tileArray, 'sortByTileOrder');
echo json_encode($tileArray);
}
and open the template in the editor.
-->
<?php
require_once 'CMS/CMSComponents.php';
require_once 'HTML/formbuilder.php';
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<?php
$db = new Database("fcncmaindb.db.6441590.hostedresource.com", "fcncmaindb", "FCnc915", "fcncmaindb");
$array = array(new column('pageName', 'varchar', 255), new column('category', 'varchar', 255), new column('tags', 'varchar', 255), new column('type', 'varchar', 255), new column('headImage', 'varchar', 255), new column('headText', 'varchar', 255), new column('body', 'varchar', 7000));
//$db->createTable('pages',$array);
$array1 = array('admission information', 'info', '', 'page', '/images/test.png', 'Test Image Text', 'Some text for the main info page.');
$db->setTable('pages');
//$db->insert($array1);
//$db->remove('id', '2');
$db->displayDatabase();
?>
</body>
</html>
