Re: [fw-db] Getting JPEGs from DB

Have you tried clearing or disabling your browser's cache? The headers that I use help ensure that the browser caches the image, but I think if there was an error then you may have bad data in your cache.

When you assign $file to the view, what does the view do with it?

On Fri, Oct 24, 2008 at 4:43 AM, Michael Crumm <mcrumm@gmail.com> wrote:

Hector,

Can't believe I found this post, as I attempted to ask a similar question on zf-general yesterday (got not response, surprise..)

I cannot by any means get a controller action to output an image.  I was using a very similar setup, albeit not as many headers, but all i ever get is a blank page.
I added all the headers you are setting to my controller action, but there was no change in output.

If i take a look at firebug's output, it's garbled, but of the correct size.

Here's the header's i'm getting back:
Date    Fri, 24 Oct 2008 11:33:26 GMT
Server    Apache/2.0.63 (CentOS)
X-Powered-By    PHP/5.1.6
Expires    Thu, 19 Nov 1981 08:52:00 GMT

Cache-Control    max-age=3600, must-revalidate

Pragma    no-cache
Last-Modified    Fri, 24 Oct 2008 11:04:47 GMT
Content-Length    132628
Content-Transfer-Encoding    binary
Keep-Alive    timeout=5, max=150
Connection    Keep-Alive
Content-Type    image/jpeg

I'm using 1.6.2 stable


Any thoughts at all would be seriously helpful.  I've hit a total brick wall. 

-Mike

On Thu, Oct 23, 2008 at 10:55 AM, Hector Virgen <djvirgen@gmail.com> wrote:

In one of my applications I built a thumbnail generator for outputting user avatar images in any size needed, using PHP to resample the original image and using Zend_Cache to cache it.

Here's the tail end of my thumbnail action which I think might help you accomplish what you need. But I agree with Matthew, you're probably better off serving the files directly unless you need PHP to be involved with every served image (logging, resampling, etc.)

--- ImagesController.php ---

<?php

class ImagesController extends Zend_Controller_Action

{

    public function thumbnailAction()

    {

        [ ... ]

        // Last modified timestamps

        $modified = filemtime($cacheFileName);

        $modifiedDateGM = gmdate('D, d M Y H:i:s', $modified) . ' GMT';

        

        // Get request headers to check for cache options

        $headers = apache_request_headers();

        

        if (isset($headers['If-Modified-Since']) && (strtotime($headers['If-Modified-Since']) == $modified)) {

            // Client's cache is current, so we just respond '304 Not Modified'.

            $response->setHeader('Cache-Control', 'max-age=3600, must-revalidate', true);

            $response->setHeader('Last-Modified', $modifiedDateGM, true);

            $response->setHttpResponseCode(304);

        } else {

            // Image not cached or cache outdated, we respond '200 OK' and output the image.

            $response->setHeader('Last-Modified', $modifiedDateGM, true);

            

            // Content type

            $response->setHeader('Content-Type', 'image/png', true);

            

            // Content length

            $response->setHeader('Content-Length', filesize($cacheFileName), true);

            

            // Force binary encoding

            $response->setHeader('Content-Transfer-Encoding', 'binary', true);

            

            // 24 hour cache

            $response->setHeader('Cache-Control', 'max-age=3600, must-revalidate', true);

            

            // Set response body

            $response->setBody(file_get_contents($cacheFileName));

        }

        

        // Send response and exit

        $response->sendResponse();

        exit;

    }

}

On Thu, Oct 23, 2008 at 8:22 AM, Matthew Ratzloff <matt@builtfromsource.com> wrote:

You really don't want to do this.  Store the files on the file system and keep data about them in the database instead.  Use a rewrite map or, better, a series of rewrite rules to serve the files directly from your web server instead of using passthrough.  That will bypass your problem entirely and be much more scalable.

-Matt

On Wed, Oct 22, 2008 at 7:54 PM, Mauro Spivak <mauros@gmail.com> wrote:

Hi there,

I'm have a simple form that uploads files to a server and stores them in a MySQL longblob field using the serialize() function. Then, when I want to retrieve them, I just output them with a couple of headers. Now, because of some reason I don't understand, when I do this through Zend Framework It works perfectly with non-image files (such as PDFs, ZIPs, DOCs, etc.) but not with image files (like JPGs, GIFs, PNGs, etc.)

I'll paste part of the code just for reference:

When uploading: 

{...}

$file['contents'] = file_get_contents($form->file->getValue());

{...}

$newFile = New File;

try {

$newFile->insert($file);

} catch (Exception $e) {

die($e->getMessage());

}

When downloading:

$file = New File;

$file = $file->fetchRow("id='".$params['id']."'");

$this->view->file = $file;

header("Content-Type:image/jpeg");

header("Content-Disposition: attachment; filename=".$file->name.".".MimeToExtension($file->type));

$this->view->file = $file;

I'll really appreciate your answer guys.

Mauro.

--
-Hector

--
-Hector