dbCMS.php
Source of dbCMS.php
<!DOCTYPE html>
<html lang = "en-US">
<head>
<meta charset = "UTF-8">
<title>CS Basic CMS</title>
<link rel = "stylesheet"
type = "text/css"
href = "csStd.css" />
</head>
<?php
//get pageID from request if possible
//note this is a get request, for flexibility
$pageID = filter_input(INPUT_GET, "pageID");
if ($pageID == ""){
$pageID = 1;
} // end if
try {
//connect to database
$con= new PDO('mysql:host=localhost;dbname=dbName', "user", "pwd");
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//read current page information from the db
$stmt = $con->prepare("SELECT * FROM pageView WHERE PageID = ?");
$stmt->execute(array($pageID));
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
//make page variables based on the current record
foreach ($result as $row){
if ($row["block"] == "head"){
$head = $row["title"];
} else if ($row["block"] == "menu"){
$menu = $row["content"];
} else if ($row["block"] == "content1"){
$c1Title = $row["title"];
$c1Text = $row["content"];
} else if ($row["block"] == "content2"){
$c2Title = $row["title"];
$c2Text = $row["content"];
} else if ($row["block"] == "footer"){
$footer = $row["content"];
} // end if
} // end foreach
} catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
} // end try
?>
<body>
<div id = "all">
<!-- This div centers a fixed-width layout -->
<div id = "heading">
<h1>
<?php print $head; ?>
</h1>
</div><!-- end heading div -->
<div id = "menu">
<?php print $menu; ?>
</div> <!-- end menu div -->
<div class = "content">
<h2>
<?php print $c1Title; ?>
</h2>
<div>
<?php print $c1Text; ?>
</div>
</div> <!-- end content div -->
<div class = "content">
<h2>
<?php print $c2Title; ?>
</h2>
<div>
<?php print $c2Text; ?>
</div>
</div> <!-- end content div -->
<div id = "footer">
<?php print $footer; ?>
</div> <!-- end footer div -->
</div> <!-- end all div -->
</body>
</html>