Sort a CSV file by first column 1 strictly using php or javascript

Question

This is my table which I am displaying using PHP from a CSV file

I want to sort it such that all rows of m1 come first, then a blank line, then m2 and so on.

This is my code which i use to display the CSV file as a table.

<?php
$filename = basename(__FILE__, ".php");
$f = fopen("$filename.csv", "r");
while (($line = fgetcsv($f)) !== false) {
        echo "<tr>";
        foreach ($line as $cell) {
                echo "<td>" . htmlspecialchars($cell) . "</td>";
        }
        echo "</tr>\n";
}
fclose($f);
echo "\n</tbody></table></body></html>";
?>

Rakib · Accepted Answer · 2017-09-17 15:17:51Z

2

You can use below code to render your table. This is how it works:

It creates a data array first form the CSV file
then it sorts the first column ascending order

loop through each line and render table

 $mdarray = array();
 $filename = basename(__FILE__, ".php");
 $f = fopen("$filename.csv", "r");

 while (($line = fgetcsv($f)) !== false) {
 {
    array_push($mdarray, $line);
 }
 fclose($f);

 foreach ($mdarray as $key => $row) {
    $names[$key]  = $row[0];
 }

 array_multisort($names, SORT_ASC, $mdarray);
 //array_multisort(array_column($mdarray, 0), SORT_ASC, $mdarray);//php version >=5.5

 foreach ($mdarray as $line) {
    echo "<tr>";
    foreach ($line as $cell) {
            echo "<td>" . htmlspecialchars($cell) . "</td>";
    }
    echo "</tr>\n";

   echo "<hr>"; // blank line
}

edited Sep 17, 2017 at 15:17

answered Sep 17, 2017 at 7:18

Rakib

6437 silver badges17 bronze badges

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

6 Comments

Gaurav Over a year ago

Thank you so much, but there's an error Call to undefined function array_column() and it doesn't show anything at all.

Rakib Over a year ago

Which php version are you using?

Rakib Over a year ago

I have updated my code to support older version of php

Rakib Over a year ago

@Gaurav please don't forget to mark it as accepted one so that others can get help from it in the future

Gaurav Over a year ago

is the open bracket just after the while statement necessary?!

|

Collectives™ on Stack Overflow

Sort a CSV file by first column 1 strictly using php or javascript

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related