phelix Posted November 15, 2010 Share Posted November 15, 2010 Ok, I have a .csv file. the first key in the array is the name of the tables. the rest of the info is the data that needs to be put into my mysql database. Here is an example of what my array looks like. Array ( [0] => Array ( [0] => RECORD_TYPE [1] => BORROWER_FIRST_NAME [2] => BORROWER_MIDDLE_NAME [3] => BORROWER_LAST_NAME [4] => BORROWER_SUFFIX_NAME [5] => BORROWER_COMPANY_NAME [6] => LENDER [7] => LENDER_ADDRESS [8] => LENDER_CITY [9] => LENDER_STATE [10] => LENDER_ZIP [11] => LENDER_PHONE_NO [12] => TRUSTEE [13] => TRUSTEE_ADDRESS [14] => TRUSTEE_CITY [15] => TRUSTEE_STATE [16] => TRUSTEE_ZIP [17] => TRUSTEE_PHONE_NO [18] => PROPERTY_DESCRIPTION [19] => CASE_NO [20] => LOAN_NO [21] => LOAN_DOC_NO [22] => FORECLOSURE_DOC_NO [23] => FORECLOSURE_BOOK [24] => FORECLOSURE_PAGE [25] => PARCEL_ID_NO [26] => TRUSTEE_SALE_NUMBER [27] => SITUS_ADDRESS [28] => SITUS_UNIT_NO [29] => SITUS_CITY [30] => SITUS_COUNTY [31] => SITUS_STATE [32] => SITUS_ZIP [33] => APPRAISED_VALUE [34] => MINIMUM_BID [35] => JUDGMENT_AMOUNT [36] => LOAN_AMOUNT [37] => LOAN_BALANCE [38] => DATE_OF_LOAN [39] => INT_RATE [40] => PAYMENT [41] => MATURITY [42] => AUCTION_DATE [43] => AUCTION_TIME [44] => AUCTION_ADDRESS [45] => AUCTION_CITY [46] => LEGAL_DESCRIPTION [47] => RECORDING_DATE ) [1] => Array ( [0] => T [1] => KATHLEEN [2] => [3] => PHILLIPS [4] => [5] => [6] => NATIONSTAR MORTGAGE, LLC [7] => JUST LAW, INC [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => [18] => COMM [19] => [20] => [21] => [22] => [23] => [24] => [25] => S1134120670 [26] => [27] => 11101 W. AMITY RD [28] => [29] => BOISE [30] => BOISE [31] => ID [32] => 83709 [33] => [34] => [35] => [36] => [37] => $91,325.12 [38] => [39] => 7.88% [40] => [41] => [42] => 9/10/2010 [43] => 11:00 AM [44] => 9465 W. EMERALD ST., STE. 260 [45] => BOISE [46] => COMMENCING AT THE NORTH QUARTER CORNER OF SECTION 34, TOWNSHIP 3 NORTH, RANGE 1 EAST [47] => 5/10/2010 ) [2] => Array ( [0] => T [1] => ARNEL [2] => T [3] => BERMUDO [4] => [5] => [6] => NATIONSTAR MORTGAGE LLC [7] => JUST LAW, INC [8] => [9] => [10] => [11] => [12] => [13] => [14] => [15] => [16] => [17] => [18] => RSFR [19] => [20] => [21] => [22] => [23] => [24] => [25] => [26] => [27] => 5718 N. MILLDAM PL [28] => [29] => GARDEN CITY [30] => BOISE [31] => ID [32] => 83714 [33] => [34] => [35] => [36] => [37] => $109,781.84 [38] => [39] => 6.88% [40] => [41] => [42] => 9/3/2010 [43] => 11:00 AM [44] => 9465 W. EMERALD ST., STE. 260 [45] => BOISE [46] => LOT 12 IN BLOCK 3 OF MILLSTREAM NO. 1 SUBDIVISION, ACCORDING TO THE PLAT THEREOF [47] => 5/10/2010 ) Here is the code that I am trying. Obviously its not working properly. $tablenames = $data2DArray[0]; unset($data2DArray[0]); $i=0; foreach ($tablenames as $tablename){ foreach($data2DArray as $datakey => $data){ echo "{$tablename}={$data[$i]}<br>"; } $i++; } -------------------------------------- Basically I need this to turn into a usable mysql insert query. Need to be able to insert into mysql_table set RECORD_TYPE='T', BORROWER_FIRST_NAME='KATHLEEN' etc Link to comment https://forums.phpfreaks.com/topic/218756-help-with-a-php-loop/ Share on other sites More sharing options...
AbraCadaver Posted November 15, 2010 Share Posted November 15, 2010 Those are actually column names not tables names. Not tested, but this should be easier (note the different insert syntax): $columns = "`" . implode("`,`", $data2DArray[0]) . "`"; unset($data2DArray[0]); foreach($data2DArray as $data) { $values = array_map('mysql_real_escape_string', $data); $values = "'" . implode("','", $values) . "'"; $query = "INSERT INTO table_name ($columns) VALUES ($values)"; // run query } Link to comment https://forums.phpfreaks.com/topic/218756-help-with-a-php-loop/#findComment-1134605 Share on other sites More sharing options...
phelix Posted November 15, 2010 Author Share Posted November 15, 2010 Wow, I think that did it. Thank you soo much! Link to comment https://forums.phpfreaks.com/topic/218756-help-with-a-php-loop/#findComment-1134611 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.