How can I delete a line from a file if it contains a certain string using PHP?

Question

I have a Delete link in my profile page which links to "delete.php?snum=" . $snum. I have a $snum=$_GET['snum']; in delete.php. I have a file named "SLBrecords.csv" which looks like

12345 Barney
67890 Stinson

and I would like to create a script that would search for $snum in the file and delete the line that contains it. I think this is easy but I keep messing with implode, strpos, and other functions now but I'm still not able to make it work.

EDIT: Here is my code.

<?php

$snum=$_GET['snum'];

$filePath = './SLBrecords.csv';

$fileArr = file( $filePath );

foreach($fileArr as $line)
    if (strpos($line,$snum) !== false) {
        unset($line);
    }
$success = FALSE;
if ( file_put_contents( $filePath, implode( '', $fileArr ), LOCK_EX ) )
{
    $success = TRUE;
}

?>

Edit: How can I delete the line and also delete the newline that comes with it?

I am using Apache in this web application that's why it was in the tags earlier, but for some unknown reason somebody edited the tags and added "mysql" to it. — Gannicus
– Gannicus, Commented Apr 16, 2013 at 7:19

Ildar · Accepted Answer · 2013-04-16 07:11:33Z

1

unset($line) is wrong. Try

foreach($fileArr as $k=>$line) {
    if (strpos($line,$snum) !== false) {
        unset($fileArr[$k]);
    }
}

answered Apr 16, 2013 at 7:11

Ildar

7962 gold badges15 silver badges36 bronze badges

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

4 Comments

Gannicus Over a year ago

Sweet! It works like a charm. However, a newline is left from the deletion. Can I add anything to this code that does that?

Gannicus Over a year ago

I tried adding trim(preg_replace('/\s\s+/', ' ', $fileArr[$k])); after unset but it still doesn't work in some cases.

Ildar Over a year ago

I think something wrong with csv file. Try this: $fileArr = file( $filePath, FILE_SKIP_EMPTY_LINES);

Gannicus Over a year ago

Nope, newline still there :/

Collectives™ on Stack Overflow

How can I delete a line from a file if it contains a certain string using PHP?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related