Storing / Extracting images from database with php

Question

I am using PHP 5.3.5 and postgreSQL. I am storing and extracting images from database.

For storing i am doing this:

 $escaped_data = base64_encode(file_get_contents($_FILES['fileUpload']['tmp_name']));
 $fileModel->setBinary_Data($escaped_data);

It's working, i received the image in my database (Bytea field).

The problem is to extract this, i am trying this code to extract my images:

$file_info = $fileModel->getBinary_Data($id_file); // This function return the binary_data of the image

header('Content-Type: image/jpeg;base64');
header('Content-Disposition: attachment; filename=' . $file_info['_name']);
base64_decode($file_info['binary_data']));

When i download the image, i can't see the image...

With echo in:

echo base64_decode($file_info['binary_data']);

This happen:

http://imageshack.us/f/18/encodez.jpg/

After, i am trying using the function stream_get_contents inside base64_decode, but doens't work.

Someone know how i can download my images with php?

Thanks anyway...

Yes, i need store images in database because i will implement a OCR system. And the OCR system need read the images in database. — KillCloud, Mar 27 '12 at 00:28

score 0 · Answer 1 · answered Mar 26 '12 at 22:35

0

Well obviously your custom getBinary_Data() returns $file_info['binary_data'] as a resource, not a string.. so either change the function or use base64_decode(file_get_contents($file_info['binary_data'])));

And try to use fclose($file_info['binary_data']); too then.

P.S. Wasn't there a blob type for binary data in postgre?

answered Mar 26 '12 at 22:35

Artjom Kurapov

6,115
4
32
42

I received the same error message with file_get_contents: "file_get_contents() expects parameter 1 to be string, resource given" – KillCloud Mar 26 '12 at 23:15
how about `stream_get_contents($file_info['binary_data'])` ? – Artjom Kurapov Mar 27 '12 at 06:37
it's working, but for download the image is broken. Below my code: echo base64_decode(stream_get_contents($file_info['binary_data'])); – KillCloud Mar 27 '12 at 12:18
well you have to remove headers and see what it echoes – Artjom Kurapov Mar 27 '12 at 12:56

Storing / Extracting images from database with php

1 Answers1