kinetskie25
-
Posts
1 -
Joined
-
Last visited
kinetskie25's Achievements
Newbie (1/5)
0
Reputation
-
I am new to PHP coding and I may have a simple problem regarding session handling. I wish yo guys could help.. I made a simple site with user login functions. User login is working good, but there is a problem with the session handling.. What I want is that when the user logs in, the message "Welcome <user's first name here> !", but I don't know how to do that part. here's my index.php: <?php session_start(); include_once('includes/connmng.php'); if (isset($_SESSION['logged_in'])){ ?> <?php $title = "SCIS - Home" ?> <html> <?php include('fragments/head.php'); ?> <body> <div id="wrapper"> <?php include('fragments/header.html'); ?> <hr> <br> <?php include('fragments/loggedin.php'); ?> <hr> <br> <?php include('fragments/nav.html'); ?> <?php include('fragments/frontcontent.php'); ?> <hr> <br> <?php include('fragments/pollsection.php'); ?> <?php include('fragments/frontsciscont.php'); ?> <?php include('fragments/fronttechcont.php'); ?> <br> <hr> <?php include('fragments/footer.html'); ?> </div> <!--wrapper --> </body> <?php include('fragments/scripts.html'); ?> </html> <?php }else{ if(isset($_POST['username'], $_POST['password'])){ $username = $_POST['username']; $password = md5($_POST['password']); if(empty($username) or empty($password)){ $error = 'All fields required!'; }else{ $query = $pdo->prepare("SELECT * FROM users WHERE username = ? AND password = ?"); $query->bindValue(1, $username); $query->bindValue(2, $password); $query->execute(); $num = $query->rowCount(); if($num == 1){ $_SESSION['logged_in'] = true; header('Location: index.php'); exit(); }else{ $error = 'You may have entered a wrong username/password.'; } } } ?> <?php $title = "SCIS - Home" ?> <html> <?php include('fragments/head.php'); ?> <body> <div id="wrapper"> <?php include('fragments/header.html'); ?> <hr> <br> <?php include('fragments/login.php'); ?> <?php if (isset($error)){ ?> <small style="color: #aa0000;"> <?php echo $error; ?> </small> <br/> <br /> <?php } ?> <hr> <br> <?php include('fragments/nav.html'); ?> <?php include('fragments/frontcontent.php'); ?> <hr> <br> <div id="preview"> <div id="center_preview"> <?php include('fragments/pollsection.php'); ?> <?php include('fragments/frontsciscont.php'); ?> <?php include('fragments/fronttechcont.php'); ?> </div> </div> <br> <hr> <?php include('fragments/footer.html'); ?> </div> <!--wrapper --> </body> <?php include('fragments/scripts.html'); ?> </html> <?php } ?> and this is my loggedin.php: <?php include_once('includes/users.php'); $user = new Users; $users = $user->fetch_all(); ?> <?php foreach ($users as $user){ ?> Welcome, <?php echo $user['firstName']?>! <?php } ?> <a href="logout.php"> Logout </a> and here's the users.php class I saw from a tutorial: <?php class Users{ public function fetch_all(){ global $pdo; $query = $pdo->prepare("SELECT * FROM users"); $query->execute(); return $query->fetchAll(); } public function fetch_data($id){ global $pdo; $query = $pdo->prepare("SELECT * FROM user WHERE id = ?"); $query->bindValue(1, $id); $query->execute(); return $query->fetch(); } } ?> as you can see, it will display the user's first name there, but it loops, so it also displays other users' first names. How can I make it only display the first name of the logged in user? *sorry for my bad english*