Menu
Community /Pin to ProfileBookmark
@NogDogFeb 17.2008 — #
This will result in $info being a 2-dimension array. You would then reference a particular value as $info[3]['field name'] where "3" is the desired row number and 'field name' is the applicable column name from the header row.@NogDogFeb 17.2008 — #Yeah, I changed the variable name at some point and missed all its uses:
Appending an Array
Hi,
I want to grab data from a .csv file and add all the data to the array. I have the part where I’m grabbing the data from the .csv file but the array issue I haven’t totally figured out.
Currently, I’m not adding all the data just the last row of data to the array and need help trying to add all the data to the array. Can someone please help me accomplish this. This is what I have:
[code=php]
global $info;
ini_set(“auto_detect_line_endings”, 1);
$current_row = 1;
$handle = fopen(“adduser.csv”, “r”);
$info=””;
while ( ($data = fgetcsv($handle, 10000, “,”) ) !== FALSE )
{
$number_of_fields = count($data);
if ($current_row == 1)
{
//Header line
for ($c=0; $c < $number_of_fields; $c++)
{
$header_array[$c] = $data[$c];
}
}
else
{
//Data line
for ($c=0; $c < $number_of_fields; $c++)
{
$data_array[$header_array[$c]] = $data[$c];
}
print_r($data_array);
$info = $data_array;
}
$current_row++;
}
//buildBatchXML($data_array);
echo “<br><br>This is new data:<br><br>”;
foreach($info as $key => $value)
{
echo “$key – $value<br>”;
}
fclose($handle);
?>
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogFeb 17.2008 — #[code=php]
$headers = array();
$info = array();
$current_row = 0;
while ( ($data = fgetcsv($handle, 10000, ",") ) !== FALSE )
{
if ($current_row++ == 0)
{
//Header line
foreach ($row as $value)
{
$headers[] = $value;
}
}
else
{
//Data line
foreach ($row as $key => $value)
{
$info[$counter][$headers[$key]] = $value;
}
}
}
[/code]This will result in $info being a 2-dimension array. You would then reference a particular value as $info[3]['field name'] where "3" is the desired row number and 'field name' is the applicable column name from the header row.
0
@NogDogFeb 17.2008 — #Yeah, I changed the variable name at some point and missed all its uses:[code=php]
$headers = array();
$info = array();
$current_row = 0;
while ( ($data = fgetcsv($handle, 10000, ",") ) !== FALSE )
{
if ($current_row++ == 0)
{
//Header line
foreach ($row as $value)
{
$headers[] = $value;
}
}
else
{
//Data line
foreach ($row as $key => $value)
{
$info[$current_row][$headers[$key]] = $value;
}
}
}
[/code]