如何在.csv文件中获取某些列

Question

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.

Heres current 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); <!-----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);


    }

so when I print out $firstname value, it prints out values from the .csv file but with all of the values?

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...

Please if you could help I would appreciate it!!

David

UPDATE:

After putting var_dump($fileop); var_dump($POST); ontop of $firstname_index = array_search($_POST["firstname"],$fileop);

I got these results with a .csv file:

    array(1) { [0]=> 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] => Hank    Aaron [e-mail]   777.777.7777    '0  20000   
40000   10000   Non-Active [1] => Fred  Astaire [e-mail]    222.431.5843    '0  
'0  '0  '0  Open    98 Ocean Blvd [2] => Jim    Belushi [e-mail] 
333.333.3333    '0  '0  '0  '0  Open    98 Ocean Blvd [3] => Charlie    
Brown   [e-mail]    909.111.1111    '0  '0  '0  '0  Open    98 
Ocean Blvd [4] => Carol Burnett [e-mail]    911.911.9999    '0  '0  '0  
'0  Enrolled - PCG to Follow-Up 98 Ocean Blvd [5] => Bill   Cosby   
[e-mail] 989.989.9898 '0  100000  300000  100000  Confirmed   23 Surf Rd 
[6] => Charles  Dickens [e-mail]    897.333.3333    '0  '0  '0  '0  
Non-Active - Driver Chose Non-Compliance    23 Surf Rd [7] => Walt  Disney  
[e-mail] 909.909.9090    '0  '0  '0  '0  Non-Active - Driver Chose 
Non-Compliance  23 Surf Rd [8] => Bob Dylan [e-mail]  333.444.5555    '0  '0  
'0  '0  Enrolled - Agent Emailed    23 Surf Rd [9] => Thomas    Edison  
[e-mail] 765.222.1111    '0  '0  '0  '0  Enrolled - Agent Emailed    
23 Surf Rd [10] => Harrison Ford    [e-mail]   345.543.5555    '0  '0  
'0  '0  Enrolled - Agent Emailed    23 Surf Rd [11] => Bill Gates 
[e-mail]  123.456.7890    350000  '0  '0  '0  Enrolled - Employee Follow-
Up Required 16 Tulip Ln [12] => Tom Hanks   [e-mail]  777.888.9999    '0  '0  
'0  '0 Enrolled - Agent Emailed 16 Tulip Ln [13] => Alfred  Hitchcock   
[e-mail] 878.000.9999    '0  '0  '0  '0  Non-Active - Other  16 
Tulip Ln [14] => Michael    Jackson [e-mail]    123.123.1234    '0  '0  
'0  '0  Non-Active - PolicyHolder Cancelled Additional Interest 16 Tulip Ln [15] => 
Michael Jordan  [e-mail] 888.888.8888   '0  '0  '0  '0  Non-Active 
- Employee Not Covered Under Listed Policy  16 Tulip Ln [16] => John    Lennon  
[e-mail] '098.765.5432   '0  '0  '0  '0 Non-Active - Insurance Cancelled 
16 Tulip Ln [17] => Joe Lewis   [e-mail]   888.999.1111    '0  15000   
30000   5000    Confirmed   4765 E Palm Rd [18] => Peyton   Manning [e-mail] 
111.222.3333    '0  '0  '0  '0  Enrolled - Agent Emailed    4765 E Palm 
Rd [19] => Marilyn  Monroe  [e-mail] 212.121.1212 '0 '0  '0  '0  
Enrolled - Policyholder Follow-Up Required  4765 E Palm Rd [20] => Elvis    Presley 
[e-mail]  909.000.8761    '0  '0  '0  '0  Enrolled - New Carrier 
Being Processed 4765 E Palm Rd [21] => Dan  Rather  [e-mail] 333.333.8888    '0  
25000   50000   15000   Confirmed   909 Kodak Ln [22] => Chris  Rhodes 
[e-mail]    916-205-2474 '0 '0  '0  '0  Open    909 Kodak 
Ln [23] => William  Shakespeare [e-mail]    444.444.4444    '0  
100000  300000 100000   Confirmed   926 Maple St [24] => Meryl  Streep  
[e-mail] 411.411.4111    '0  100000  300000  100000  Confirmed   412 East 
3rd St [25] => Mark Twain   [e-mail]  323.323.3232    '0  '0  '0  '0  
Enrolled - Agent Emailed    412 East 3rd St [26] => Darth   Vader   [e-mail]  
874.321.4444    '0  25000   50000 15000 Confirmed   1234W U Parkway [27] => 
George  Washington  [e-mail] 876.321.1234    '0  100000  300000  100000  
Confirmed   12 oak blvd [28] => Robin   Williams    [e-mail]  
444.555.6666    '0  '0  '0  '0  Open    12 oak blvd )

Answer 1

By default, fgetcsv() uses comma as the column delimiter. Your file is tab-delimited, so you need to specify the delimiter argument explicitly.

Change:

$fileop = fgetcsv($handle,1000,",");

to:

$fileop = fgetcsv($handle,0,"\t");

and change:

while (($fileop=fgetcsv($handle)) !== false)

to:

while (($fileop=fgetcsv($handle, 0, "\t")) !== false)