mcnairrobotics
commented
12 months ago `<?php include 'connection.php'; include 'sessions.php'; include 'navbar.php'; if((key_exists("username", $_POST) && key_exists("password", $_POST)) || !empty($_SESSION['Uname'])) { //test connecting //query is the sql statement that runs if(empty($_SESSION['Uname'])) { $uname = $_POST["username"]; }else { $uname = $_SESSION['Uname']; } $query = "SELECT * FROM users WHERE username = :uname;"; //the database you got earlier, run that sql command $statement = $pdo->prepare($query); $statement->execute(['uname' => $uname]); $member = $statement->fetch(); if(is_null($member['fname'])) { header("Location: login.php"); die();
}
$_SESSION['Uname'] = $uname;
$_SESSION['Fullname'] = $member["fname"] . " " . $member["lname"];
echo "<br> <h1> Welcome " . $member["fname"] . " " . $member["lname"] . "</h1>";
echo '<div class="image-container"><img src="image/' . $member["image"] . '" alt="Profile Picture"></div>';
}else{
//echo($_SESSION['Uname']);
header("Location: login.php");
die();
}?> <!DOCTYPE html>
<?php include 'connection.php'; include 'sessions.php'; include 'navbar.php'; if((key_exists("username", $_POST) && key_exists("password", $_POST)) || !empty($_SESSION['Uname'])) { //test connecting //query is the sql statement that runs if(empty($_SESSION['Uname'])) { $uname = $_POST["username"]; }else { $uname = $_SESSION['Uname']; } $query = "SELECT * FROM users WHERE username = :uname;"; //the database you got earlier, run that sql command $statement = $pdo->prepare($query); $statement->execute(['uname' => $uname]); $member = $statement->fetch(); if(is_null($member['fname'])) { header("Location: login.php"); die();
?> <!DOCTYPE html>