PHP writing to .txt file

[Rusty_Bad_Robot]

I have a counter which takes it value from a .txt file - This value comes from the sum of a MySQL field - This script gets that value all I need to do is write it to the .txt??

 

<?php

// Make a MySQL Connection

 

$host="localhost";//hostname

$username="root";//username

$password="";//db_password

$db_name="db_name";//database name

 

//connect to database

mysql_connect("$host","$username","$password")or die("cannot connect to server");

mysql_select_db("$db_name")or die("cannot select database");

 

$query = "SELECT SUM(field) FROM table";

 

$result = mysql_query($query) or die(mysql_error());

 

// Print out result

while($row = mysql_fetch_array($result)){

echo $row['SUM(field)'];

echo "<br />";

}

?>

[trq]

fopen, fwrite & fclose.

[Rusty_Bad_Robot]

Thanks - It works great! I now need it to overwirite the file contents instead of just adding more information?

 

// Get Result

while($row = mysql_fetch_array($result)){

$filename = 'counter.txt';

$somecontent = $row['SUM(field)'];

}

 

// Let's make sure the file exists and is writable first.

if (is_writable($filename)) {

 

    // In our example we're opening $filename in append mode.

    // The file pointer is at the bottom of the file hence

    // that's where $somecontent will go when we fwrite() it.

    if (!$handle = fopen($filename, 'a')) {

        echo "Cannot open file ($filename)";

        exit;

    }

 

    // Write $somecontent to our opened file.

    if (fwrite($handle, $somecontent) === FALSE) {

        echo "Cannot write to file ($filename)";

        exit;

    }

 

    echo "Success, wrote ($somecontent) to file ($filename)";

 

    fclose($handle);

 

} else {

    echo "The file $filename is not writable";

}

[Rusty_Bad_Robot]

o.k just me being silly - had to change the mode for fopen.

 

Thanks for your help.

 

-Peace out -