Codeigniter: Display an image stored in DB

Question

How do I get an image stored in a field of my database, and put it into a variable for using it in an email message like a signature?

Here is my code:

//Model user_model

function getImage(){
  $this->db->select("image");
  $this->db->where("$id", user_id);
  $query = $this->db->get("users");

    if($query->num_rows()>0){
      return result();
    }else{
      return false;
    }  

}

//Controller user_controller

  function image(){
    this->load->model("user_model");

    $id = $this->session->userdata('id');

    $image = $this->user_model->getImage($id);

    echo $image;
  }

Welcome to Stack Overflow. Please review How do I ask a good question. Your question should include a clear outline of your specific coding-related issue, a summary of what you have already tried and the relevant code in a Minimal, Complete, and Verifiable example, so we have enough information to be able to help. — FluffyKitten
– FluffyKitten, Commented Sep 20, 2017 at 20:23

score 1 · Accepted Answer · 2017-10-03 19:27:43Z

1

Here is a example

Model user_model

// Pass the id function 

function getImage($id){
    $this->db->where($id, 'user_id');
    $query = $this->db->get("users");

    if($query->num_rows()>0){
      return $query->row_array();
    }else{
      return false;
    }  

}

Controller user_controller

function image(){
  $this->load->model("user_model");

  $somedata = $this->user_model->getImage($this->session->userdata('id'));

  $data['image'] = $somedata['image'];

  $this->load->view('someview', $data);
}

On view

<?php echo $image;?>

edited Oct 3, 2017 at 19:27

answered Sep 30, 2017 at 5:57

user4419336

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

2 Comments

Alvaro Vergara Over a year ago

Thank you so much for your answer, i was trying make it work, but when i call $data['image'] in the view i get the error "Undefined variable: data", i'm using <?php echo $data['image']; ?> for make the call, any idea for fix this error? Thank you again!!

user4419336 Over a year ago

@AlvaroVergara I have updated it your way incorrect you should read the user guide fully

Collectives™ on Stack Overflow

Codeigniter: Display an image stored in DB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related