header error file retrieved from mysql

Bhoomika

I can successfully insert datafile in my 'datafile' table .
which is uploaded by users.

now problem is that

when echo $data

its giving me this error.

Warning: Cannot modify header information - headers already sent by (output started at c:\phpweb\phpmailattachment\mail.php:6) in c:\phpweb\phpmailattachment\mail.php on line 75

if i upload .doc file it displays it with text and junk also

please tell where am i making mistake?

Thanks

Bhoomika

this is the code.

<html>
<head>
<title> Sending attachment </title>
</head>
<body>
<?php

include("\phpweb\demo4\config\configpfinaltest.php");
include("\phpweb\demo4\config\functions.php");

// Obtain file upload vars
$fileatt = $FILES['fileatt']['tmp_name'];
$fileatt_type = $FILES['fileatt']['type'];
$fileatt_name = $_FILES['fileatt']['name'];

if (is_uploaded_file($fileatt)) {
$data = addslashes(fread(fopen($fileatt, "r"), filesize($fileatt)));
}

$connection=mysql_connect($hostname,$user,$pass) or die("Unable to connect");

$query = "insert into file set name='$from', filename='$fileatt', filetype='$fileatt_type', filenameatt='$fileatt_name' ,datafile='$data'";

$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());

$iid=mysql_insert_id();

//select inserted data and display it.
$query = "select * from file where id=$iid";
$result = MYSQL_QUERY($query);

$data = MYSQL_RESULT($result,0,"datafile");
$type = MYSQL_RESULT($result,0,"filetype");

Header( "Content-type: $type");

echo "Image No. $iid <br>";
echo "<br>$data";

mysql_close($connection);
?>
</body>
</html>

Weedpacket

If this error has been explained n times it's been explained n+1. It's mentioned in the PHP manual's [man]FAQ[/man], and a fifteen-second search of these forums for the phrase Cannot send header information will turn up dozens of hits.

You cannot send any headers after the response's headers have already been sent. And all headers must be sent before the page's contents. So as soon as any content is output by the script, PHP sends all of the headers first.

So after you've sent any content (such as that started on line 6 of mail.php) you can't send any more headers.

Your real problem is that you're trying to output a file, but you're chucking a load of HTML in as well. Cut all that out and you might have a chance.

Bhoomika

thanks

header error problem is solved

but still geting junk with text in .doc file

and can't see .jpg and .gif files

Bhoomika

modified code

<?php

include("\phpweb\demo4\config\configpfinaltest.php");

$fileatt = $FILES['fileatt']['tmp_name'];
$fileatt_type = $FILES['fileatt']['type'];
$fileatt_name = $_FILES['fileatt']['name'];

$headers = "From: $from";

if (is_uploaded_file($fileatt)) {
$data = addslashes(fread(fopen($fileatt, "r"), filesize($fileatt)));
}

$connection=mysql_connect($hostname,$user,$pass) or die("Unable to connect");

$query = "insert into file set name='$from', filename='$fileatt', filetype='$fileatt_type', filenameatt='$fileatt_name' ,datafile='$data'";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
$iid=mysql_insert_id();
$query = "select * from file where id=$iid";
$result = MYSQL_QUERY($query);

$data = MYSQL_RESULT($result,0,"datafile");
$type = MYSQL_RESULT($result,0,"filetype");

Header( "Content-type: $type");

echo $iid;
echo $data;
?>

Weedpacket

What's the $iid for? Is that part of the file you're trying to show?

srikanth1184

What's the $iid for? Is that part of the file you're trying to show?

$iid - She what's to print the insert ID besides the datafile.

Few months back i did experienced the similar problem. The solutiuon what i found was

In Mysql change the data type as blob.
use base64_encode(); base64_decode(); functions.

Hope this will work for you!!

Weedpacket

Originally posted by srikanth1184
What's the $iid for? Is that part of the file you're trying to show?

$iid - She what's to print the insert ID besides the datafile.

Doing that would corrupt the file. A PNG file, for example, has to start with the bytes 89 50 4e 47. Other file formats have similar requirements. If you output arbitrary data as well beforehand you ruin the file format and the file becomes unusable.