title: Session User ID?
body: <p>I have adpopted some code to create a login, checklogin, successful login, failed login and logout pages. The checklogin page essentially checks the username and password posted from login. If these are correct you end up at successful login page. However I want to say something like 'Welcome John' on the successful login page, but dont know how to get the username from the session so that I can base a query on this to pull back the logged in persons name. The checklogin page is: </p>
  
  <pre><code>&lt;?php require_once('Connections/Connection1.php'); ?&gt;
  
  &lt;?php 
  //$host="localhost"; // Host name 
  //$username=""; // Mysql username 
  //$password=""; // Mysql password 
  //$db_name=""; // Database name 
  $tbl_name="users"; // Table name 
  
  
  
  // Connect to server and select databse.
  //mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
  //mysql_select_db("$db_name")or die("cannot select DB");
  mysql_select_db($database_Connection1, $Connection1);
  
  // username and password sent from form 
  $myusername=$_POST['myusername']; 
  $mypassword=md5($_POST['mypassword']); 
  
  // 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 userid='$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_register("myusername");
  session_register("mypassword"); 
  header("location:main.php");
  }
  else {
  header("location:login_failed.php");
  //echo "Wrong Username or Password";
  }
  ?&gt;
  </code></pre>
  
  <p>Then on my successful login page, how do I echo the username? or at least refer to it in a query to then pull back the additional information like name?</p>
  
  <p>Many thanks!!</p>