retrieve binary data from mysql

ErikN

Hi,
I've got a mysql database with the following fields (and more)
file LONGBLOB
filesize VARCHAR
filetype VARCHAR

I can upload new stuff into the database and I've tested it with a simple output form.

Header( "Content-type: $users_avater_filetype");
echo $users_avater;

i know you can only send a header once and it has to be at the start of the page, what if i want this...

<?php
include "nav.php" //layout information
?>

<html>
some html code
</html>

<?php
echo $users_avater;
?>

That's not possible as far as i know, i've tried some imagecreate functions (jpeg/pjpeg etc) but i only get a bunch of errors... can anyone help me out here?

erik

floR

You're right, that's not possible. An image in a webpage is not part of the page request, but a request for a different url.
What you need to do is :

<?php
echo ("<img src=\"getavatar.php?id=$userid\">");
?>

getavatar.php then retrieves the image from the database when the browser asks for it and getavatar.php must send the image-type header.

ErikN

omfg that's the most simple solution ever 🙂 😃 dammit why didn't i thought of this 10 hours ago :p thnx a lot i've got it working now!