How to stop foreach loop from printing duplicate data?

Question

I am trying to generate unique CSV files from the csv data that I have using the following loop.

 $k =1;
 foreach ($csv_tbl as $_csv) {
        $filename = "Agent_" . $k . ".csv";
        $file_path = "agents/$filename";
        file_put_contents($file_path, $_csv);
        if (file_exists($_csv)) {
            header('Content-Description: File Transfer');
            header('Content-type: text/csv');
            header('Content-Disposition: attachment; filename=' . $filename);
            header('Expires: 0');
            header('Cache-Control: must-revalidate');
            header('Pragma: public');
            header('Content-Length: ' . filesize($_csv));
            readfile($_csv);
            die();
        }
        $k++;
    }

The first file generated is perfect and only has the data it should have i.e the first csv table. The second file has both the first and the second tables this goes on for all my 21 files which means the 21st file will have all the tables.

Visual example of the first two files.

Agent_1.csv Agent_2.csv

How can I prevent duplicates tables from my csv file?

Mh, ok, then I would try checking every row against the time row, assuming it is unique, and remove the subsequent occurrencies... you could fill a multidimensional array using the csv id as key, and inside time as the key and the rest of the data as value... I'm not that sure about that, though. — Masiorama
– Masiorama, Commented Jun 16, 2015 at 10:05
To answer your question we need to know what is $k and $csv_tbl — kulaeff
– kulaeff, Commented Jun 16, 2015 at 10:07
@kulaeff $csv_tbl is an array that contains all my csv data. $k is an int $k=1. — b0w3rb0w3r
– b0w3rb0w3r, Commented Jun 16, 2015 at 10:10

Arsh Multani · Accepted Answer · 2015-06-16 10:36:21Z

1

As your foreach is printing duplicates , it means that your array $csv_tbl contains duplicate values, you can remove duplicate values from array using array_unqiue But also by looking at the screenshots i can see that the callid is different for every record. do your csv contain duplicates?::

 $k =1;
 $csv_tbl = array_unique($csv_tbl);
 foreach ($csv_tbl as $_csv) {
        $filename = "Agent_" . $k . ".csv";
        $file_path = "agents/$filename";
        file_put_contents($file_path, $_csv);
        if (file_exists($_csv)) {
            header('Content-Description: File Transfer');
            header('Content-type: text/csv');
            header('Content-Disposition: attachment; filename=' . $filename);
            header('Expires: 0');
            header('Cache-Control: must-revalidate');
            header('Pragma: public');
            header('Content-Length: ' . filesize($_csv));
            readfile($_csv);
            die();
        }
        $k++;
    }

answered Jun 16, 2015 at 10:36

Arsh Multani

1,5911 gold badge11 silver badges31 bronze badges

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

1 Comment

b0w3rb0w3r Over a year ago

After some further investigation you're definitely right about this array does indeed have duplicates.

Collectives™ on Stack Overflow

How to stop foreach loop from printing duplicate data?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related