Display firstname after login

[adi123]

I have a login script which displays the username after login. I am trying to display the firstname but the firstname is in a different table.

 

The two tables are login and customer info, the login table containing the id, username and pass. The customer info table contains all of the customers personal info with the same id as login.

 

 

function verify_Username_and_Pass($un, $pwd) {

 

$query = "SELECT firstname

FROM login, customer_info

WHERE username = ? AND pwd = ? AND login.id = customer_info.id

LIMIT 1";

 

if($stmt = $this->conn->prepare($query)) {

$stmt->bind_param('ss', $un, $pwd);

$stmt->execute();

 

if($stmt->fetch()) {

$stmt->close();

 

return true;

}

}

 

}

 

 

 

function validate_user($un, $pwd) {

$mysql = New Mysqlcon();

$ensure_credentials = $mysql->verify_Username_and_Pass($un, md5($pwd));

 

if($ensure_credentials) {

$_SESSION['status'] = 'authorized';

$_SESSION['username'] = ucfirst($un);

 

header("location: myprofile.php");

} else return "Please enter a correct username and password";

 

}

 

<p>Hello <? echo $_SESSION['firstname']; ?> (<?php echo $_SESSION['username']; ?>) </p>

 

firstname does not show

[gizmola]

I don't see anyplace in your code where you assign a value to $_SESSION['firstname'].