outputting file to desktop?

vaska

i'm not sure how to do this...

i need to create an Excel file (.csv) but i want it to just download to the users computer...the code for the first part is simple...but i don't know how i would go about having it sent to the user as a download...???

include('conn.php');
$result = mysql_query("SELECT * FROM ph,customers WHERE ph_cust_id=cust_id AND ph_proj_id=$proj_id");
$fp = fopen("pathto/filename.csv","w+"); 
while($row = mysql_fetch_array($result)) { 
	$line = "\"" . $row["cust_comp"] . "\";\"" . $row["cust_contact"] . "\";\"" . $row["cust_phone"] . "\"\r\n";
	fputs($fp,$line,strlen($line));
}
fclose($fp);

bad76

Hi,
don't use fopen/fclose, use header instead:

include('conn.php'); 
$result = mysql_query("SELECT * FROM ph,customers WHERE ph_cust_id=cust_id AND ph_proj_id=$proj_id"); 

header("Content-type: application/vnd.ms-excel");
header("Pragma: no-cache");
header("Expires: 0");

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

    $line = "\"" . $row["cust_comp"] . "\";\"" . $row["cust_contact"] . "\";\"" . $row["cust_phone"] . "\"\r\n"; 
    echo $line; 
}

This will open excel, any user then can save it.

Or you put some like
header("Content-Disposition: attachment; filename=\"$fname\"");
and all is send as a file...

see you

hermzz

This is not a really good help but well.

Try header(); I think that will do but you'll have to look for the parameters to send.

Now that I think of it this might do:

header("Location: http://pathto/filename.csv");

It works with http pages so this should do.

This function redirects with those parameters.

http://es2.php.net/manual/en/function.header.php

vaska

it worked a little bit...

include('conn.php');
$result = mysql_query("SELECT * FROM ph,customers WHERE ph_cust_id=cust_id AND ph_proj_id=$proj_id");

header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=\"filename.csv\""); 
header("Pragma: no-cache");
header("Expires: 0");

while($row = mysql_fetch_array($result)) { 
	$line = "\"" . $row["cust_comp"] . "\";\"" . $row["cust_id"] . "\";\"" . $row["cust_fname"] . "\"\r\n";
	echo("$line");
}

almost there...works...but...i'm losing my formatting and i'm not sure why...

if i look at the source all the formatting is there...but when i open it in excel the "" around cust_comp are gone but then all the other formatting follows...meaning, each row of data falls into the first cell...???

i'll keep going with this...thanks...v

bad76

To separate data in rows echo some \t...
And Excel remove the " " and make the cell a text.
You can try putting before a ' : '"some text"

but i don't be sure...

good luck.