How would I sort and array by its values in php

Question

I have this array called $csv, it contains cars that have year, make and model.

function readCSV($csvFile){
$file_handle = fopen($csvFile, 'r');
while (!feof($file_handle) ) {
    $line_of_text[] = fgetcsv($file_handle, 1024);
}
fclose($file_handle);
return $line_of_text;
}


// Set path to CSV file
$csvFile = 'csv/file.csv';
$csv = readCSV($csvFile);
array_shift($csv); 

foreach($csv as $car){

$year = $car[3];
$make = $car[4];
$model = $car[5];

echo $year;
}

This gives me - 2011 2009 2012 2012 2013

How would I filter the results to display in order by newest to oldest?

didn't you post something related earlier? stackoverflow.com/questions/35108849/… — Funk Forty Niner
– Funk Forty Niner, Commented Jan 31, 2016 at 2:09
Earlier I wanted to get the count for inventory based on how long I have had each car. This is for displaying the inventory itself in a feed. It displays now but I want to know how to filter the results. — Ryan D
– Ryan D, Commented Jan 31, 2016 at 2:12
Have a look at the many sorting functions that PHP has to offer php.net/manual/en/array.sorting.php - php.net/manual/en/function.sort.php — Funk Forty Niner
– Funk Forty Niner, Commented Jan 31, 2016 at 2:14
then these Q&A's stackoverflow.com/q/1272494 - stackoverflow.com/q/11649840 — Funk Forty Niner
– Funk Forty Niner, Commented Jan 31, 2016 at 2:16

Ajk_P · Accepted Answer · 2016-01-31 03:22:38Z

1

$years = [];
foreach($csv as $car){
    $years[] = $car[3];
}

rsort($years);

foreach($years as $year) {
    echo $year;
}

If you need low-to-high sorting use sort instead of rsort.

edited Jan 31, 2016 at 3:22

answered Jan 31, 2016 at 3:20

Ajk_P

1,88418 silver badges23 bronze badges

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

3 Comments

Ryan D Over a year ago

Perfect thank you just the answer I was looking for!

Ryan D Over a year ago

how would I add other values from the same column as the year like "make" ?

Ajk_P Over a year ago

do you want to keep them sorted by year too? If so you have a few options: 1. create an array with year as keys, and other data on values and sort on the keys. 2. (Best IMO). Simply create a sort function. If you don't care about the original array $csv, you could directly sort that based on the third column. Take a look at this - php.net/manual/en/array.sorting.php

Collectives™ on Stack Overflow

How would I sort and array by its values in php

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related