How to Extract and Display Data from CSV Files Using PHP

In this code, we first use fopen() to open the "data.csv" file in read-only mode ("r"). Then, we use the fgetcsv() function to read the file line by line, storing each line's data into the $data array. Finally, fclose() is used to close the file.

Step 2: Displaying CSV Data

To present CSV data on a webpage as a table, we can use PHP arrays and loops. The following code demonstrates how to convert the CSV data into an HTML table:

echo "<table>";
foreach ($data as $row) {
    echo "<tr>";
    foreach ($row as $cell) {
        echo "<td>" . htmlspecialchars($cell) . "</td>";
    }
    echo "</tr>";
}
echo "</table>";

This code uses foreach to loop through each row in the $data array and generates a table row for each. It also uses htmlspecialchars() to prevent XSS attacks by escaping special characters in HTML.

Complete Code Example

Here is the complete PHP code example that combines both steps of reading and displaying CSV data:

$file = fopen("data.csv", "r");
$data = [];
while (!feof($file)) {
    $line = fgetcsv($file);
    array_push($data, $line);
}
fclose($file);

echo "<table>";
foreach ($data as $row) {
    echo "<tr>";
    foreach ($row as $cell) {
        echo "<td>" . htmlspecialchars($cell) . "</td>";
    }
    echo "</tr>";
}
echo "</table>";

This complete code reads the CSV file, stores the data as a two-dimensional array, and then loops through the array to display the data as an HTML table.

Conclusion

This article introduced how to extract and display data from CSV files using PHP. We first read the CSV file using fopen() and fgetcsv(), then use loops and HTML generation to display the CSV data in a table format. By mastering these techniques, you can efficiently handle CSV data and present it in a clean, user-friendly way.