Deleting the contents of a text file..

Anon

I have a text file that I am reading the contents of before it is emptied and re-written, how do I empty the file?

And where in the script would be a good place to do this as the file is written line by line so I know it will have to go before the loop but after it is read from - can I just put it anywhere between?

Cheers,

Tony.

Anon

Well since you need to read it line by line first, I would read it line by line and put into an array. Then close the file, open it up again and truncate it to 0. Then insert whatever you want into it.

Example:

$fd = fopen("myfile.txt", "r");
while (!feof ($fd)) {
$buffer[] = fgets($fd, 4096);
}
fclose($fd);

Now you have every line in an array.

Now you can reopen the file and truncate to 0:

$fd = fopen("myfile.text", "w");

and then write whatever you want into it.

Note: There could be an easier way of doing this without having to open the file twice but this was off the top of my head.

Derek C.

Anon

Cool - I have this so far and apart from the situ with the file it's cool.

$fileDir = "/monkey/sites/thebestbeer/downloads";
$fileUrl = "/downloads/";
if(isset ($fileUpload)) {
copy($fileUpload, "$fileDir/beerSpreadsheet.txt");
$sqlConnect = mysql_connect("localhost", "thebestbeer", "thecoolestbeer");
mysql_select_db("thebestbeer", $sqlConnect);
$query = "DROP TABLE bottled_beer";
mysql_query($query, $sqlConnect);
print "Table 'bottled_beer' has been deleted... ";
$query = "CREATE TABLE bottled_beer ( id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
uniqueId VARCHAR(25),
breweryName VARCHAR(40),
beerName VARCHAR(40),
beerStyle VARCHAR(30),
description TEXT,
percentAlcohol VARCHAR(4),
wholesalePrice VARCHAR(6),
bottlePrice VARCHAR(6),
imageName VARCHAR(20),
countryOrigin VARCHAR(15),
bottleSize VARCHAR(5),
stockAvailability VARCHAR(35)
)";
mysql_query($query, $sqlConnect);
print "Table 'bottled_beer' has been re-created... ";
$beerDataFile = "../downloads/beerSpreadsheet.txt";
$file = file($beerDataFile);
$filePointer = fopen($beerDataFile, "a") or die("Datafile has failed to open.");
while (list($key, $val) = each ($file)) {
$data = explode("\t", $val);
$query = "INSERT INTO bottled_beer ( uniqueId, breweryName, beerName, beerStyle, description, percentAlcohol, wholesalePrice, bottlePrice, imageName, countryOrigin, bottleSize, stockAvailability ) VALUES ( '$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]', '$data[5]', '$data[6]', '$data[7]', '$data[8]', '$data[9]', '$data[10]', '$data[11]' )";
mysql_query($query, $sqlConnect) or die("Actually it's here: ".mysql_error());
$beerDetails = "".$data[1]."|".$data[2]."|".$data[3]."|".$data[10]."|".$data[5]."|".$data[7]."|http://www.thebestbeer.co.uk/php-bin/beerDetails.php?uniqueId=".$data[0]."&beerName=".$data[2]."";
flock($filePointer, 1);
fputs($filePointer, "$beerDetails\n");
flock($filePointer, 3);
}
print "The table bottled_beers has been successfully populated.";
fclose($filePointer);

Where in this would that be best put?