[SOLVED] Delete From Flat file database ?

[chocopi]

I have recently started to code a Flat file database (just for fun) and it's going fine, but I was wondering whats the best way to delete a line from the file. I have this code below and I would like to add a delete button besides each line, which would obviously delete that line. But I do not know the best way to go around doing this as I don't know any specific functions to use.

 

<?php
$filename = "db.txt";
$lines = file($filename);
foreach($lines as $line)
{
list($id,$username,$password) = explode(",", $line);
if($id != 0)
{
	$username = ucwords($username);
	echo "{$id} {$username} {$password}<br />";
}
}
?>

 

So is there a simple function I can use I will I have to use multiple ones

 

And help/advice/guidance would be greatly appreciated,

 

Many thanks,

 

~ Chocopi

[hitman6003]

http://www.stroz.us/php/index.php?option=com_smf&Itemid=40&topic=97.0

[Barand]

With flat files you have to re-write the file. Just don't write the record you want to delete.

[chocopi]

Thanks hitman6003 for the linky, it seems like it could be very helpful.

 

@Barand: How would I go about re-writing the file or do you mean i should just use explode to single out the line and just piece it back together and write over the whole file?

 

Many Thanks,

 

~ Chocopi

[Barand]

That's right

 

<?php
$id_to_delete = 20;         // assuming that's what was selected

$filename = "db.txt";
$lines = file($filename);

$handle = fopen($filename. 'w');
foreach($lines as $line)
{
list($id,$username,$password) = explode(",", $line);
if($id != $id_to_delete)
{
	fwrite ($handle, $line);
}
}
fclose ($handle);
?> 

[chocopi]

Cheers Barand that works perfectly, I was thinking it was going to be more complex.

 

I guess thats Topic Solved then

 

Many thanks,

 

~ Chocopi