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; }