PHP: Delete multiple lines from CSV

Question

I would like to delete multiple lines from a CSV file.

I have an array (called $manual) setup:

Array
(
    [0] => A
    [1] => B
    [2] => C
    ...

My CSV looks like this:

A;3h2jhkj
B;ewrwer
C;fsfsdf
D;adsfsdf
E;sdfet
F;35435345f

My code to delete the lines are (not working):

foreach ($manual as $filename) {
        $table = fopen('logs/error.log','r');
        $temp_table = fopen('logs/error_temp.log','wa+');

        while (($data = fgetcsv($table, 2048, ";")) !== FALSE) {
            if($data[0] == $filename){
                continue;
            }
            fputcsv($temp_table,$data);
        }
        fclose($table);
        fclose($temp_table);
        //$done = "YES";
    }

I realise why it's not working but can't get it to work.

What I want is all lines in the CSV that have a first column matching a value in the array to be deleted so the resulting CSV file from the above would yield:

D;adsfsdf
E;sdfet
F;35435345f

matching (exect) something in the array, will be in_array

Oleg Butuzov
– Oleg Butuzov

2019-07-28 16:12:22 +00:00
Commented Jul 28, 2019 at 16:12 — Oleg Butuzov
– Oleg Butuzov, Commented Jul 28, 2019 at 16:12

Oleg Butuzov · Accepted Answer · 2019-07-28 16:30:38Z

2

You don't need to iterate $manual, just check if value in the $manual.

$table = fopen('logs/error.log','r');
$temp_table = fopen('logs/error_temp.log','wa+');

while (($data = fgetcsv($table, 2048, ";")) !== FALSE) {
    if(in_array($data[0], $manual, true)){
        continue;
    }
    fputcsv($temp_table,$data);
}
fclose($table);
fclose($temp_table);

edited Jul 28, 2019 at 16:30

answered Jul 28, 2019 at 16:14

Oleg Butuzov

5,4152 gold badges31 silver badges39 bronze badges

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

3 Comments

pee2pee Over a year ago

Thanks - I wouldn't have to negate it would I as I am saying if it was in the array then I don't want it...

Oleg Butuzov Over a year ago

I miss that. Fixed.

pee2pee Over a year ago

Thanks - when reading my question out I sorted but thanks for the reply

Collectives™ on Stack Overflow

PHP: Delete multiple lines from CSV

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related