How to return specific rows from a csv file and put them into array

Question

I'm basically wondering how to get specific rows from a csv file (lets say the file has 5000 rows I want to get the values of the second column from rows 3023 - 3311). Upon obtaining these column values I want to put them into a php array.

What I've tried so far:

 $search = $this->uri->segment(3); // get the row number    
 $row1 = 0;

   if (($handle = fopen("Folder/Data.csv", "r")) !== FALSE)
    {
        while (($data1 = fgetcsv($handle, 1000, ",")) !== FALSE)
        {
            $num1 = count($data1); // number of data rows
            $row1++;
            for ($c=0; $c < $num1; $c++) {



                echo $data1[$c+1]; // to return second row


            }
        }
        fclose($handle);

But that only returns one single row and I need to return around 200 and put them into an array. Any help is greatly appreciated!

Lloyd Banks · Accepted Answer · 2016-03-29 16:35:03Z

1

You're pretty close. You don't need to run a for loop inside of your while loop. You can use something like this:

$file = fopen('/path/to/file', 'r');

// Helps us keep tabs on the row we are on
$rowCount = 0;
// Array that stores all of our column values.  In this case, I'll be gathering 
// values from the second column
$secondColumnArray = array();
while(false !== ($rowData = fgetcsv($file))){
    if($rowCount >= 50 && $rowCount <= 100){
        array_push($secondColumnArray, $rowData[1]);
    }
    $rowCount = $rowCount + 1;
}

print_r($secondColumnArray);

fclose($file);

In the above example, my array contains values from the second column of rows 50 to 100. Change the parameters to fit your criteria.

answered Mar 29, 2016 at 16:35

Lloyd Banks

36.9k58 gold badges172 silver badges264 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to return specific rows from a csv file and put them into array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related