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