Jump to content


Photo

How do I set the location of the file I want to write/create?


  • Please log in to reply
2 replies to this topic

#1 simcoweb

simcoweb
  • Members
  • PipPipPip
  • Advanced Member
  • 1,102 posts
  • LocationCA

Posted 18 July 2006 - 11:07 PM

Here's the code designed to create a CSV file from the MySQL results:

$data = "";
$result = mysql_query("SHOW COLUMNS FROM `iplog`") or die(mysql_error());
while($row = mysql_fetch_array($result)) {
    $data .= $row[0].",";
}
$data = substr($data,0,-1)."\r\n";

$result = mysql_query("SELECT * FROM `iplog`") or die(mysql_error());
while($row = mysql_fetch_assoc($result)) {
    foreach($row as $r) {
        $data .= "$r,";
    }
    $data = substr($data,0,-1)."\r\n";
}

$handle = fopen("data.csv","wb");
fwrite($handle,$data);
fclose($handle);


The way this works right now is it writes the 'data.csv' file to the same folder the script(s) are in which means, on my servers, I have to set permissions to 777 for that to work. What I want to do is have it write the 'data.csv' file to a sub-folder so  I can set the permissions on that to 777 and not have to worry about it.

Right now it writes like this:

/iplog/data.csv

I need:

/iplog/csv/data.csv

Thanks!

#2 hitman6003

hitman6003
  • Members
  • PipPipPip
  • Advanced Member
  • 1,807 posts

Posted 18 July 2006 - 11:14 PM

change:

$handle = fopen("data.csv","wb");

to

$handle = fopen("./subfolder/data.csv","wb");


#3 simcoweb

simcoweb
  • Members
  • PipPipPip
  • Advanced Member
  • 1,102 posts
  • LocationCA

Posted 19 July 2006 - 12:08 AM

I knew it would be something simple. Thanks for the help! :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users