How can PHP be used to read and manipulate CSV files effectively for data processing tasks?

To read and manipulate CSV files effectively in PHP for data processing tasks, you can use the built-in functions like fopen(), fgetcsv(), and fputcsv(). These functions allow you to open a CSV file, read its contents line by line, and manipulate the data as needed. You can then perform operations like filtering, sorting, or updating the data before writing it back to the CSV file. 

<?php

// Open the CSV file for reading
$csvFile = fopen('data.csv', 'r');

// Read and manipulate the data
while (($data = fgetcsv($csvFile)) !== false) {
    // Perform operations on the data, e.g. filtering, sorting, updating
}

// Close the CSV file
fclose($csvFile);

// Open the CSV file for writing
$csvFile = fopen('data.csv', 'w');

// Write the manipulated data back to the CSV file
// Example: writing a new row
$newRow = ['John Doe', 'johndoe@example.com'];
fputcsv($csvFile, $newRow);

// Close the CSV file
fclose($csvFile);

?>

Keywords

PHP CSV files data processing manipulation read.

Related Questions