reading CSV file with PHP - PHP Snipplr Social Repository

Revision: 15038

at June 22, 2009 07:05 by antpaw

Updated Code

<?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;
?>

Revision: 15037

at June 22, 2009 07:04 by antpaw

Initial Code

<?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;
?>

Initial URL

Initial Description

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.

Initial Title

reading CSV file with PHP

Initial Tags

php, csv

Initial Language

PHP

Choose a language for easy browsing: