Jump to content

Archived

This topic is now archived and is closed to further replies.

simcoweb

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

Recommended Posts

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

[code]$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);[/code]


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!

Share this post


Link to post
Share on other sites
change:

[code]$handle = fopen("data.csv","wb");[/code]

to

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

Share this post


Link to post
Share on other sites
I knew it would be something simple. Thanks for the help! :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.