php - Retrieve multiple lines within same cell from CSV file -
i trying retrieve data csv file. used following code go through csv:
//create array csv file $array_data = array(); $row = 0; if (($handle = fopen("import/pdf_data.csv", "r")) !== false) { // read csv root folder "web/interval/import" while (($data = fgetcsv($handle, 0, ";")) !== false) { if ($row > 0) { $array_data[$row] = $data; } $row++; } fclose($handle); } //loop through feature data array foreach ($array_data $entry_value => $array_column) { foreach( $array_column $value ) { //split data list($col1,$col2,$col3) = explode( ',', $value ); echo "name: ".$col1.", surname: ".$col2.", text: ".$col3."<br/>"; when print columns... col1 , col2 fine have 1 single value in cells. col3 may contain multiple lines. let's example (see below 1 cell of col3):
col3 :::::::::::::: text-a in line 1 text-a in line 2 text-a in line 3 if there multiple lines within 1 cell csv output this: "text-a in line 1text-a in line 2text-a in line 3"
and code use above prints first line "text-a in line 1 in new entry second line etc etc.
what want achieve following format
echo "name: ".$col1.", surname: ".$col2.", text: ".$col3."<br/>"; which doesn't work multiple lines this:
- name: test, surname: test2, text: "text-a in line 1
- name: , surname: , text: text-a in line 2
any suggestions appreciated, thank you
a csv file may contain multi-line value in cell. needs enclosed in quotes. excel correctly - create test file , save csv. php function fgetcsv can read such files correctly.
example file:
"col1","col2","col3" "test1","test2.1 test2.2 test2.3","test3" the second column in second row contains multi-line value , valid csv file.
here correct code:
$array_data = array(); $row = 0; if (($handle = fopen("import/pdf_data.csv", "r")) !== false) { // read csv root folder "web/interval/import" while (($data = fgetcsv($handle, 0, ",")) !== false) { if ($row > 0) { $array_data[$row] = $data; } $row++; } fclose($handle); } //loop through feature data array foreach ($array_data $row) { list($col1,$col2,$col3) = $row; echo "name: ".$col1.", surname: ".$col2.", text: ".$col3."<br/>"; }