Posted By

antpaw on 06/22/09

Tagged

Versions (?)

Last Edited at 06/22/09 07:04am

Statistics

Viewed 874 times

Favorited by 2 user(s)

Related snippets

reading CSV file with PHP

/ Published in: PHP

this script splits the csv file two times (1. on "new line", 2. on ";") and returns a two dem array in the last for loop.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
/*
your CSV should look like this:
data1;data2;data3;
data1;data2124;data3;
data1;data2564;data3;
data1;data2321;data3;
*/
 
$fileCont = join('', file('myCSV.csv'));
$fileArrN = explode("\n", $fileCont);
 
$a = 0;
foreach ($fileArrN as $value){
	$fileArrSemi[$a] = explode(";", $value);
	$a++;
}
 
$output = null;
for($i = 0; $i < sizeof($fileArrSemi); $i++){
	$output .= $fileArrSemi[$i][1]."<br />\n";
}
 
echo $output;
?>