How to make a PHP show user data from database?

Question

I made a login system, how do I make it show the username after login, so it goes like on the main login screen -> database check -> success page. On this success page how do I make it show the username, that was registered? I have only added

<?php
session_start();
if(!session_is_registered(myusername)){
header("location:main_login.php");
}
?>

On the 3rd page which is the success page, I need it to show the username that has logged on and other user information from the table.

Go see this question: http://stackoverflow.com/questions/14208369/retrieve-data-from-mysql-using-php — freddy, Dec 06 '13 at 05:47
Once the session variable is stored, you can read it on any page with a little php like - $userid = $_SESSION['useridentifier']. — TimSPQR, Dec 06 '13 at 05:50

R R · Answer 1 · 2013-12-06T05:52:39.457

1

you need to store the username in the session variable then after successful login display it. you can use isset() to serve that purpose to check whether the session variable is set or not.

<?php
    session_start();
    echo $_SESSION['username'];
?>

edited Dec 06 '13 at 05:52

answered Dec 06 '13 at 05:47

R R

2,999
2
24
42

1

Dont forget to call session_start(); first – Johnny Harlamert Dec 06 '13 at 05:48
@JohnnyHarlamert thanks for that but i thought that was obvious :) – R R Dec 06 '13 at 05:50
1

For you and I, but not for someone who asked how to read a session variable – Johnny Harlamert Dec 06 '13 at 05:52
@JohnnyHarlamert ya totally agree :) +1 – R R Dec 06 '13 at 05:53
Hi, do you have skype? So i can send you the database check and it will be easier for me, thanks. My skype is ashwindc. – user3073168 Dec 06 '13 at 05:57
i am not in skype but i am in gmail send me at rishabhraj51@gmail.com – R R Dec 06 '13 at 05:58
i think shankar damodaran has modified your code ,you can take an idea from that also. – R R Dec 06 '13 at 05:58

score 0 · Answer 2 · answered Dec 06 '13 at 05:48

0

Something like this will do

<?php
session_start();
if(isset($_SESSION['myusername'])){
    echo "Welcome ".$_SESSION['myusername'];
}
else
{
   header("location:main_login.php");
}
?>

And don't use session_is_registered() as it is Deprecated.

answered Dec 06 '13 at 05:48

Shankar Narayana Damodaran

68,075
43
96
126

score 0 · Answer 3 · answered Dec 06 '13 at 06:06

Once you successfully logged in then store the username in the session variable. On the page first check whether session is set then show the username else redirect the user to login page.

 <?php
session_start();
if(isset($_SESSION['myusername']) && $_SESSION['myusername'] != ''){
      echo $_SESSION['myusername'];
}else{
      header("location:main_login.php");
}
?>

score 0 · Answer 4 · answered Dec 06 '13 at 09:32

<?php
     session_start();
     //if using post method in login it is better to check if $_POST is set
     $username = $_POST['myusername'];
     if(isset($_POST['myusername'])){
      if(!empty($username)){
       if(isset($_SESSION['myusername'])){
        echo $_SESSION['myusername'];
       }
      }
     }
 ?>

You can provide security by checking if your login details are not empty.

How to make a PHP show user data from database?

4 Answers4