How do I load a multi-dimensional array using a loop?

tcloud

I'm reading comma-delimited data from a .csv file and want to place it into a memory array (will attempt putting in mySQL db later).

I am already using the data -- using the file() function to read each line into a one-dimension array and then using explode() to break each value / cell out.

Now I need to compare cells from different rows, and change some of them. I need to have all the data available, not one line at a time, so I'd like to put the values into a multi-dim array.

Every example I find for loading a multi-dimensional array shows line-by-line loading, none use a loop so that the array size can be determined by the input data file.

Example code that I'm currently using -- need to convert to multi-dim array:

<?php

$d_array = file("dinput.csv") ;
$number_lines = count($d_array) ;
// strip cr-lf
for ($i=0; $i<$number_lines; $i++ ) {
	$d_array[$i] = rtrim($d_array[$i]) ;
}

//  current code -- processes one line  at a time
for ($i=0; $i<$number_lines; $i++ ) {
	$cell = explode(',', $d_array[$i]) ;
	// process stuff here ...
}

/*
 -- I now need to read all data into multi-dim array,
     so can process all lines together
 -- how do I do that?
*/
?>

thanks

Roger_Ramjet

Try this


//  current code -- processes one line  at a time
for ($i=0; $i<$number_lines; $i++ ) {
    $cell = explode(',', $d_array[$i]) ;
// now put the $cell array into an array 
    $multi[$i] = $cell;
}

dalecosp

<?php

$darray = file("./foofile");
$outarray=array();

foreach ($darray as $d) {
   $c++;
   $outarray[$c]=explode(",",$d);
}

print_r($outarray);

?>

Roger_Ramjet

Same same but different dale.

I assumed he still needs to ' // process stuff here' first then bung it into the multi-dim array.

dalecosp

Well, I see little difference. foo() where needed, of course. 😉

Didn't intentionally step on your toes. Loaded page, phone rang ... by the time I'd composed response, you were here. Pax.

Enjoyed any troll posts at zdnet lately? "Mike Cox" posted "sans sarcasm" the other day --- nobody knew what to think :rolleyes:

tcloud

thanks Roger & Dale .... this works great!

toplay

FYI:

There's fgetcsv() available:
http://us3.php.net/manual/en/function.fgetcsv.php

tcloud wrote:
"...I need to compare cells from different rows, and change some of them. I need to have all the data available, not one line at a time..."

This might be easier to manage if you create a temporary table. That way you can use SQL to compare, update or delete and not have to do everything in PHP. Then you can convert the temporary table to a permanent one.

http://dev.mysql.com/doc/mysql/en/create-table.html#id3016502

http://dev.mysql.com/doc/mysql/en/temporary-table-problems.html

🙂