adi123 Posted May 2, 2011 Share Posted May 2, 2011 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 Quote Link to comment Share on other sites More sharing options...
gizmola Posted May 3, 2011 Share Posted May 3, 2011 I don't see anyplace in your code where you assign a value to $_SESSION['firstname']. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.