如何将csv文件的每一行存储到php中的数组

Question

I have data in csv file as follows.

Mr,Vinay,H S,Application Engineer,[e-mail],99005809800,Yes Mr,Mahammad,Hussain,Application Engineer,[e-mail],99005809800,Yes

I want to store each row in each array.explain me how to do that

Answer 1

Assuming the CSV is a file (if not, make the CSV match the $csv, which is essentially the file broken down in the separate lines), here is a very simple way:

$csv = file('mycsv.csv'); $result = array();
//iterate the lines
foreach ($csv as $line)
  // I'd recommend  more robust "csv-following" method though (fgetcsv maybe)
  $result[] = explode(',',$result); 
//show the results
print_r($result);

Though fgetcsv is probably a safer bet (as others have mentioned) (See the docs).

---

To further extend your comment:

//iterate the lines
foreach ($csv as $line)
  // I'd recommend  more robust "csv-following" method though (fgetcsv maybe)
  $result[] = explode(',',$result); 

can become:

//iterate the lines
foreach ($csv as $line)
  // combine the current results with the new results
  $result = array_marge($result,$line);

or, if order is important:

//iterate the lines
foreach ($csv as $line)
  // add each result on to the end of the result array
  foreach($line as $val)
    // add each value
    $result[] = $val;