BLOB in Lightbox...

[batstanggt]

How does one get a BLOB to display inside a "lightbox"?

-SB

 

[JasonLewis]

Have you attempted to do this at all? I've never actually stored images in a database, unless it was the path to the location of the image, however you can fetch the data from the database and set the content-type header to image/jpeg or whatever the image is and output the image.

 

The best way to get it to appear in a lightbox would be to have an HTML img tag link to a PHP script with perhaps the ID of the image:

<img src="/path/to/image.php?id=1" alt="My Image!" />

 

Then in image.php:

<?php
$id = $_GET['id'];
$data = mysql_fetch_assoc(mysql_query(...)); // run query to fetch data, probably better to ensure your query executes properly first etc

header('Content-type: image/jpeg');
echo $data['image'];
?>

 

Very basic, but you get the idea. Good luck.