How to delete a row from a flat db ?

[Floodboy]

I guys I'm wondering how to delete a row from a txt file, what I was trying is something like this:

<?php
$file="test.txt";
$lines=file($file);
unset($lines[4]);  //delete line 4 from file.txt
$fp = fopen('$file', 'w');
$fw = fwrite($fp, implode('', $lines));
fclose($fp);
?>

and this is my test.txt

Hello world
Bye world
GN world
GE world
SE world
This is my World

---

But I just can't delete nothing 🙁 any ideas about how to do this ?

[tomhath]

There should be a new file in your directory named $file with the line deleted. The bug is that php will not look for variables inside single quotes, only double quotes.

Change this line:

$fp = fopen('$file', 'w');

To this:

$fp = fopen("$file", 'w');

[Weedpacket]

Better yet, drop the quotes completely - $file is already a string so why go to the effort of converting it into a string?

[mogster]

Well, I usually compile a new string in a loop:

<?php
$file="test.txt";
$lines=file($file);
for($i=0;$i<sizeof($lines);$i++) {
if($lines[$i] != "" && $lines[$i] != $lines[4]) {
trim($lines[$i]);
$filestring .= $lines[$i] . "\n";
}
}
$fp = fopen("$file", "w");
$fw = fwrite($fp, $filestring);
fclose($fp);
?>

knutm