I cant get sum array of result_array codeigniter (get num_rows after result_array) [duplicate]

Question

I want to get num_rows of query but i need to get it from result_array not from query. So, i call function array_sum to calculate num_rows but it doesnt work

I've tried to using array_sum (php function) but it return 0, it supposed to return 3

ListModel.php

Class ListModel extends CI_Model {
    public function getList($id=null){
        $listm = $this->db->query("
                    SELECT * FROM m_list m
                    LEFT JOIN list_country lc ON lc.id=m.id_country
                    WHERE lc.id_section = $id"
        )->result_array();
        return $listm;
    }
}

MController.php

$arr_m= $this->ListModel->getList(15);

$return['total'] = array_sum($arr_m);

any idea to solved it?

Raj Purohit · Accepted Answer · 2019-07-29 08:18:10Z

1

You need to use count or sizeof function for get length of array.

$return['total'] = count($arr_m);

edited Jul 29, 2019 at 8:18

answered Jul 29, 2019 at 8:13

Raj Purohit

2411 silver badge8 bronze badges

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

Comments

jvk · Accepted Answer · 2019-07-29 07:50:27Z

0

Missing closing double quotes

Class ListModel extends CI_Model {
        public function getList($id=null){
            $listm = $this->db->query("
                        SELECT * FROM m_list m
                        LEFT JOIN list_country lc ON lc.id=m.id_country
                        WHERE lc.id_section = $id
            ")->result_array();
            return $listm;
        }
    }

answered Jul 29, 2019 at 7:50

jvk

2,1893 gold badges22 silver badges28 bronze badges

1 Comment

Ray Coder Over a year ago

sorry i forget to copy that. the list is fine and return 3 array that i need, the problem is i need total but it return 0

Collectives™ on Stack Overflow

I cant get sum array of result_array codeigniter (get num_rows after result_array) [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related