Display current logged in user's profile

Question

I've been working on code for student registration. I finished coding for my log in.

What I'm having a problem with is showing the user's profile: student fname, lname, program, gender and year level in textboxes. I'm using MySQL as my back end.

My code is like this:

<?php 

// connects to the database
$mysqli = new mysqli("localhost", "root", "");

$query = 'SELECT fname, lname, program, gender, year FROM students WHERE fname =     '.$_SESSION['myusername'];
$mysqli->query($query);


echo "<div align=\"center\">";
echo "<br />Your <b><i>Profile</i></b> is as follows:<br />";
echo "<b>First name:</b> ". $_POST['fname'];
echo "<br /><b>Last name:</b> ".$_POST['lname'];
echo "<br /><b>Program:</b> ".$_POST['program'];
echo "<br /><b>Year:</b> ".$_POST['year'];
echo "<br /><b>Gender:</b> ".$_POST['gender'];
echo "</div>";
?>

This is my code for mainstudent.php and checklogin.php.

Answer 1

Here you go:

<?php 
session_start();

// connects to the database
$mysqli = new mysqli("localhost", "root", "");

$query = "SELECT fname, lname, program, gender, year FROM students WHERE fname = '".$_SESSION['myusername']."'";
if($result = $mysqli->query($query))
{
    while($row = $result->fetch_assoc())
    {
        echo "<div align=\"center\">";
        echo "<br />Your <b><i>Profile</i></b> is as follows:<br />";
        echo "<b>First name:</b> ". $row['fname'];
        echo "<br /><b>Last name:</b> ".$row['lname'];
        echo "<br /><b>Program:</b> ".$row['program'];
        echo "<br /><b>Year:</b> ".$row['year'];
        echo "<br /><b>Gender:</b> ".$row['gender'];
        echo "</div>"   
    }
    $result->free();
}
else
{
    echo "No results found";
}
?>

Answer 2

please add your password in session as well