current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite
1

I am new to PHP and would like to be able to read in a csv file which has two columns, one is the number (kind of like a ID) then the other holds a integer value. I have looked up the fgetcsv function but I have not been able to find a way to read a specific column from the csv file.

I would like to get all the values from the second column only, without the heading.

Any way of doing this?

This is what I have so far:

$file = fopen('data.csv', 'r');
$line = fgetcsv($file);

And this is some sample data from the csv file:

ID,Value
1,243.00
2,243.00
3,243.00
4,243.00
5,123.11
6,243.00
7,180.00
8,55.00
9,243.00

Any help would be appreciated.

Thanks.

share|improve this question

4 Answers 4

up vote 3 down vote

fgetcsv() only reads a single line of the file at a time. You'll have to read the file in a loop to get it all:

$data = array();
while($row = fgetcsv($file)) {
   $data[] = $row;
}

The heading you can skip by doing an fgetcsv once outside the loop, to read/trash the header values. And if you only want the second column, you can do:

   $data[] = $row[1];

However, since you've got data in there, maybe it might be useful to keep it, plus key your new array with the ID values in the csv, so you could also have:

   $data[$row[0]] = $row[1];

and then your nice shiny new array will pretty much exactly match what's in the csv, but as an array keyed by the ID field.

share|improve this answer
    
This doesn't seem to work. I have initiated the array, then done the fopen like in my post, then the loop that you have mentioned but using row[1] but it does not run. Any ideas or am I doing something stupid? Thanks for your reply. –  Josh Pullin Aug 17 '12 at 16:16
    
you get nothing at all in $data, or a bunch of blanks? Try doing a var_dump($row) inside the loop, and make sure that the file is properly opened (fopen will return a boolean false on failure, not a file handle). –  Marc B Aug 17 '12 at 16:18
    
Did the var_dump($row[1]) and it prints the whole of that column not just the single value? Here is some of what it prints: string(6) "243.00" string(6) "243.00". What I need now is all those values in a separate array? –  Josh Pullin Aug 17 '12 at 17:35
    
That'd be weird if it prints a whole column of volumes - fgetcsv only reads one LINE of data. better make sure that the input file's line terminators (\r, \n, etc...) are correcct.e .g. reading a windows text file on a unix machine). check php.net/fgetcsv to specify which chars to use for all that. –  Marc B Aug 17 '12 at 17:41
    
Okay thanks. I am running this on a MacBook Pro using MAMP so could that be a reason? Also if it is just reading the second column using $row[1], the values in the csv file do not have a comma after. Could that be another reason? –  Josh Pullin Aug 17 '12 at 17:54
up vote 1 down vote 
$csv = array_map("str_getcsv", file("data.csv", "r")); 
$header = array_shift($csv); 
// Seperate the header from data

$col = array_search("Value", $header); 
 foreach ($csv as $row) {      
 $array[] = $row[$col]; 
}
// Iterate through data set, creating array from Value column
share|improve this answer
    
your first line just does fgetcsv() the hard way. –  Spudley Aug 18 '12 at 10:18
    
@Spudley: "The hard way" gets the whole file with one line of code. –  cHao Dec 12 '12 at 16:17
up vote 1 down vote 
$header = fgetcsv($h);
$rows = array();
while ($row = fgetcsv($h)) {
    $rows []= array_combine($header, $row);
}
share|improve this answer
up vote 0 down vote

You can also use this class http://code.google.com/p/php-csv-parser/

<?php

require_once 'File/CSV/DataSource.php';

$csv = new File_CSV_DataSource;
$csv->load('data.csv');
var_export($csv->connect());

?>
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.