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 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;
}
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;
}
<head>
<title> </title>
</head>
<body>
<form action="admin.php">
<input type="submit" value="Return To Admin" />
</form>
<p>Manage Users</p>
<table border = "1">
<th>User ID</th><th>First Name</th><th>Last Name</th><th>Username</th>
<th>Created By:</th><th>Creation Date:</th><th>Modified By:</th><th>Modify Date:</th>
<?php
include_once "../DataAccess/dbConnect.php";
$db = dbConnect::getReadOnly();
$result = mysqli_query($db, "SELECT * FROM Users ORDER BY User_ID ASC");
while ($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td><?php
echo strip_tags($row['User_ID']);
?>
</td>
<td><?php
echo strip_tags($row['first_name']);
?>
</td>
<td><?php
echo strip_tags($row['last_name']);