</tbody> </table> </div> </div> </div> <?php } else { ?> <div class="row"> <div class="panel" style="position: static;"> <div class="panel-header"> <h3 class="panel-title"><i class="fa fa-exclamation-circle"></i> User not found</h3> </div> <div class="panel-content"> <?php drawError("<i class=\"fa fa-exclamation-circle\"></i> User not found in the database."); ?> </div> </div> </div> <?php } ?> <?php } elseif (strtolower($_GET['action']) == "userlist") { ?> <div class="row"> <div class="panel" style="position: static;"> <div class="panel-header"> <h3 class="panel-title"><i class="fa fa-bar-chart"></i> User statistics</h3> </div>
$_SESSION['user_id'] = $userID; $_SESSION['loggedInUser'] = $user; $_SESSION['is_admin'] = $isAdmin; //Record user login time. $link = mysqli_connect("host_name", "username", "password", "database") or die("Database connection failed - " . mysqli_error($link)); $sql = "INSERT INTO userLoginTimes( userID ) VALUES ( ( SELECT userID FROM user WHERE userName = ? ) ) "; if ($stmt = mysqli_prepare($link, $sql)) { $user = $_SESSION['loggedInUser']; mysqli_stmt_bind_param($stmt, "s", $user) or die("bind param"); mysqli_stmt_execute($stmt); } else { die("MySQLi prepare failed"); } mysqli_stmt_close($stmt); mysqli_close($link); header('Location: ./'); } else { drawError("Invalid username/password combination"); } } } ?> <div class="ui message">Need an account? <a href="register.php">Register here</a><hr/> <p>Having trouble logging in? <a href="password_reset.php">Reset your password</a>.</p> </div> </div> </div> </body> </html>