使用 PHP 和 MySQL 从登录用户中提取其他数据

我想修改下面的脚本，以便在用户被重定向时从数据库中提取其他信息。

我要提取的额外信息与用户名和密码位于同一表中，并标记为 fname。我是 php 的新手，所以任何帮助为我指明正确的方向将不胜感激。

我知道我可以使用用户名（如果我在重定向页面上的脚本中将 fname 替换为用户名，这确实有效），但那是一封电子邮件，所以作为对登录用户的问候语看起来并不好

这是登录用户并重定向的脚本，工作正常：

<?php
session_start();
$host="localhost";  // Host name 
$username="";       // Mysql username 
$password="";       // Mysql password 
$db_name="trydata"; // Database name 
$tbl_name="users";  // Table name
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB"); 
// username and password sent from form 
$myusername=$_POST['username']; 
$mypassword=$_POST['password']; 
// To protect MySQL injection (more detail about MySQL injection) 
$myusername = stripslashes($myusername); 
$mypassword = stripslashes($mypassword); 
$myusername = mysql_real_escape_string($myusername); 
$mypassword = mysql_real_escape_string($mypassword); 
$sql = "SELECT * 
        FROM $tbl_name 
        WHERE username='$myusername' 
        AND password='$mypassword'"; 
$result = mysql_query($sql); 
// Mysql_num_row is counting table row 
$count = mysql_num_rows($result); 
// If result matched $myusername and $mypassword,
// table row must be 1 row 
if($count == 1){ 
  // Register $myusername, $mypassword
  // and redirect to file"login_success.php" 
  $_SESSION['username'] = $myusername; 
  $_SESSION['password'] = $mypassword; 
  // get the result set from the query
  $result = mysql_fetch_array($result); 
  // get the redirect column's value
  $redirect = trim($result['redirect']);
  if ($redirect == '') {
    echo "No redirect value was set!";
  } else {
    header('Location: ' . $redirect);
    exit;
  }
} else { 
  echo "Wrong Username or Password"; 
} 
?>

以下是重定向页面中未从数据库拉取 fname 的脚本：

<?php 
// start up your PHP session! 
session_start();
if ($_SESSION["username"]) {
  echo "You are logged in as ".$_SESSION['fname'];
  echo "<p>";
  echo "<a href='aapage.php'>here is the aapage</a>";
  echo "<a href='logout.php'> Click here to logout<a/>";
} else {
  header ("Location: form.php");
}
?>