title: How to retrieve information from a record in a database in PHP 5.5?
body: <p>I am mostly confused about the new php 5.5, I apologize for any inconvenience. </p>
  
  <p>I am trying to get information from whomever logs in, so for example if I log in with an email, I'd like the website to get my first name and do a "Welcome, Shinji!".</p>
  
  <pre><code>    $conn = mysqli_connect('localhost','root','');
      $db = mysqli_select_db($conn , 'session_start');
  
      $user = $_POST['user'];
      $pass = $_POST['pass'];
  
      $query = mysqli_query($conn , "SELECT * FROM `info_table` WHERE '$user' = `user` AND '$pass'=`password`") or die(mysqli_error($conn));
      $rows = mysqli_num_rows($query);
  
      if($rows == 1){
  
          #$query2 = mysqli_query($conn , "INSERT INTO `who_logged` (`name`) VALUES ('$user')") or die(mysqli_error($conn));
          #$rows = mysqli_num_rows($query);
  
          session_start();
  
           $_SESSION['username'] = $_POST['user']; // store username
           $_SESSION['password'] = $_POST['pass']; // store password
  
          $query2 = mysqli_query($conn ,"SELECT `name` FROM `info_table` WHERE '$user' = `user`") or die(mysqli_error($conn));
          $result = mysqli_num_rows($query2);
  
          while ($row = mysql_fetch_assoc($result)) {
          $_SESSION['name'] = $row['name'];//I thought to try setting the name to the Session variable, but does not work
      }
  
          header('Location: next_page.php');
          exit();
  
      }else{
          echo "Wrong username or password.";
      }
  </code></pre>
  
  <p>I tried to set the name to a session variable, but if there is a more efficient way please say so! (This current code works, except the name setting to session.</p>