php help needed

07-01-2007, 3:30 PM

I need some help as I am still a newbie's newbie with php

I have a mysql database and I have initialized it to hold BLOBS

in the mysql database :- bin_data holds the BLOB data
in the mysql database :- filetype holds the BLOB type

the purpose of my php code is to download the BLOB data

I have 2 php pages

The first php page displays a list of index that corresponds to the BLOB
data e.g 1, 2, 3, 4, 5

If you click on either of the 1, 2, 3, 4, 5, I will call the second page and
pass to it the index
that was clicked by the mouse, e.g. if I click on 1, I will call the second
page and pass a 1 to it

The second page when called will firstly check for the value of the index
which is found in the variable
IDX

It will then connect to the mysql database and download the bin_data BLOB
and assign it to $data

It will also connect to the mysql database and get the BLOB type and assign
it to $type

Now I was told that output the followin code in my php page it will download
the BLOB to the browser :-
<?php Header( "Content-type: $type");echo $data; ?>

But how come when I call my second page I get this error message :-

Warning: Cannot modify header information - headers already sent by
(output started at c:\program files\apache2\htdocs\Sikom\download.php:28) in
c:\program files\apache2\htdocs\Sikom\download.php on line 28

can someone tell me why ???

what I want to do is to be able to have a link on a page that if you click
on it, it will
download the blob data to your hard disk ...

how can i do this ?

Hope to hear from you soon.

Andy

START OF PHP CODE
================================================== ===============

<?php require_once('Connections/Sikom.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($HTTP_GET_VARS['IDX'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['IDX'] :
addslashes($HTTP_GET_VARS['IDX']);
}
mysql_select_db($database_Sikom, $Sikom);
$query_Recordset1 = sprintf("SELECT * FROM Sikom WHERE Sikom.id = %s",
$colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $Sikom) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$data = @MYSQL_RESULT($Recordset1,0,"bin_data");
$type = @MYSQL_RESULT($Recordset1,0,"filetype");

?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<?php Header( "Content-type: $type");echo $data; ?>

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

END OF PHP CODE
================================================== ===============

07-01-2007, 3:30 PM

"Andy Yeo" <kheemeng@lycos.com> skrev i en meddelelse
news:3f094677$1@news.starhub.net.sg...
> in the mysql database :- filetype holds the BLOB type
I would use a VARCHAR for the mime-type.. (it does not vary all that much in
length)

> Warning: Cannot modify header information - headers already sent by
> (output started at c:\program files\apache2\htdocs\Sikom\download.php:28)
in
> c:\program files\apache2\htdocs\Sikom\download.php on line 28
You are not allowed to output any text to the browser before using the
Header() function (even whitespace).

Martin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Another Newbie	Kaonie	Introduce yourself	5	07-14-2007 12:36 PM
CSS Newbie needs help	tom watson	HTML	1	07-01-2007 1:24 PM
TOM TOM NEWBIE INSTALL HELP NEEDED	Steve T.	GPS	8	06-26-2007 12:06 AM
newbie q	will	Central Processing Unit (CPU) and Overclocking	2	06-18-2007 3:02 AM
Newbie here	Burner1	Introduce yourself	1	05-10-2007 1:46 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)