Case of the Disappearing File

stewb

I am trying to "dump" all or most of a MySQL database table to a comma-delimited ASCII file so that I can download and use the information locally.

Using fopen() to create the file, with the "w+" parameter.
Using file_exists() to check its existence in the current directory.
Using fwrite to write an export row to it.

fopen() does NOT return an error!
file_exists() indicates that the file actually exists -- or at least it does NOT return an error!
fwrite() does NOT return an error!
Tried having the table contents echoed to the screen so that I can see that it's actually retrieved the rows in the Table -- it HAS!
Yet, the FILE DOES NOT ACTUALLY EXIST! Can't retrieve it; can't open it. I've even tried listing the contents of current directory to see if it's there in any form; it is NOT!

Any suggestions? Any help?

Thank you!

Wave

Cooode-coooode
Show us...
The Cooode!

stewb

<html>
<body>
<?php
$filename = '/home/www/lhtaz/DBDump.csv';
$handle = fopen($filename, "w+");
if (file_exists($filename)) {
echo "The file $filename exists!! ";
} else {
echo "The file $filename does not exist ";
}
/ Then I set up the link to the database and the correct table, retrieve the records in a for-next loop (all of which work, since I can echo them to the screen). Then this: /

$dos_rec = "string of values separated by commas". chr(13) . chr(10);
if (is_writable($filename)) {
if (!fwrite($handle, $dos_rec)) {
echo ("Cannot write to file $filename ");
exit;
} else {
echo $dos_rec . " ";
}
} else {
echo ($filename . " IS NOT writable! ");
exit;
}
/ For - next loop then ends, then: /
fclose($handle);

Then I go to look for the file, but IT'S NOT THERE!

Thanks.

Wave

the code is correct.

try to check if data is actually writen

add something like this line at the end of your script:

echo "$filename contents: <pre>".implode ('', file($filename));

so if it will output your data, it's not a php problem

stewb

Yes, I DID insert your "implode()" command and, indeed, it dumped the contents of the file!

I have sent an inquiry to the Internet Service Host asking what's the difference between the "default" MySQL directory and the "standard" Web directory, even though in the past, using their Web-based SSH, they've always been exactly equivalent! I'll post the results of that query when I get it back!

Thanks again!

Stewart Black