delete row with specific parameter of csv with php

Question

I tried a lot of things, but none of them seems to work properly... This is the csv file:

and this is my code:

                $file_handle = fopen('file.csv', 'r+'); 
                $positionID = 47901392; 
                while ($data = fgetcsv ($file_handle, 1000, ";")) {
            
                    $prod_id  =  $data[0];

                    if($prod_id ==$positionID){
                        echo "prod_id $prod_id ";
                        echo "I have to delete row";
                    }
                    
                    
                }

I have to delete row with specific $positionID.

Barmar · Accepted Answer · 2022-07-22 17:47:34Z

1

Open another file to hold the new file with the lines deleted. Then have your loop write everything that isn't deleted to that file.

$file_handle = fopen('file.csv', 'r');
$out_handle = fopen('new_file.csv', 'w');
$positionID = 47901392; 
while ($data = fgetcsv ($file_handle, 1000, ";")) {
    $prod_id  =  $data[0];

    if($prod_id ==$positionID){
        echo "prod_id $prod_id ";
        echo "I have to delete row";
    } else {
        fputcsv($out_handle, $data);
    }
}
fclose($file_handle);
fclose($out_handle);
rename('new_file.csv', 'file.csv');

answered Jul 22, 2022 at 17:47

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

delete row with specific parameter of csv with php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related