displaying BLOB data from DB

[eluser]Phil Sturgeon[/eluser]
If you are using MySQL and want to make the image sizes slightly smaller you can use COMPRESS() and UNCOMPRESS().

Then you want to make a controller like this:

Code:

<?php
class Media extends Controller

  function image($image_id)
  {
    // This will be image string
    $image_data = $this->images->get($image_id);
    
    $image = imagecreatefromstring($image_data);
  
    header('Content-Type: image/png');
    imagepng($image);
    imagedestroy($image);
    exit;
  }

}
?>

That should do the job.