Codeigniter : displaying query result in controller

Question

I am trying to display my db query result in my controller, but I don't know how to do it. could you please show me?

Controller

 function get_name($id){

 $this->load->model('mod_names');
 $data['records']=$this->mod_names->profile($id);

// I want to display the the query result here 
 // like this:  echo $row ['full_name'];

 }

My Model

function profile($id)
    {  

        $this->db->select('*');
        $this->db->from('names');
        $this->db->where('id', $id); 
        $query = $this->db->get();


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

    }

Muhammad Raheel · Accepted Answer · 2012-05-21 12:22:50Z

6

echo '<pre>';
print_r($data['records']);

or

 echo $data['records'][0]['fullname'];

answered May 21, 2012 at 12:22

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

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

2 Comments

black_belt Over a year ago

Thanks for your reply. I have tried echo $data['records'][0]['fullname']; But I get this message: Undefined offset: 0 Thanks :)

Muhammad Raheel Over a year ago

ok change it like this it will work fine echo $data['records']['fullname'];

James Arnold · Accepted Answer · 2012-05-21 13:21:23Z

4

Model:

function profile($id){  
    return $this->db->
    select('*')->
    from('names')->
    where('id', $id)->
    get()->row_array();
}

Controller:

function get_name($id){

    $this->load->model('mod_names');
    $data['records']=$this->mod_names->profile($id);

    print_r($data['records']); //All 
    echo $data['records']['full_name']; // Field name full_name

}

answered May 21, 2012 at 13:21

James Arnold

9801 gold badge6 silver badges15 bronze badges

Comments

ionize · Accepted Answer · 2012-05-21 12:21:35Z

3

You do that inside a View, like this.

Controller:

 function get_name($id){

    $this->load->model('mod_names');
    $data['records']=$this->mod_names->profile($id);
    $this->load->view('mod_names_view', $data); // load the view with the $data variable

 }

View (mod_names_view):

 <?php foreach($records->result() as $record): ?>
     <?php echo $record->full_name); ?>
 <?php endforeach; ?>

I would modify your model then to something like this (it worked for me):

function profile($id)
{  
    $this->db->select('*');
    $this->db->from('names');
    $this->db->where('id', $id); 
    $query = $this->db->get();

    if ($query->num_rows() > 0)
    {
     return $query; // just return $query
    }
}

edited May 21, 2012 at 12:21

answered May 21, 2012 at 12:07

ionize

1011 silver badge8 bronze badges

1 Comment

black_belt Over a year ago

Yes I know how to do it in the view file. But I need to get the query result in my controller. Thanks :)

Collectives™ on Stack Overflow

Codeigniter : displaying query result in controller

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related