Loading Images from MySQL db to view in CI

[eluser]GeoXeo[/eluser]
Hi,

I just spent a few minutes testing that ... no problem at all.

database:

Code:

CREATE TABLE ci_images (
  id int(11) NOT NULL,
  image blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

model (image_model.php):

Code:

public function get()
    {
        $this->load->database();
        $query = $this->db->select('image')
                           ->from('images')
                            ->where('id', 1)
                            ->get('');
                          
        $result = $query->row();
                          
         return $query->num_rows() === 1 ? $result : false;                
    }

controller (image.php):

Code:

function show()
    {
        $this->load->model('image_model');
        $item = $this->image_model->get();
        
        Header("Content-type: image/jpeg");
        echo $item->image;
    }

When I load a jpg file into my blob, I can see it in my browser typing http://localhost/image/show

Hopefully this code will work for you ...