title: How do I get certain columns in a .csv file
body: <p>Hey guys so I already have some code that will grab the firstname, lastname, and email of a column in a .csv file but it is not working right and I could use a hand on getting this up.</p>
  
  <p>Heres current code:</p>
  
  <pre><code>//this file is used to grab the usernames of the csv file and put them in a session, returning it memberinterface that will open a dialog box with the usernames
  $seterror = 0;
  
  function returnBack(){
  
      header("Location:../memberinterface.php?getmsg=15");
      exit;
  
  }
  function returnBackfile(){
  
      header("Location:../memberinterface.php?getmsg=16");
      exit;
  }
  if (!empty($_FILES['csvfile']['error'] ) )
      {
  
          $seterror = 1;
          returnBack();
  
      } 
      if (empty($_POST['firstname'])){
  
          $seterror =1;
          returnBack();
      }
      if (empty($_POST['lastname'])){
          $seterrro =1;
  
          returnBack();
      }
      if (empty($_POST['email'])){
          $seterror =1;
  
          returnBack();
      }
      if ($seterror !== 1){
  
      $file = $_FILES['csvfile']['tmp_name']; 
  
      $handle = fopen($file , "r");
  
      $fileop = fgetcsv($handle,1000,",");
  
      $fileop=array_map("strtoupper",array_map("trim",$fileop));
  
      $firstname_index = array_search(strtoupper($_POST["firstname"]),$fileop); &lt;!-----these right here are not working correctly and will always send me back with the error, it does not find the firstname column? and same with the other ones.
      if ($firstname_index===false){
  
          returnBack();
      }
      $lastname_index = array_search(strtoupper($_POST['lastname']),$fileop);
      if ($lastname_index===false){
  
          returnBack();
      }
      $email_index = array_search(strtoupper($_POST['email']),$fileop);
      if ($email_index===false){
  
          returnBack();
      }
          //open file and store values
          $j = 0;
          while (($fileop=fgetcsv($handle)) !== false)
          {
  
              $fileop=array_map("trim",$fileop);
              $firstname[$j] = $fileop[$firstname_index];
              if (empty($firstname[$j])){ 
  
              returnBackfile();
  
              }
  
              $lastname[$j] = $fileop[$lastname_index];
                  if (empty($lastname[$j])){
  
              returnBackfile();
  
              }
              $email[$j] = $fileop[$email_index];
                  if (empty($email[$j])){
  
              returnBackfile();
  
  
              }
              $j++;
          }
  
          print_r($firstname);
  
  
      }
  </code></pre>
  
  <p>so when I print out $firstname value, it prints out values from the .csv file but with all of the values?  </p>
  
  <p>So to recap I am trying to make it get the firstname, lastname, and email column from a .csv file, store it in the $firstname array, $lastname array, etc...</p>
  
  <p>Please if you could help I would appreciate it!!</p>
  
  <p>David </p>
  
  <p>UPDATE:</p>
  
  <p>After putting <code>var_dump($fileop); var_dump($POST);</code> ontop of <code>$firstname_index = array_search($_POST["firstname"],$fileop);</code></p>
  
  <p>I got these results with a .csv file:</p>
  
  <pre><code>    array(1) { [0]=&gt; string(162) "FIRSTNAME LASTNAME    EMAIL   PHONE   COMBINED SINGLE LIMIT   BODILY INJURY EACH PERSON   BODILY INJURY EACH ACCIDENT PROPERTY 
  DAMAGE  STATUS  ADDRESS NOTES   STATUS CHANGE DATE" } 
  NULL Array ( [0] =&gt; Hank    Aaron biga.@gsadf.com   777.777.7777    '0  20000   
  40000   10000   Non-Active [1] =&gt; Fred  Astaire astaire@test.com    222.431.5843    '0  
  '0  '0  '0  Open    98 Ocean Blvd [2] =&gt; Jim    Belushi biga.@gsadf.com 
  333.333.3333    '0  '0  '0  '0  Open    98 Ocean Blvd [3] =&gt; Charlie    
  Brown   charlie@test.com    909.111.1111    '0  '0  '0  '0  Open    98 
  Ocean Blvd [4] =&gt; Carol Burnett burnett@test.com    911.911.9999    '0  '0  '0  
  '0  Enrolled - PCG to Follow-Up 98 Ocean Blvd [5] =&gt; Bill   Cosby   
  cosby@test.com 989.989.9898 '0  100000  300000  100000  Confirmed   23 Surf Rd 
  [6] =&gt; Charles  Dickens dickens@test.com    897.333.3333    '0  '0  '0  '0  
  Non-Active - Driver Chose Non-Compliance    23 Surf Rd [7] =&gt; Walt  Disney  
  disney@test.com 909.909.9090    '0  '0  '0  '0  Non-Active - Driver Chose 
  Non-Compliance  23 Surf Rd [8] =&gt; Bob Dylan dylan@test.com  333.444.5555    '0  '0  
  '0  '0  Enrolled - Agent Emailed    23 Surf Rd [9] =&gt; Thomas    Edison  
  edison@test.com 765.222.1111    '0  '0  '0  '0  Enrolled - Agent Emailed    
  23 Surf Rd [10] =&gt; Harrison Ford    harrison@test.com   345.543.5555    '0  '0  
  '0  '0  Enrolled - Agent Emailed    23 Surf Rd [11] =&gt; Bill Gates 
  gates@test.com  123.456.7890    350000  '0  '0  '0  Enrolled - Employee Follow-
  Up Required 16 Tulip Ln [12] =&gt; Tom Hanks   hanks@test.com  777.888.9999    '0  '0  
  '0  '0 Enrolled - Agent Emailed 16 Tulip Ln [13] =&gt; Alfred  Hitchcock   
  alfred@test.com 878.000.9999    '0  '0  '0  '0  Non-Active - Other  16 
  Tulip Ln [14] =&gt; Michael    Jackson jackson@test.com    123.123.1234    '0  '0  
  '0  '0  Non-Active - PolicyHolder Cancelled Additional Interest 16 Tulip Ln [15] =&gt; 
  Michael Jordan  michael@test.com 888.888.8888   '0  '0  '0  '0  Non-Active 
  - Employee Not Covered Under Listed Policy  16 Tulip Ln [16] =&gt; John    Lennon  
  lennon@test.com '098.765.5432   '0  '0  '0  '0 Non-Active - Insurance Cancelled 
  16 Tulip Ln [17] =&gt; Joe Lewis   b@hotmail.com   888.999.1111    '0  15000   
  30000   5000    Confirmed   4765 E Palm Rd [18] =&gt; Peyton   Manning peyton@test.com 
  111.222.3333    '0  '0  '0  '0  Enrolled - Agent Emailed    4765 E Palm 
  Rd [19] =&gt; Marilyn  Monroe  monroe@test.com 212.121.1212 '0 '0  '0  '0  
  Enrolled - Policyholder Follow-Up Required  4765 E Palm Rd [20] =&gt; Elvis    Presley 
  elvis@test.com  909.000.8761    '0  '0  '0  '0  Enrolled - New Carrier 
  Being Processed 4765 E Palm Rd [21] =&gt; Dan  Rather  rather@test.com 333.333.8888    '0  
  25000   50000   15000   Confirmed   909 Kodak Ln [22] =&gt; Chris  Rhodes 
  crhodes@rhodesretail.com    916-205-2474 '0 '0  '0  '0  Open    909 Kodak 
  Ln [23] =&gt; William  Shakespeare william@test.com    444.444.4444    '0  
  100000  300000 100000   Confirmed   926 Maple St [24] =&gt; Meryl  Streep  
  streep@test.com 411.411.4111    '0  100000  300000  100000  Confirmed   412 East 
  3rd St [25] =&gt; Mark Twain   twain@test.com  323.323.3232    '0  '0  '0  '0  
  Enrolled - Agent Emailed    412 East 3rd St [26] =&gt; Darth   Vader   darth@test.com  
  874.321.4444    '0  25000   50000 15000 Confirmed   1234W U Parkway [27] =&gt; 
  George  Washington  george@test.com 876.321.1234    '0  100000  300000  100000  
  Confirmed   12 oak blvd [28] =&gt; Robin   Williams    rwilliams@test.com  
  444.555.6666    '0  '0  '0  '0  Open    12 oak blvd )
  </code></pre>