How to get Image on browser from binary data in php

Question

I have 1 column containing binary format data. I want to display that Image on browser and I am useing codeignater

My Model Code

function GetLogoById($Id)
    {
        $this->load->database();
        $query =  $this->db->query( "EXEC GetLogoById '$Id'" );
        $result = array();
        foreach ($query->result() as $row)
        {
            $result[] = array("Logo"=> $row->Logo);
        }
           return $result;
    }

My Controller Code:

public function GetLogoById()
    {
    $this->load->model('MyModel');
    $result = $this->MyModel->GetLogoById($Id);
    $result = base64_decode($result);

    echo $result;
}

It return Blank in browse. What I am missing....

How did you store image in database? By encoding in base64 or storing original text string of uploaded image file? If you don't use correct encoding and decoding method, image will be displayed as text in browser. — Thein Hla Maw
– Thein Hla Maw, Commented Oct 4, 2013 at 10:21

Kvadiyatar · Accepted Answer · 2013-10-04 12:01:13Z

1

try with this.

$this->load->model('GetLogoById');

   $result = $this->mymodel->GetLogoById($CarrierId);

   header('Content-type: image/png');
   echo  $result[0]['Logo'];

answered Oct 4, 2013 at 12:01

Kvadiyatar

96414 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nil'z · Accepted Answer · 2013-10-04 10:21:17Z

0

Try this:

public function GetLogoById()
{
$this->load->model('MyModel');
$result = $this->MyModel->GetLogoById($Id);
//$result = base64_decode($result);
header('Content-Type: image/jpeg');  #set a header
echo $result;
}

edited Oct 4, 2013 at 10:21

answered Oct 4, 2013 at 10:09

Nil'z

7,4831 gold badge20 silver badges28 bronze badges

5 Comments

Jignesh.Raj Over a year ago

becouse I am Getting Binarydata from database And that is not well formated so

Nil'z Over a year ago

No dont use base64_decode. Use it only when you have encoded it via base64_encode. See updated answer.

Jignesh.Raj Over a year ago

Hi..i used ur latest code...but by this i am getting error....image can not be display bcoz it's contain error....so, do u want my binary data?

Nil'z Over a year ago

May be there is a problem with your binary data. How you saved it in database. But this is the way to do it. Try saving the data once more.

Jignesh.Raj Over a year ago

let us continue this discussion in chat

marc_s · Accepted Answer · 2017-01-08 09:32:28Z

0

<?php

public function GetLogoById() {

   $this->load->model('MyModel');

   // Get your result
   $result = $this->MyModel->GetLogoById($Id);

   // Do base64 decode if you encoded it.
   $result = base64_decode($result);

   // Set header according to the image type. 
   // if the image is jpg use 'image/jpeg'
   // if the image is png use 'image/png' 
   // and so on ...
   header('Content-Type: image/jpeg');

   // Only echo the exact value. Keep in mind that no other 
   // space or any other values are echoed
   echo $result;

   // Also make sure that there must not be any spaces or other values before or after the php tags
}

?>

// This is a sample.

<?php

   $image_data = file_get_contents( __DIR__ .  '/dino_babu.jpg');

   $image_token = base64_encode($image_data); // Save this token to database

   $image_data_decode = base64_decode($image_token); // retrieve the token & decode it

   header('Content-Type: image/jpeg'); // Set the header

   echo $image_data_decode; // Print the data

?>

edited Jan 8, 2017 at 9:32

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 4, 2013 at 10:49

Dino Babu

5,8093 gold badges26 silver badges33 bronze badges

2 Comments

Dino Babu Over a year ago

are you sure that your encoded value in database is correct and properly retrieved ?

Jignesh.Raj Over a year ago

it's storing byte of array..and i am just fetch record nothing else...so, i dont think so i am making any mistake on that.

Collectives™ on Stack Overflow

How to get Image on browser from binary data in php

3 Answers 3

Comments

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related