How to retrive image form oracle database using php

[vivek14]

Hi,
I am working on one project which uses oracle as a database.
According to requirement I have to store image on oracle database in blob(datatype) and retrieve that stored image and show in a web page.
If I am doing so,I am getting a broken image the code is shown below:

$query = $pdo->prepare("SELECT image,type FROM image where s_date = ? ");
$query->execute(array($dat));
$res = $query->fetchAll();     
    foreach ($res as $result){             
        echo '<img height="300" width="500" src="data:'.$result['type'].';base64,' . base64_encode($result['image']) . '" />';
 
        }
 
 
 
 
 

[Luuk]

Try to look at the size of the image that you are retrieving..
Probably you will find out that you are not retrieving the same size as the image size that was stored.

If you base64_encode the picture before storing, *yes this will lead to bigger database contents!), you should be able to retrieve the complete image. (and base64_encode) would not be needed to display image)

[vivek14]

MY image size is in kb.

[Luuk]

"MY image size is in kb."

This cannot be true!

Maybe your image size is displayed in kb.
But kb is short for kilobytes, which seems to be 1024 bytes.

My question was:
What size is the image (not with which unit is this size displayed)

Ig you have an image with a certain size(1), store it in the database, and retrieve it, what is the new size(2)

Calculatie the difference between these sizes ((1) and (2)). The difference in size should be bytes.

Can/Did you verify that?

If the outcome of this difference is not 0 (zero) than you will see a broken image.