How can PHP be utilized to only display data within a specific time range from a CSV file?

To only display data within a specific time range from a CSV file using PHP, you can read the CSV file, iterate through each row, and check if the data falls within the desired time range. You can use the strtotime function to convert the date in the CSV file to a timestamp for comparison. Finally, display only the data that meets the time range criteria. 

<?php

// Specify the start and end time range
$start_time = strtotime('2022-01-01');
$end_time = strtotime('2022-12-31');

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

// Read and display data within the specified time range
while (($row = fgetcsv($csv_file)) !== false) {
    $row_time = strtotime($row[0]); // Assuming the date is in the first column
    if ($row_time >= $start_time && $row_time <= $end_time) {
        echo implode(', ', $row) . PHP_EOL;
    }
}

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

?>

Keywords

PHP CSV file time range data filtering strtotime

Related Questions