|
|
Posted by Ivαn Sαnchez Ortega on 10/12/05 14:24
Tom wrote:
> I have a few products stored in a csv file created in Excel. Column 1
> is the part #, column 2 is title, column 3 is color, column 4 is width
> and 5 is price.
>
> I need to read these into arrays, with a seperate array for each
> column.
Try something like:
<?php
$lines =file('whatever.csv');
foreach($lines as $line)
{
list($partno[],$title[],$color[], ... )
= explode(',',$line);
}
?>
Keep in mind that all CSV files are not equal: some use other delimiter than
comma for separating fields, some encapsulate fields within double quotes,
etc. The above code is for a trivial CSV file.
--
----------------------------------
IvΓ‘n SΓ‘nchez Ortega -ivansanchez-arroba-escomposlinux-punto-org
TAG no encontrado... Insert disk #2
Navigation:
[Reply to this message]
|