PHP - Pages Not Saving Using File() Fopen() Fwrite() Fclose()

Hey guys,


I have a script that is run once a week to fetch some user info for a large number of accounts.
The code I have now writes the info correctly, but I was wondering if there was an easy way to have the accountdata.txt file completely wiped before new updated info is written to it, as opposed to deleting it manually every week.

        $FileName = "accountdata.txt";

$f=fopen($FileName,"a+");

fwrite($f, $UserKey[$i]." ".$SigKey[$i]."\n");

$f=fclose;


I could in theory just open the file and delete everything in it manually, save it and then run this script, but I'm always looking for more ways to make things efficient, and come a time when it's run more than once a week it'd be nice to have all that automated.

So in summary, I need it to delete all data (if any) from the accountdata.txt file before it writes anything to it.

Thanks.

Code: [Select]
if(isset($_COOKIE['ID_my_site']))
{
$username = mysql_real_escape_string( $_COOKIE['ID_my_site'] );
$pass = mysql_real_escape_string( $_COOKIE['Key_my_site'] );

$check = mysql_query("SELECT * FROM users WHERE username = '$username' AND password = '$pass'")or die(mysql_error());

while($info = mysql_fetch_array( $check ))
{
if ($pass == $info['password'])
echo "$username";
}
}

  if (isset($_POST['submit'])) {
 
$firstname = ($_POST['firstname']);
$lastname = ($_POST['lastname']);


$filename = "***/$username.info.php" or exit("Unable to open file!");
$handle = @fopen($filename, 'x+')or die(mysql_error());
$content = "nothing i enter here gets inserted into the file";
@fwrite($handle, $content)or die(mysql_error());
@fclose;
}

Greetings all,

I'm completely stumped...so I'd like to run this issue by you guys (and gals!).
I have encountered an odd issue, and I have no idea why this is doing what it's doing.

When I execute the following code, all by itself, in an "index.php" file (with no other files around...completely isolated!)
I get a result of "testtest" 


$log_file = 'all.txt';
$handle = fopen($log_file, 'a');
fwrite($handle, 'test');
fclose($handle);


Note: I delete the file each time I execute the script (in a browser). I am also the only one running this script.

I've tried running on PHP 5.2.x and PHP 5.3.x
I have also tried on my machine as well as a separate, remote machine.

Is the script running twice?
If so, what's causing it?

Any help is appreciated as always!

Ryan

$DOCUMENT_ROOT=$_SERVER['DOCUMENT_ROOT'];

$outputstring = $date."\t".$tireqty." tires \t".$oilqty."oil\t".$sparkqty."
                spark plugs\t\$".$totalamount."\t".$address."\n";

//open file for appending
@$fp = fopen('$DOCUMENT_ROOT/../orders/orders.txt', 'ab');
if (!$fp)
{
    echo '<p><strong>Your order can not be processed at this time.
                    Please try again later</strong></p></body></html>';
    exit;   
}
//write to file 
fwrite($fp, $outputstring, strlen($outputstring));
flock($fp, LOCK_UN);
fclose($fp);


Can someone please explain to me why this Code is giving me the error?
i've tried to take out $DOCUMENT_ROOT and specify where exactly i want the file to be /dir/dir/file.txt
but it still gives me an error.

I am getting a rediculous amount of errors in the log on my host saying the following but for numerous referer addresses.
Code: [Select]
[Wed Sep 21 12:15:32 2011] [error] [client 85.189.254.101] PHP Warning:  fwrite(): supplied argument is not a valid stream resource in /home/sites/myurl.co.uk/public_html/Category.php on line 122, referer: http://www.myurl.co.uk/Category/En/Floats/
it is a simple cache system i use and it appears to work as when you view source at the bottom of the page is the comment about the file being cached and retrieved. My page code:

Code: [Select]
<?php 
   $cat = $_GET["cat"];
   $sub_cat = $_GET["sub"];
   $language = $_GET["lang"];
$cachefile = "cache/".$cat."-".$sub_cat."-".$language.".html";


      $cachetime = 60 * 60 * 400; // 5 days


      // Serve from the cache if it is younger than $cachetime

      if (file_exists($cachefile) && (time() - $cachetime
         < filemtime($cachefile))) 
      {

         include($cachefile);


         echo "<!-- Cached ".date('jS F Y H:i', filemtime($cachefile))." -->";


         exit;

      }

      ob_start(); // start the output buffer
 include("./includes/db_con.inc.php");
$page_title = $cat . " - " . $sub_cat;
$sql_meta = mysql_query("SELECT * FROM sub_cat WHERE name='$sub_cat'");
$row_meta = mysql_fetch_assoc($sql_meta);
$meta_desc = $row_meta['META_DESC'];
$meta_key = $row_meta['META_KEY'];
 include("./includes/head.php"); 
 include("./includes/header.php");
 mysql_free_result($sql_meta);
  ?>

<div id="main-page-header">
<?php 
$desc_sql = mysql_query("SELECT * FROM sub_cat WHERE name='$sub_cat'");
$row_desc = mysql_fetch_assoc($desc_sql);
$description = $row_desc['description'];
echo "<img src='$img_loc/product-pages/sub-cat-head/".str_replace(" ", "-", $row_desc['name'])."-sub-cat-head.jpg' width='940' height='310' />";
mysql_free_result($desc_sql);
?>
</div>

  <div id="page-content">
 
    <div id="main-page-text">
   
    <h1><?php echo $sub_cat; ?></h1>
<h2 class="crumbs"><a href="<?php echo "$url/Products/$lang/"; ?>">Products</a> > <a href="<?php echo "$url/Category/$lang/".urlencode($cat)."/"; ?>"><?php echo $cat; ?></a> > <?php echo $sub_cat; ?></h2>
<p>
<?php echo $description; ?>
</p>

  <script src="http://connect.facebook.net/en_US/all.js#xfbml=1"></script><fb:like layout="button_count" show_faces="false" width="170" font="verdana"></fb:like>

   
  <div id="related-wrap">
 
  <h2><?php echo $sub_cat; ?> Products</h2>
   
    <?php
$range_products = mysql_query("SELECT * FROM $table WHERE CATEGORY='$cat' AND SUB_CATEGORY='$sub_cat' AND display='1' ORDER BY sortID ASC");
while($row_range = mysql_fetch_array($range_products))
    { 
$prodid = str_replace("/", "-", $row_range['PRODID']);
$cat_link = urlencode($row_range['CATEGORY']);
$sub_cat_link = urlencode($row_range['SUB_CATEGORY']);
echo "<div class='related-products'>\n<a class='related-img' href='$url/Product/$lang/$cat_link/$sub_cat_link/$prodid/'>\n<img src='$img_loc/product-pages/Range-thmb/$prodid.jpg' width='120' height='120' /></a>\n";
    echo "<h5>" . $row_range['PROD_TITLE'] . "</h5>\n";
    echo "</div>\n";
}
mysql_free_result($range_products);
?>

    </div>   
   
     <div id="FAQ-wrap"><h2>Frequently Asked Questions</h2>
  <?php
  $QA_table = $lang . "_qanda";
  if ($id=="") {
      $list_QA = mysql_query("SELECT * FROM $QA_table WHERE SUB_CATEGORY='$sub_cat' AND DISPLAY='1'") or die();
  }
  else {
  $list_QA = mysql_query("SELECT * FROM $QA_table WHERE PRODID='$id' AND DISPLAY='1'") or die();
}
  while($row_QA = mysql_fetch_array($list_QA))
{ 
  echo "<div id='FAQ-QA'>";
  echo "<h2 class='FAQ-question'>Q: ".$row_QA['QUESTION']."</h2>";
     echo "<p class='FAQ-question'>A: ".$row_QA['ANSWER']."</p></div>";
}
mysql_free_result($list_QA);
  ?>
    <div id="FAQ-question">
        <h2 class="white">Got a question about the
       
        <span class="got-question-product"><?php echo $sub_cat; ?></span>
       
        </h2> 
      </div>
     
      </div>

   

    </div>


   
    <div id="totem-menu-container"><?php include("./includes/search.php") ?>
   
    <?php include("./includes/totem.php") ?>
   
    </div>
 
  </div>
  </div>
<!-- MAIN CONTENT OF PAGE BELOW HERE -->

<!-- END MAIN CONTENT OF PAGE BELOW HERE -->

 
 
 
<?php include("./footer.php") ?>

<?php
       // open the cache file for writing
       $fp = fopen($cachefile, 'w'); 


       // save the contents of output buffer to the file
    fwrite($fp, ob_get_contents());

// close the file

        fclose($fp); 

// Send the output to the browser
        ob_end_flush(); 
?>