Getting Close but still need help

Anon

I am trying to allow http upload of a file (.doc or .wps) into a database.
This is working (for some reason it displayes the contents of the file during upload but it does put it in the database).

The second part is to send that document as a download to a viewer. This is the part I can not seem to get to work. With this code

header("Content-type: application/msword doc");
header("Content-Disposition: attachment; filename=$dfilename");
header("Content-Transfer-Encoding: binary");

I get error:

Warning: Cannot add header information - headers already sent by (output started at /home/engler/public_html/getrfp.phtml:8) in
/home/engler/public_html/getrfp.phtml on line 9

Warning: Cannot add header information - headers already sent by (output started at /home/engler/public_html/getrfp.phtml:8) in
/home/engler/public_html/getrfp.phtml on line 10

Warning: Cannot add header information - headers already sent by (output started at /home/engler/public_html/getrfp.phtml:8) in
/home/engler/public_html/getrfp.phtml on line 11

Thanks in advance

Anon

Hi! This error means that you already have "write" information (via an echo or print) to the standard output... Check if you're doing this and send the headers first.

HTH

inK

Anon

OK Fixed the errors! It was Operator Stupidity! MINE! anyway now it says it downloads but it downloads an empty file. They get a file named what it should be its just empty

How do I send the actual data to the user. This is what im using so far.

$dfilename="test.doc";
$query="select RFPdoc from RFP where RFPid =('3')";
$db = mysql_connect('localhost','root','vvmkids');
$result=mysql_db_query('engler',$query,$db);
$rfpdoc=mysql_fetch_object($result);
header("Content-type: application/msword doc");
header("Content-Disposition: attachment; filename=$dfilename");
header("Content-Transfer-Encoding: binary");

Shouldnt there be some sort of header to specify $rfpdoc->RFPdoc;
as the data to send?

Anon

A easy way to use is :
header("Location: $dfilename");

I think that you can let the web server to judge which correct type of the file to indicate. Just like the download link:
<a href="test.doc">test.doc</a>.

Anon

The problem is that it does not exist as an physical file. It exist as the contents of a database field. The problem is how do I tell php to send the contents of a field to a client for download. Im close but something is missint.

If we can http upload a file into the database surely we can http download the contents back from the db to a file. 🙂

Gary

Anon

Gary, you're almost there. You're done with headers. Now echo $rfpdoc->RFPdoc as the body of the http transmission.

Anon

Gary D wrote:

$db = mysql_connect('localhost','root','vvmkids');
$result=mysql_db_query('engler',$query,$db);

this looks an awful like real info. you probably dont want to do this in the future as some malicious person could be reading this.

Anon

You are correct, how stupid of me. The appropriate changes have been made.

On the good side! MY PROBLIEM IS FIXED!!!!

Thanks all.

Anon

Hello,

I am trying to download the document when I click on a link. The document has already been uploaded to the database. I am getting some strange errors. Can someone figure out what's the problem? Here is my code...

$dfilename="test.doc";

$sqlstmt = "select fileloc, note_name, added_on, added_by from esc_notes where esc_id = $esc_id and note_type = 'DL' order by added_on";
$result = mysql_query($sqlstmt) or die (getSQLError($sqlstmt));

print<<<EOF
<h3>Case Documents</h3>
<p align=right><a href="escalation.php?action=uploadFile&esc_id=$esc_id">Add Document</a></p>
<table border=1 width=100%>
<tr>
<th>Document Name</th>
<th>Added on </th>
<th>Added by </th>
</tr>
EOF;
while($line = mysql_fetch_row($result)) {
print<<<EOF
header("Content-type: application/msword doc");

	header("Content-Disposition: attachment; filename=$dfilename"); 


	header("Content-Transfer-Encoding: binary"); 

<tr>
  <td><a href="$line[0]">$line[1]</a></td>
  <td>$line[2]</td>
  <td>$line[3]</td>
    </tr>

EOF;
}

print "</table>";

}

I get an error where the header is. The link is where $line[1] is.

Thanks in advance,
Stephanie