Get sum of mysql fields and passing sum to view in codeigniter [duplicate]

Question

I am not able to display the sum of mysql fields in the view. The sum-field is named urls. Instead of displaying the sum of all urls for the specific user I receive a string named 'array'. I believe it is a passing problem rather than a query one but I don't get it. Thank you for your help.

Model (users_model):

public function get_sum($id){
    $this->db->select_sum('urls')
            ->where('user_id', $id);
    $query = $this->db->get('user_earnings');
    return $query->result();
}

Controller (users):

public function userarea() {
    $id = $this->session->userdata('id');
    $data['sum'] = $this->users_model->get_sum($id);
    $data['main_content'] = 'userarea_view';
    $this->load->view('layout', $data);
}

View (userarea_view):

<li>Total URLs Collected: <br><strong><?php echo $sum; ?></strong></li>

GautamD31 · Accepted Answer · 2013-08-26 09:10:59Z

1

Try like

<?php echo $sum[0]->urls; ?>

Since it will be returned as object.

edited Aug 26, 2013 at 9:10

answered Aug 26, 2013 at 8:56

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

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

3 Comments

Hobby99 Over a year ago

I tried and receive: Undefined index: urls. Do you have another idea? Thank you so far.

GautamD31 Over a year ago

Can you print the $data['sum'] in your controller and tell me

Hobby99 Over a year ago

array(1) { [0]=> object(stdClass)#22 (1) { ["urls"]=> string(5) "18294" } }

fdehanne · Accepted Answer · 2015-01-08 08:57:14Z

0

public function get_sum($id)
{
    $this->db->select('SUM(urls) as total');
    $this->db->where('user_id', $id);
    $q=$this->db->get('user_earnings');
    $row=$q->row();
    echo $row->url;
}

edited Jan 8, 2015 at 8:57

fdehanne

1,7281 gold badge18 silver badges32 bronze badges

answered Jan 7, 2015 at 10:10

Pushpendra Kumar

1,6841 gold badge15 silver badges22 bronze badges

Collectives™ on Stack Overflow

Get sum of mysql fields and passing sum to view in codeigniter [duplicate]

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related