Fetching a value from database in codeigniter

Question

I am trying to fetch some values from the database and I'm getting this error

A PHP Error was encountered
Severity: Notice
Message: Undefined index: name
Filename: views/pro_view.php
Line Number: 12

My controller:

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

$data['profile_data'] = $this->profile_model->get_records();

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

Model:

function get_records()
{
    $r = $this->uri->segment(3);
    $query = $this->db->get_where('profile', array('id' => $r));
    return $query->result();
}

View:

<input type="text" name="name" value="<?php echo $profile_data["name"]  ?>" />

if I var_dump(($profile_data); I'm getting everything in an array.

I read other similar questions and their answers, no luck.

By default CI return as a object and you need to echo like this in view for every value which you want to print $profile_data[0]->name — pspatel
– pspatel, Commented Sep 17, 2015 at 10:36

Saty · Accepted Answer · 2015-09-17 10:32:14Z

4

If you need to fetch single row then use

$query = $this->db->get_where('profile', array('id' => $r));
$ret = $query->row();
return $ret->name;

Controller

$data['name'] = $this->profile_model->get_records();

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

View

<input type="text" name="name" value="<?php echo $name;?>" />

And for your present code you need to use foreach loop

 foreach (profile_data as $row)
   { ?>
<input type="text" name="name" value="<?php echo $row->name;?>" />

  <?php }?>

result()

This method returns the query result as an array of objects, or an empty array on failure. Typically you’ll use this in a foreach loop

edited Sep 17, 2015 at 10:32

answered Sep 17, 2015 at 10:27

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

6 Comments

Dray Over a year ago

i have like 20 type of values in row, you know like a normal profile. Name, phone, etc.

Saty Over a year ago

You need to use foreach loop as i post in my answer

Dray Over a year ago

i was getting an error. $profile_data[0]->name in the view worked for me.

pspatel Over a year ago

@Saty error is because not accessing the value using the key index in and he is using function for single row

Saty Over a year ago

But using my code there is no change to get any error. I'm providing answer for both fetch single row or fetching object from database!!!

|

Milan Soni · Accepted Answer · 2018-08-28 09:47:21Z

1

Controller

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

    $data['profile_data'] = $this->profile_model->get_records();

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

Model

$r = $this->uri->segment(3);
$this->db->select('*');
$this->db->from('profile');
$this->db->where('id',$r);
$q = $this->db->get();
if($q->num_rows() > 0){
$row = $q->row();
return $row->name;
}
return false;

view

<input type="text" name="name" value="<?php echo $name;?>" />

edited Aug 28, 2018 at 9:47

answered Sep 17, 2015 at 10:33

Milan Soni

1081 silver badge9 bronze badges

Collectives™ on Stack Overflow

Fetching a value from database in codeigniter

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related