PHP Experts! Help me please :)

[xentech]

http://bigtitsvideos.info/dl.php?id=5

I'm trying to display an image which is stored in a mediumblob table field, any ideas? Here is my code:

<?php
include "config.php";
$result = mysql_query("select * from [MASKED] where id = '$id'");

while($r=mysql_fetch_array($result))
{	
   $content=$r["content"];
   $type=$r["type"];

header("Content-type: $type");
echo ($content);
}

mysql_close($connection);
?>

[JayS]

Originally Posted by xentech

I'm trying to display an image which is stored in a mediumblob table field, any ideas? Here is my code:

Don't store it in a DB Would be helpfull if you can mention where the error is...

[xentech]

Originally Posted by JayS

Don't store it in a DB Would be helpfull if you can mention where the error is...

http://bigtitsvideos.info/dl.php?id=5

Go to that url, for me it just shows "http://bigtitsvideos.info/dl.php?id=5" instead of an image... And I thought storing it in a DB would be easier but apparently not, I just can't see how its not working. Perhaps it is to do with my PHP settings?

[xentech]

Ignore everything I just said, I am a fucking idiot. Thanks anyway

[JayS]

Originally Posted by xentech

Ignore everything I just said, I am a fucking idiot. Thanks anyway

Some old debug code in your config.php?

[xentech]

Originally Posted by JayS

Some old debug code in your config.php?

Nah I had

$content=$r["content"];

instead of

$content=$r["image"];

That is the worst part about programming, some problems can just marvel you for ages and you can't figure out what they are. Then they turn out to be the most simple things you have missed.

[mike-al]

Not sure what book you have that is teaching you, but please burn it ASAP

[Serge Litehead]

Originally Posted by JayS

Don't store it in a DB

stored image in DB could also mean simply stored reference to it which is useful some times.

[xentech]

Originally Posted by mike-al

Not sure what book you have that is teaching you, but please burn it ASAP

I just ripped some code from some random tutorial, never worked with images in SQL before. Why, is it insecure?

[JayS]

Originally Posted by xentech

I just ripped some code from some random tutorial, never worked with images in SQL before. Why, is it insecure?

You may check out en.wikipedia.org/wiki/SQL_injection and I highly recommend that you better not use every piece of code that you can find on the web unless you have checked it