public static function getActiveCSS()
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM CSSTemplates WHERE ActiveState=1;";
$results = mysqli_query($db, $query);
$row = mysqli_fetch_assoc($results);
$activeCSSTemplate = new self($row);
dbConnect::closeConnection($db);
return $activeCSSTemplate;
}
public function execute($sql)
{
$exe = mysql_query($sql, $this->_connAccess->getConnection());
if (!$exe) {
exit('Error : ' . mysql_error() . ':' . $sql);
} else {
return $exe;
dbConnect::closeConnection();
}
}
public static function getContentArea()
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM ContentAreas;";
$results = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($results)) {
$contentAreas[] = new self($row);
}
//end while
dbConnect::closeConnection($db);
return $contentAreas;
}
protected function _getQuery()
{
if (!$this->_query) {
$this->_conn = dbConnect::getConnection();
$this->_query = mysql_query($this->_sql, $this->_conn);
if (!$this->_query) {
print 'Error : ' . mysql_error() . ' ' . $this->_sql;
}
}
return $this->_query;
dbConnect::closeConnection();
}
public static function getAllPages($_alias)
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM SitePages;";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($result)) {
$pages[] = new self($row);
}
//end while
dbConnect::closeConnection($db);
return $pages;
}
public static function getArticle($_area, $_page)
{
$db = dbConnect::getReadOnly();
$query = "SELECT * FROM Articles WHERE (Page='{$_page}' OR AllPages=1) AND ContentArea = '{$_area}';";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_assoc($result)) {
$articleArray[] = new self($row);
}
//end while
dbConnect::closeConnection($db);
return $articleArray;
}
<html>
<head>
<h1>Content Area Created:</h1>
</head>
<body>
<?php
include_once "../DataAccess/dbConnect.php";
$db = dbConnect::getContentAreaConnection();
$name = mysqli_real_escape_string($db, $_POST['Name']);
$alias = mysqli_real_escape_string($db, $_POST['Alias']);
$order = mysqli_real_escape_string($db, $_POST['Order']);
$description = mysqli_real_escape_string($db, $_POST['Description']);
$query = "INSERT INTO ContentAreas (Name, Alias, ContentAreas.Order, Description, CreatedBy) ";
$query .= "VALUES ('{$name}', '{$alias}', '{$order}', '{$description}', 1)";
$result = mysqli_query($db, $query);
if (!$result) {
die('Unable to insert Content Area into CMS Database.');
}
?>
<p>Successfully Inserted <?php
echo mysqli_affected_rows($db);
?>
record.</p>
<?php
dbConnect::closeConnection($db);
?>
<a href="../Presentation/manageContentAreas.php">Back to Manage Content Areas page</a>
</body>
</html>
