The code below works exactly the way that I want it to, but is there a way to clean it up to where I don't have to enter all of the field names and all of the '%s' and all of the $data[]?
I have to create several more queries that involve over 100 field names and I am curious if there is an easier way to go about doing this.
Any feedback would be greatly appreciated. Thanks!
$filename="file.txt";
$handle = fopen("$filename", "r");
$removeLine1 = fgetcsv($handle, 100000, "|");
while (($data = fgetcsv($handle, 100000, "|")) !== FALSE) {
$import=sprintf("REPLACE INTO commercial
(Transaction_Type, MLSNumber, ListOfficeId, ListOfficeAddress1, ListOfficeAddress2, ListOfficeCity, ListOfficeCompany, ListOfficeEmailAddress, ListOfficePhoneMain, ListOfficeState, ListOfficeWebPage, ListOfficeZip5, ListAgentId, ListAgentEmailAddress, ListAgentFirstName, ListAgentLastName, ListAgentWebPage, Acres, Addl_Documents, Area, Area_Name, BOMK_Date, Brd_No, Buyer_Agency, Buyer_Agt_Comp, Cit_Town_Vil, City, County, Current_Use, Directions, Directions_E_W, Directions_N_S, Down_Payment, East_West, Encroachments, ExpirationDate, Frontage_Feet, Finance_Code, Gross_Income, Inventory_Incl, Inventory_List, Land_Contract, Land_Int_Rate, Land_Payment, Land_Terms, Lease_Sale, Legal, ListDate, ListPrice, Lot_Dimen, Lp_Per_Acre, Lp_Per_Sqft, Main_Square_Feet, Map_Letter, Map_Number, Market_Code, MI_To_Airport, MI_To_Interstate, MI_To_Rail, MI_To_Waterway, MO_Sales, Net_Oper_Income, No_Efficiencies, No_Units, Non_Agency, Non_Agt_Comp, North_South, Ofc_Square_Feet, Office_Heat_Source, Office_Heat_Type, Oper_Exp, Plant_Heat_Source, Plant_Heat_Type, PropType, RailRoad, Remarks1, Remarks2, Remarks3, Remarks4, Remarks5, Remarks6, Rental_Cert, Restrictions, Road_Frontage_Class, Road_Frontage_Type, School_District, Side_Of_Str, Srce_Square_Feet, Status, StatusDate, Street_Dir, Street_Type, StreetName, StreetNumber, SummerTax, Tot_Square_Feet, TourURL, Waterway, Winter_Tax, Year_Built, Zip4, Zip5, Access, Architecture, Buildings, Business_Type, CM_Exterior_Feat, CM_Features, Comp_Arrangements, Exterior, Foundation, Fuel_Type, Licenses, Offerings, Office_Heat, Plant_Heat, Road_Frontage, Terms, Water_Heater, Water_Name, Water_Sewer, Waterfront_Desc, Zoning, PhotoURL, DisplayAddress, Year_Remodeled, MailingCity, SubdivisionName, Environmental, Other_Feat, Sub_Prop_Type)
VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
mysql_real_escape_string($data[0]), mysql_real_escape_string($data[1]), mysql_real_escape_string($data[2]), mysql_real_escape_string($data[3]), mysql_real_escape_string($data[4]), mysql_real_escape_string($data[5]), mysql_real_escape_string($data[6]), mysql_real_escape_string($data[7]), mysql_real_escape_string($data[8]), mysql_real_escape_string($data[9]), mysql_real_escape_string($data[10]), mysql_real_escape_string($data[11]), mysql_real_escape_string($data[12]), mysql_real_escape_string($data[13]), mysql_real_escape_string($data[14]), mysql_real_escape_string($data[15]), mysql_real_escape_string($data[16]), mysql_real_escape_string($data[17]), mysql_real_escape_string($data[18]), mysql_real_escape_string($data[19]), mysql_real_escape_string($data[20]), mysql_real_escape_string($data[21]), mysql_real_escape_string($data[22]), mysql_real_escape_string($data[23]), mysql_real_escape_string($data[24]), mysql_real_escape_string($data[25]), mysql_real_escape_string($data[26]), mysql_real_escape_string($data[27]), mysql_real_escape_string($data[28]), mysql_real_escape_string($data[29]), mysql_real_escape_string($data[30]), mysql_real_escape_string($data[31]), mysql_real_escape_string($data[32]), mysql_real_escape_string($data[33]), mysql_real_escape_string($data[34]), mysql_real_escape_string($data[35]), mysql_real_escape_string($data[36]), mysql_real_escape_string($data[37]), mysql_real_escape_string($data[38]), mysql_real_escape_string($data[39]), mysql_real_escape_string($data[40]), mysql_real_escape_string($data[41]), mysql_real_escape_string($data[42]), mysql_real_escape_string($data[43]), mysql_real_escape_string($data[44]), mysql_real_escape_string($data[45]), mysql_real_escape_string($data[46]), mysql_real_escape_string($data[47]), mysql_real_escape_string($data[48]), mysql_real_escape_string($data[49]), mysql_real_escape_string($data[50]), mysql_real_escape_string($data[51]), mysql_real_escape_string($data[52]), mysql_real_escape_string($data[53]), mysql_real_escape_string($data[54]), mysql_real_escape_string($data[55]), mysql_real_escape_string($data[56]), mysql_real_escape_string($data[57]), mysql_real_escape_string($data[58]), mysql_real_escape_string($data[59]), mysql_real_escape_string($data[60]), mysql_real_escape_string($data[61]), mysql_real_escape_string($data[62]), mysql_real_escape_string($data[63]), mysql_real_escape_string($data[64]), mysql_real_escape_string($data[65]), mysql_real_escape_string($data[66]), mysql_real_escape_string($data[67]), mysql_real_escape_string($data[68]), mysql_real_escape_string($data[69]), mysql_real_escape_string($data[70]), mysql_real_escape_string($data[71]), mysql_real_escape_string($data[72]), mysql_real_escape_string($data[73]), mysql_real_escape_string($data[74]), mysql_real_escape_string($data[75]), mysql_real_escape_string($data[76]), mysql_real_escape_string($data[77]), mysql_real_escape_string($data[78]), mysql_real_escape_string($data[79]), mysql_real_escape_string($data[80]), mysql_real_escape_string($data[81]), mysql_real_escape_string($data[82]), mysql_real_escape_string($data[83]), mysql_real_escape_string($data[84]), mysql_real_escape_string($data[85]), mysql_real_escape_string($data[86]), mysql_real_escape_string($data[87]), mysql_real_escape_string($data[88]), mysql_real_escape_string($data[89]), mysql_real_escape_string($data[90]), mysql_real_escape_string($data[91]), mysql_real_escape_string($data[92]), mysql_real_escape_string($data[93]), mysql_real_escape_string($data[94]), mysql_real_escape_string($data[95]), mysql_real_escape_string($data[96]), mysql_real_escape_string($data[97]), mysql_real_escape_string($data[98]), mysql_real_escape_string($data[99]), mysql_real_escape_string($data[100]), mysql_real_escape_string($data[101]), mysql_real_escape_string($data[102]), mysql_real_escape_string($data[103]), mysql_real_escape_string($data[104]), mysql_real_escape_string($data[105]), mysql_real_escape_string($data[106]), mysql_real_escape_string($data[107]), mysql_real_escape_string($data[108]), mysql_real_escape_string($data[109]), mysql_real_escape_string($data[110]), mysql_real_escape_string($data[111]), mysql_real_escape_string($data[112]), mysql_real_escape_string($data[113]), mysql_real_escape_string($data[114]), mysql_real_escape_string($data[115]), mysql_real_escape_string($data[116]), mysql_real_escape_string($data[117]), mysql_real_escape_string($data[118]), mysql_real_escape_string($data[119]), mysql_real_escape_string($data[120]), mysql_real_escape_string($data[121]), mysql_real_escape_string($data[122]), mysql_real_escape_string($data[123]), mysql_real_escape_string($data[124]), mysql_real_escape_string($data[125]), mysql_real_escape_string($data[126]), mysql_real_escape_string($data[127]), mysql_real_escape_string($data[128]), mysql_real_escape_string($data[129]), mysql_real_escape_string($data[130]));
mysql_query($import) or die(mysql_error());
}
fclose($handle);
