array question...

delphipgmr

ok, this is probably not hard, but my brain is fried...

im in a rountine thats passed an array from a csv file.

$data[0]="name,city,state.zip"
$data[1]="joe,somewhere,IL,33344"
$data[2]="fred,some,IL,33344"

etc..

what i need to do is put that into a string referenced by the field name (0 is always the col names coming in).

$col["name"] = "fred"
$col["city"] = "chicago"

etc

toplay

$col = array();

// Process one at a time example. Start $i at 1 to skip heading (index 0).
for ($i=1, $cnt=count($data); $i < $cnt; $i++) {
    list($col['name'], $col['city'], $col['state'], $col['zip']) = explode(',', $data[$i]);
    // Do whatever with $col associate array variable
}

or put in separate variables like so:
list($name, $city, $state, $zip) = explode(',', $data[$i]);

delphipgmr

well that wont quite work, one of the reasons im doing this is they have multiple csv files, and the fields arent always in that order.

IE: one file might be name, city, state,zip the other might be name, state,zip, city

(there are actually more than just those fields in the file)

toplay

That would have been helpful to know that in your original post. Anyway, you need to know what field is what. You can create code to retrieve the values but how would you know what to do with each field?

Example of retrieving and displaying the data:

$data[0]="name,city,state,zip";
$data[1]="joe,somewhere,IL,33344";
$data[2]="fred,some,IL,33344";
$col = explode(',', $data[0]);
$tot_cols = count($col);

// Process one at a time example. Start $i at 1 to skip heading (index 0).
for ($i=1, $cnt=count($data); $i < $cnt; $i++) {

$value = explode(',', $data[$i]);

for ($j=0; $j < $tot_cols; $j++) {
    echo $col[$j], ' = ', $value[$j], '<br>';
}

echo '<br>'; // blank line between records
}

delphipgmr

thats not what im looking for, i need to be able to reference the value by name not number

if ($cols["City"] = "somewhere") { do something }

instead of $cols[1]..

the fields are always the same, just the order is different, so i need to go by name, not number (since number will never be the same, ie field 1 is not always city)

just like you do with a mysql recordset, only using an array instead

toplay

These forums are about learning and trying stuff out yourself. I'm surprised that you haven't figured out how to do it by the examples already provided for free.

$data[0]="name,city,state,zip";
$data[1]="joe,somewhere,IL,33344";
$data[2]="fred,some,IL,33344";
$col = explode(',', $data[0]);
$tot_cols = count($col);

// Process one at a time example. Start $i at 1 to skip heading (index 0).
for ($i=1, $cnt=count($data); $i < $cnt; $i++) {

$value = explode(',', $data[$i]);

for ($j=0; $j < $tot_cols; $j++) {
    echo $col[$j], ' = ', $value[$j], '<br>';  // Display
    $column[$col[$j]] = $value[$j];  
}

if ('somewhere' == $column['city']) {
    // do something
}

echo '<br>'; // blank line between records
}