Displaying data from mysql database in webpage using session

Question

I simply need to display data from a mysql database. All the data is already stored in the database when the user submits the form. So in the landing page after the user is logged in, I need to display the users full name as well as a few other columns from the database table. In essence, I want the page to say Welcome fullname, then display some other colums from the database in a table. How should I code this using session? NOTE: I have tried to use sessions to display the user's full name and current balance after logging in. My code below:

<?php
    // Connect to database display welcome Full name, then date, name, credit, debit, balance
    session_start();
    $fullname="";

    $currentbalance="";
    if (!isset($_SESSION)){
    session_start();
    }
    echo $_SESSION['fullname'];


    ?>
    Welcome <?php echo $_SESSION['fullname']; ?>.
    <table border ="1">
    <th>DATE </th>
    <th>'.$fullname.' </th>
    <th>CREDIT </th>
    <th>DEBIT</th>
    <th><?php echo $_SESSION['currentbalance']; ?</th>
    </table>

you need to assigned value to variable $_SESSION['fullname'] = $fullname and before using it you need to start the session — M.I.T.
– M.I.T., Commented Mar 5, 2013 at 8:20

Devang Rathod · Accepted Answer · 2013-03-05 08:23:11Z

2

When you logged in you need to store fullname in session like

$_SESSION['fullname'] = $_REQUEST['fullname'];

After login , you can get this fullname on homepage.

$session_name = $_SESSION['fullname'];

answered Mar 5, 2013 at 8:23

Devang Rathod

6,7342 gold badges25 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

deviloper · Accepted Answer · 2013-03-05 08:26:31Z

1

<?php
    // Connect to database display welcome Full name, then date, name, credit, debit, balance
    if (!isset($_SESSION)){
    session_start();
    }
    $fullname="";
    $currentbalance="";

    $_SESSION['fullname']=$fullname;
$_SESSION['currentbalance ']=$currentbalance ; // Where $fullname and $currentbalance must be already defined by the query


    ?>
    Welcome <?php echo $_SESSION['fullname']; ?>.
    <table border ="1">
    <th>DATE </th>
    <th>'.$fullname.' </th>
    <th>CREDIT </th>
    <th>DEBIT</th>
    <th><?php echo $_SESSION['currentbalance']; ?</th>
    </table>

answered Mar 5, 2013 at 8:26

deviloper

7,25210 gold badges52 silver badges79 bronze badges

Comments

Tapas Pal · Accepted Answer · 2013-03-05 08:21:58Z

0

During login just store the user id into session, so you could easily got all the information from database by this user id.

"select * from `users` where id='".$_SESSION['userid']."'"

answered Mar 5, 2013 at 8:21

Tapas Pal

7,2578 gold badges45 silver badges90 bronze badges

2 Comments

Kaos Over a year ago

Ok, but how do I store the user id into session?Because the user's full name is only supposed to be displayed after log in

Tapas Pal Over a year ago

If you'r about show the full name only then store the full name in session.

Tomasz Kowalczyk · Accepted Answer · 2014-07-12 15:13:07Z

0

use this code, you put the session in curly braces.

"select * from `users` where id={$_SESSION['userid']}"

edited Jul 12, 2014 at 15:13

Tomasz Kowalczyk

10.5k6 gold badges56 silver badges70 bronze badges

answered Jul 12, 2014 at 14:54

norbert

1

1 Comment

Tomasz Kowalczyk Over a year ago

Please use prepared statements rather than putting values directly into query.

Collectives™ on Stack Overflow

Displaying data from mysql database in webpage using session

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related