how to call specific data in database using code igniter?

Question

good evening sensei. im newbie in code igniter framework. i want to ask about how to call specific data with code igniter. my code below intended to call picture's name from my database.

this my Model

function profile_picture(){     
$username = $this->session->userdata('name');
$this->db->select('pict_name');
$this->db->from('picture');
$this->db->where('username="$username"');
$this->db->limit(1);
$query = $this->db->get();
return $query;  
}

this is my controller

public function v_profile(){
    $data['ppicture'] = $this->m_profile->profile_picture()->result();
    $data['profile'] = "profile";
    $this->load->view('header',$data);
    $this->load->view('profile',$data);
    $this->load->view('footer',$data);
}

this is my view

<img src="<?php echo base_url()."assets/img/".$ppicture; ?>" class="img-rounded" >

the codes above shows error: array to string conversion. how can i fix it? thanks

Jigar Shah · Accepted Answer · 2017-09-14 08:01:04Z

2

You are accessing array, result() provides array so ,

need to change result() to row()

$data['ppicture'] = $this->m_profile->profile_picture()->row();

and $ppicture; to $ppicture->pict_name;

<img src="<?php echo base_url()."assets/img/".$ppicture->pict_name; ?>" class="img-rounded" >

You can refer to documentation for further information

answered Sep 14, 2017 at 8:01

Jigar Shah

6,2332 gold badges32 silver badges41 bronze badges

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

5 Comments

chad Over a year ago

What if he has more than one row?

Jigar Shah Over a year ago

OP is using $this->db->limit(1); , so OP is expecting single row data in return :)

chad Over a year ago

Didn't noticed that! Good answer!

Salma Over a year ago

its work, thanks sensei, u have a good understanding, noticing thats limit :D @JigarShah

Jigar Shah Over a year ago

Glad to help you @emo , don't forget to upvote answers if you found useful

Vijay Sharma · Accepted Answer · 2017-09-14 08:00:55Z

0

Try This

function profile_picture(){     
$username = $this->session->userdata('name');
$this->db->select('pict_name');
$this->db->from('picture');
$this->db->where('username="$username"');
$this->db->limit(1);
$query = $this->db->get();
return $query->result_array();  
}

Befor $query = $this->db->get(); is returning object so $data['ppicture'] because an object and after that you assinging $data['profile']='profile'; so its giving error

answered Sep 14, 2017 at 8:00

Vijay Sharma

8318 silver badges16 bronze badges

Comments

Yadhu Babu · Accepted Answer · 2017-09-14 08:30:40Z

0

This might help you

Change your Modal to

function profile_picture(){     
$username = $this->session->userdata('name');
$this->db->select('pict_name');
$this->db->from('picture');
$this->db->where('username="$username"');
$this->db->limit(1);
$query = $this->db->get();
return $query->result_array();  
}

In your view page

<img src="<?php echo base_url(); ?>assets/img/<?php echo $ppicture[0]['table filed name for image'];?>" class="img-rounded" >

answered Sep 14, 2017 at 8:30

Yadhu Babu

1,5092 gold badges13 silver badges27 bronze badges

Collectives™ on Stack Overflow

how to call specific data in database using code igniter?

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related