Reading csv file returns wrong data after updating csv file content

Question

I have a csv file named data1.csv. The first time i use php to read the csv file content I can get the contents correctly. The problem is I cannot read the new data after I update the data in data1.csv. It keeps returning the previous data. What could be the wrong?

    $file_handle = fopen($csvFile, 'r');
    if(!$file_handle) die("Can't open file");

    while (!feof($file_handle) ) {
      $line_of_text[] = fgetcsv($file_handle, 0, $csv_spliter);

    }

    clearstatcache();

    fclose($file_handle);
    $file_content = $line_of_text;

Is the code from the read that works? Could you show the one that is not working and how you update the csv file? — Roland Starke
– Roland Starke, Commented Nov 5, 2018 at 12:57
This code can read the csv content. The csv is updated manually — ovicko
– ovicko, Commented Nov 5, 2018 at 13:00
Do you also get the old data if you completely delete the file? If it only affects new lines it could be a line ending problem. — Roland Starke
– Roland Starke, Commented Nov 5, 2018 at 13:03
@ovicko That's your problem right there. See this question: stackoverflow.com/questions/511476/… — kmoser
– kmoser, Commented Nov 5, 2018 at 13:34

kmoser · Accepted Answer · 2018-11-05 14:45:15Z

1

Since you are retrieving data via http/https, it is most likely being cached. See Does PHPs fopen function implement some kind of cache?

answered Nov 5, 2018 at 14:45

kmoser

9,3693 gold badges28 silver badges45 bronze badges

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

3 Comments

ovicko Over a year ago

I have tried using solutions stated still no difference

kmoser Over a year ago

Did you try adding a unique query string to the URL every time you attempted to fetch it, e.g. https://example.com/feed/data1.csv?12345?

kmoser Over a year ago

@ovicko If my answer works for you, please consider marking it as the accepted answer, thanks!

Collectives™ on Stack Overflow

Reading csv file returns wrong data after updating csv file content

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