Newbie here - please explain this code :)
Posted: Wed Sep 03, 2008 9:01 pm
ok, so i inherited a program and i would appreciate if someone could explain the bold code to me.
sample input:
Store #,Address,City,ST,Zip,Immunizer,Provider,Clinic Date,Start Time,End Time
801,311 W. College Dr. ,Durango,CO,81301,Susan H,RPH.,"Thursday, October 09, 2008",3:00 PM,7:00 PM
801,311 W. College Dr. ,Durango,CO,81301,Susan H,RPH.,"Saturday, October 25, 2008",10:00 AM,2:00 PM
801,311 W. College Dr. ,Durango,CO,81301,Susan H,RPH.,"Saturday, November 08, 2008",10:00 AM,2:00 PM
803,7055 Austin Bluffs Pkway,COLORADO SPRINGS ,CO,80923,,Mollen Immunization Clinics,"Wednesday, October 01, 2008",11:00 AM,3:00 PM
803,7055 Austin Bluffs Pkway,COLORADO SPRINGS ,CO,80923,,Mollen Immunization Clinics,"Thursday, October 02, 2008",11:00 AM,3:00 PM
803,7055 Austin Bluffs Parkway,Colorado Springs,CO,80923,Rob G ,RPH.,"Monday, October 13, 2008",10:00 AM,2:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Monday, October 06, 2008",11:00 AM,3:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Tuesday, October 07, 2008",11:00 AM,3:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Monday, October 13, 2008",11:00 AM,3:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Tuesday, October 14, 2008",11:00 AM,3:00 PM
804,1451 Eisenhower Blvd ,Loveland,CO,80537,Dawn H,RPH.,"Tuesday, October 21, 2008",10:00 AM,2:00 PM
804,1451 Eisenhower Blvd ,Loveland,CO,80537,Dawn H,RPH.,"Wednesday, November 05, 2008",3:00 PM,7:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Wednesday, October 08, 2008",11:00 AM,3:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Thursday, October 09, 2008",11:00 AM,3:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Wednesday, October 15, 2008",11:00 AM,3:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Thursday, October 16, 2008",11:00 AM,3:00 PM
this is the output i'm getting:
Array ( [ST] => Array ( [City] => 1 ) [CO] => Array ( [Durango] => 1 [COLORADO SPRINGS ] => 1 [Colorado Springs] => 1 [LOVELAND ] => 1 [Loveland] => 1 [LAFAYETTE ] => 1 [Lafayette] => 1 [Louisville] => 1 [FORT COLLINS ] => 1 [Fort Collins] => 1 [Evergreen] => 1 [Pueblo] => 1 [DENVER ] => 1 [Denver] => 1 [LITTLETON ] => 1 [Littleton] => 1 [AURORA ] => 1 [Aurora] => 1 [Northglenn] => 1 [Greenwood Village] => 1 [LONGMONT ] => 1 [THORNTON ] => 1 [Thornton] => 1 [Arvada] => 1 ) [NM] => Array ( [GALLUP] => 1 [RIO RANCHO] => 1 [Rio Rancho] => 1 [ALBUQUERQUE] => 1 [Albuquerque] => 1 [CARLSBAD] => 1 [LAS CRUCES] => 1 [Las Cruces] => 1 [SILVER CITY] => 1 [CLOVIS] => 1 [ Albuquerque] => 1 [Los Lunas] => 1 [LOS LUNAS] => 1 [TAOS] => 1 [SANTA FE] => 1 [Santa Fe] => 1 [HOBBS] => 1 [ROSWELL] => 1 [Roswell] => 1 [FARMINGTON] => 1 ) [AZ] => Array ( [LITCHFIELD PARK] => 1 [GILBERT] => 1 [YUMA] => 1 [TEMPE] => 1 [GLENDALE] => 1 [MESA] => 1 [PHOENIX] => 1 [PRESCOTT] => 1 [SCOTTSDALE] => 1 [TUCSON] => 1 [PRESCOTT VALLEY] => 1 [FLAGSTAFF] => 1 [CASA GRANDE] => 1 [PEORIA] => 1 [SURPRISE] => 1 [CHANDLER] => 1 [LAKE HAVASU CITY] => 1 ) [TX] => Array ( [El Paso] => 1 [COLLEGE STATION] => 1 [KERRVILLE] => 1 [NEW BRAUNFELS] => 1 [Murphy] => 1 [MURPHY] => 1 [SAGINAW] => 1 [Saginaw] => 1 [DALLAS] => 1 [Dallas] => 1 [Euless] => 1 [EULESS] => 1 [CARROLLTON] => 1 [Carrollton] => 1 [LONGVIEW] => 1 [Longview] => 1 [DENISON] => 1 [GARLAND] => 1 [PLANO] => 1 [Plano] => 1 [FORT WORTH] => 1 [RICHARDSON] => 1 [Sherman] => 1 [SHERMAN] => 1 [MESQUITE] => 1 [Mesquite] => 1 [CEDAR HILL] => 1 [TEXARKANA] => 1 [Arlington] => 1 [ARLINGTON] => 1 [HURST] => 1 [Hurst] => 1 [ROANOKE] => 1 [LAKE WORTH] => 1 [DENTON] => 1 [Denton] => 1 [Midland] => 1 [MIDLAND] => 1 [ODESSA] => 1 [SAN ANGELO] => 1 [ABILENE] => 1 [Abilene] => 1 [DESOTO] => 1 [DeSoto] => 1 [Ft. Worth] => 1 [WEATHERFORD] => 1 [ALLEN] => 1 [Allen] => 1 [BENBROOK] => 1 [Benbrook] => 1 [CORINTH] => 1 [Corinth] => 1 [WATAUGA] => 1 [ROWLETT] => 1 [Rowlett] => 1 [Fort Worth] => 1 [AMARILLO] => 1 [Amarillo] => 1 [Tyler] => 1 [San Angelo] => 1 [FRISCO] => 1 [Frisco] => 1 [GRAND PRAIRIE] => 1 [Grand Prairie] => 1 [MC KINNEY] => 1 [McKinney] => 1 [WICHITA FALLS] => 1 [WYLIE] => 1 [Wylie] => 1 [CROWLEY] => 1 [Crowley] => 1 [BEDFORD] => 1 [Bedford] => 1 [COLLEYVILLE] => 1 [Colleyville] => 1 [BURLESON] => 1 [Burleson] => 1 [Lewisville] => 1 [LEWISVILLE] => 1 [Southlake] => 1 [AZLE] => 1 [CLEBURNE] => 1 ) [LA] => Array ( [BATON ROUGE] => 1 [HAMMOND] => 1 [ALEXANDRIA] => 1 [LAKE CHARLES] => 1 [LAFAYETTE] => 1 [BROUSSARD] => 1 [SHREVEPORT] => 1 [BOSSIER CITY] => 1 ) [AR] => Array ( [TEXARKANA] => 1 ) [FL] => Array ( [CLEARWATER] => 1 [ALTAMONTE SPRINGS] => 1 [GAINESVILLE] => 1 [Gainesville] => 1 [OAKLAND PARK] => 1 [ORLANDO] => 1 [TAMPA] => 1 [LAKE WORTH] => 1 [WEST PALM BEACH] => 1 [West Palm Beach] => 1 [VENICE] => 1 [Venice] => 1 [LONGWOOD] => 1 [BRADENTON] => 1 [VERO BEACH] => 1 [APOPKA] => 1 [Apopka] => 1 [PEMBROKE PINES] => 1 [LAKE MARY] => 1 [BOCA RATON] => 1 [MOUNT DORA] => 1 [Mt. Dora] => 1 [WINTER SPRINGS] => 1 [DELRAY BEACH] => 1 [OCALA] => 1 [EAST LARGO] => 1 [KISSIMMEE] => 1 [OVIEDO] => 1 [WINTER PARK] => 1 [MELBOURNE] => 1 [VALRICO] => 1 [Orlando] => 1 [SARASOTA] => 1 [Sarasota] => 1 [PORT ST. LUCIE] => 1 [SANFORD] => 1 [Sanford] => 1 [LOXAHATCHEE] => 1 [ESTERO] => 1 [RIVERVIEW] => 1 [Riverview] => 1 [BONITA SPRINGS] => 1 [KEY WEST] => 1 [Lake Worth] => 1 [Tallahassee] => 1 [Apopaka] => 1 ) ) CASA GRANDE CHANDLER FLAGSTAFF GILBERT GLENDALE LAKE HAVASU CITY LITCHFIELD PARK MESA PEORIA PHOENIX PRESCOTT PRESCOTT VALLEY SCOTTSDALE SURPRISE TEMPE TUCSON YUMA
Thanks!

Code: Select all
$handle = fopen("foo.csv", "r");
while (($cols = fgetcsv($handle, 1000, ",")) !== FALSE)
{
#state|city
[b]$CITY["$cols[3]"]["$cols[2]"] = 1;[/b] what does the = 1 mean?
#city|store
[b]$STORE["$cols[7]"]["$cols[2] - $cols[6]"] = 1;[/b] does the dash (-) mean columns 2 thru 6?
$DATE["$cols[2] - $cols[6]"]["$cols[17] $cols[18] - $cols[19]"] = 1;[/b]
}
Store #,Address,City,ST,Zip,Immunizer,Provider,Clinic Date,Start Time,End Time
801,311 W. College Dr. ,Durango,CO,81301,Susan H,RPH.,"Thursday, October 09, 2008",3:00 PM,7:00 PM
801,311 W. College Dr. ,Durango,CO,81301,Susan H,RPH.,"Saturday, October 25, 2008",10:00 AM,2:00 PM
801,311 W. College Dr. ,Durango,CO,81301,Susan H,RPH.,"Saturday, November 08, 2008",10:00 AM,2:00 PM
803,7055 Austin Bluffs Pkway,COLORADO SPRINGS ,CO,80923,,Mollen Immunization Clinics,"Wednesday, October 01, 2008",11:00 AM,3:00 PM
803,7055 Austin Bluffs Pkway,COLORADO SPRINGS ,CO,80923,,Mollen Immunization Clinics,"Thursday, October 02, 2008",11:00 AM,3:00 PM
803,7055 Austin Bluffs Parkway,Colorado Springs,CO,80923,Rob G ,RPH.,"Monday, October 13, 2008",10:00 AM,2:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Monday, October 06, 2008",11:00 AM,3:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Tuesday, October 07, 2008",11:00 AM,3:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Monday, October 13, 2008",11:00 AM,3:00 PM
804,1451 W. Eisenhower Blvd.,LOVELAND ,CO,80538,,Mollen Immunization Clinics,"Tuesday, October 14, 2008",11:00 AM,3:00 PM
804,1451 Eisenhower Blvd ,Loveland,CO,80537,Dawn H,RPH.,"Tuesday, October 21, 2008",10:00 AM,2:00 PM
804,1451 Eisenhower Blvd ,Loveland,CO,80537,Dawn H,RPH.,"Wednesday, November 05, 2008",3:00 PM,7:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Wednesday, October 08, 2008",11:00 AM,3:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Thursday, October 09, 2008",11:00 AM,3:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Wednesday, October 15, 2008",11:00 AM,3:00 PM
808,555 W South Boulder Rd.,LAFAYETTE ,CO,80026,,Mollen Immunization Clinics,"Thursday, October 16, 2008",11:00 AM,3:00 PM
this is the output i'm getting:
Array ( [ST] => Array ( [City] => 1 ) [CO] => Array ( [Durango] => 1 [COLORADO SPRINGS ] => 1 [Colorado Springs] => 1 [LOVELAND ] => 1 [Loveland] => 1 [LAFAYETTE ] => 1 [Lafayette] => 1 [Louisville] => 1 [FORT COLLINS ] => 1 [Fort Collins] => 1 [Evergreen] => 1 [Pueblo] => 1 [DENVER ] => 1 [Denver] => 1 [LITTLETON ] => 1 [Littleton] => 1 [AURORA ] => 1 [Aurora] => 1 [Northglenn] => 1 [Greenwood Village] => 1 [LONGMONT ] => 1 [THORNTON ] => 1 [Thornton] => 1 [Arvada] => 1 ) [NM] => Array ( [GALLUP] => 1 [RIO RANCHO] => 1 [Rio Rancho] => 1 [ALBUQUERQUE] => 1 [Albuquerque] => 1 [CARLSBAD] => 1 [LAS CRUCES] => 1 [Las Cruces] => 1 [SILVER CITY] => 1 [CLOVIS] => 1 [ Albuquerque] => 1 [Los Lunas] => 1 [LOS LUNAS] => 1 [TAOS] => 1 [SANTA FE] => 1 [Santa Fe] => 1 [HOBBS] => 1 [ROSWELL] => 1 [Roswell] => 1 [FARMINGTON] => 1 ) [AZ] => Array ( [LITCHFIELD PARK] => 1 [GILBERT] => 1 [YUMA] => 1 [TEMPE] => 1 [GLENDALE] => 1 [MESA] => 1 [PHOENIX] => 1 [PRESCOTT] => 1 [SCOTTSDALE] => 1 [TUCSON] => 1 [PRESCOTT VALLEY] => 1 [FLAGSTAFF] => 1 [CASA GRANDE] => 1 [PEORIA] => 1 [SURPRISE] => 1 [CHANDLER] => 1 [LAKE HAVASU CITY] => 1 ) [TX] => Array ( [El Paso] => 1 [COLLEGE STATION] => 1 [KERRVILLE] => 1 [NEW BRAUNFELS] => 1 [Murphy] => 1 [MURPHY] => 1 [SAGINAW] => 1 [Saginaw] => 1 [DALLAS] => 1 [Dallas] => 1 [Euless] => 1 [EULESS] => 1 [CARROLLTON] => 1 [Carrollton] => 1 [LONGVIEW] => 1 [Longview] => 1 [DENISON] => 1 [GARLAND] => 1 [PLANO] => 1 [Plano] => 1 [FORT WORTH] => 1 [RICHARDSON] => 1 [Sherman] => 1 [SHERMAN] => 1 [MESQUITE] => 1 [Mesquite] => 1 [CEDAR HILL] => 1 [TEXARKANA] => 1 [Arlington] => 1 [ARLINGTON] => 1 [HURST] => 1 [Hurst] => 1 [ROANOKE] => 1 [LAKE WORTH] => 1 [DENTON] => 1 [Denton] => 1 [Midland] => 1 [MIDLAND] => 1 [ODESSA] => 1 [SAN ANGELO] => 1 [ABILENE] => 1 [Abilene] => 1 [DESOTO] => 1 [DeSoto] => 1 [Ft. Worth] => 1 [WEATHERFORD] => 1 [ALLEN] => 1 [Allen] => 1 [BENBROOK] => 1 [Benbrook] => 1 [CORINTH] => 1 [Corinth] => 1 [WATAUGA] => 1 [ROWLETT] => 1 [Rowlett] => 1 [Fort Worth] => 1 [AMARILLO] => 1 [Amarillo] => 1 [Tyler] => 1 [San Angelo] => 1 [FRISCO] => 1 [Frisco] => 1 [GRAND PRAIRIE] => 1 [Grand Prairie] => 1 [MC KINNEY] => 1 [McKinney] => 1 [WICHITA FALLS] => 1 [WYLIE] => 1 [Wylie] => 1 [CROWLEY] => 1 [Crowley] => 1 [BEDFORD] => 1 [Bedford] => 1 [COLLEYVILLE] => 1 [Colleyville] => 1 [BURLESON] => 1 [Burleson] => 1 [Lewisville] => 1 [LEWISVILLE] => 1 [Southlake] => 1 [AZLE] => 1 [CLEBURNE] => 1 ) [LA] => Array ( [BATON ROUGE] => 1 [HAMMOND] => 1 [ALEXANDRIA] => 1 [LAKE CHARLES] => 1 [LAFAYETTE] => 1 [BROUSSARD] => 1 [SHREVEPORT] => 1 [BOSSIER CITY] => 1 ) [AR] => Array ( [TEXARKANA] => 1 ) [FL] => Array ( [CLEARWATER] => 1 [ALTAMONTE SPRINGS] => 1 [GAINESVILLE] => 1 [Gainesville] => 1 [OAKLAND PARK] => 1 [ORLANDO] => 1 [TAMPA] => 1 [LAKE WORTH] => 1 [WEST PALM BEACH] => 1 [West Palm Beach] => 1 [VENICE] => 1 [Venice] => 1 [LONGWOOD] => 1 [BRADENTON] => 1 [VERO BEACH] => 1 [APOPKA] => 1 [Apopka] => 1 [PEMBROKE PINES] => 1 [LAKE MARY] => 1 [BOCA RATON] => 1 [MOUNT DORA] => 1 [Mt. Dora] => 1 [WINTER SPRINGS] => 1 [DELRAY BEACH] => 1 [OCALA] => 1 [EAST LARGO] => 1 [KISSIMMEE] => 1 [OVIEDO] => 1 [WINTER PARK] => 1 [MELBOURNE] => 1 [VALRICO] => 1 [Orlando] => 1 [SARASOTA] => 1 [Sarasota] => 1 [PORT ST. LUCIE] => 1 [SANFORD] => 1 [Sanford] => 1 [LOXAHATCHEE] => 1 [ESTERO] => 1 [RIVERVIEW] => 1 [Riverview] => 1 [BONITA SPRINGS] => 1 [KEY WEST] => 1 [Lake Worth] => 1 [Tallahassee] => 1 [Apopaka] => 1 ) ) CASA GRANDE CHANDLER FLAGSTAFF GILBERT GLENDALE LAKE HAVASU CITY LITCHFIELD PARK MESA PEORIA PHOENIX PRESCOTT PRESCOTT VALLEY SCOTTSDALE SURPRISE TEMPE TUCSON YUMA
Thanks!