public static function DisplayUnitAccess($result)
{
$rows = count($result, 0);
$unitDetails = null;
$table = "";
if ($rows == 0) {
$table = "<h3>No entries have been found</h3>";
} else {
$table = "<table class=\"loginTable\">\n";
$table .= "<tr>\n";
$table .= "<th>#ID</th>\n";
$table .= "<th>Name</th>\n";
$table .= "<th>Unit</th>\n";
$table .= "<th>Lesson</th>\n";
$table .= "<th>Date</th>\n";
$table .= "<th>Time</th>\n";
$table .= "<th>IP</th>\n";
//$table .= "<th>More</th>\n";
$table .= "</tr>\n";
for ($i = 0; $i < $rows; $i++) {
$unitDetails = DBAccess::unitByUnitID($result[$i]['UnitID']);
$userDetails = DBAccess::userDetailsFromUserID($result[$i]['UserID']);
$lessonDetail = DBAccess::lessonByLessonID($result[$i]['LessonID']);
$table .= "<tr>\n";
$table .= "<td>" . $result[$i]['RecordID'] . "</td>\n";
$table .= "<td>" . $userDetails[0]['LastName'] . ", " . $userDetails[0]['FirstName'] . "</td>\n";
$table .= "<td>" . $unitDetails[0]['UnitName'] . "</td>\n";
$table .= "<td>" . $lessonDetail[0]['LessonCode'] . " - " . $lessonDetail[0]['LessonName'] . "</td>\n";
$table .= "<td>" . $result[$i]['Date'] . "</td>\n";
$table .= "<td>" . $result[$i]['Time'] . "</td>\n";
$table .= "<td><a href=\"http://whatismyipaddress.com/ip/" . $result[$i]['IP'] . "\">" . $result[$i]['IP'] . "</a></td>\n";
//$table .= "<td><button type=\"button\" onclick=\"window.location = './userDetails.php?userID=" . $result[$i]['UserID'] . "'\">More Detail</button></td>\n";
$table .= "</tr>\n";
}
$table .= "</table>\n";
}
return $table;
}
