Deleting inside of a txt file with php

Dakkar

I designed a php file which will read data from a txt file and insert it into mysql but i want after inserting the data into mysql delete everything inside of the txt file is that possible? if it is how?

my php file is like this

<? 
@mysql_connect("localhost", "Dakkar", "") 
    or die("Veritabani ile baglanti kurulamadi!"); 
@mysql_select_db("uopvp") 
    or die("Veritabaninda bir hata olustu!"); 

$lines = file("pvp.txt");


$i=0; 
foreach ($lines as $line_num => $line) {
$i++; 
}

for ($x=0;$x<$i;$x++) { 
list($account, $name, $puan, $kills, $guild) = explode(" ",$lines[$x]); 
$sql = "SELECT count(*) FROM pvp WHERE  account='$account' and name='$name' ";  

$res = mysql_query($sql) OR die(mysql_error());  

$row = mysql_fetch_row($res); 
   if($row[0] == 0) { 
   @mysql_query("insert into pvp  values('','$account','$name','$puan','$guild','$kills','')"); 
   echo "<center><b>Veriler Kaydedildi.Tesekkurler.</b></center>"; 
   } 
   else { 
   mysql_query("UPDATE pvp SET puan='$puan' WHERE account='$account' and name='$name'"); 
   mysql_query("UPDATE pvp SET guild='$guild' WHERE account='$account' and name='$name'"); 
   mysql_query("UPDATE pvp SET kills='$kills' WHERE account='$account' and name='$name'"); 
   echo "<center><b>Veriler Guncellendi.Tesekkurler.</b></center>"; 
   } 
}

// I want to add the deleting line here
?>

nemonoman

[man]fopen[/man] the file for writing, [man]fwrite[/man] an empty string, [man]fclose[/man] the file.

Dakkar

I tried this but i got an error

$dosya = fopen("pvp.txt","w");
fwrite( );
fclose($dosya);

and the error is this:

Warning: Wrong parameter count for fwrite() in C:\Program Files\Apache Group\Apache2\htdocs\pvp\gecir.php on line 31

devinemke

$dosya = fopen('pvp.txt', 'w');
fwrite($dosya, '');
fclose($dosya);

tommynanda

Another way might be..

unlink("pvp.txt"); // This will delete the file
$dosya=fopen("pvp.txt","w"); //This should create a new file if u want a empty txt file
fclose($dosya);

Good Luck
TommYNandA

Dakkar

Originally posted by tommynanda
Another way might be..
unlink("pvp.txt"); // This will delete the file
$dosya=fopen("pvp.txt","w"); //This should create a new file if u want a empty txt file
fclose($dosya);
Good Luck
TommYNandA [/B]

thanks so much that was the thing that i want.And it worked fine