count the not null value using where condition in codeigniter

Question

I am writing a function to count the null column with where condition but there is a problem in this function

protected function _get_mcq_attept_count2( $mcq_id){
    $this->load->model('museranswer');  
    return $this->museranswe>count_by(array('mcq_id'=>$mcq_id,'bookrefrence!='=>" "));
}

this function made the query

SELECT COUNT(*) AS `numrows`
FROM `user_answer`
WHERE `mcq_id` = '321'
AND `bookrefrence` != ' '

this query return the empty column value

http://stackoverflow.com/questions/2489453/querying-mysql-with-codeigniter-selecting-rows-where-field-is-null Check this one — Edelmar Ziegler, Oct 17 '16 at 20:12
try this: `$this->museranswe>count_by(array('mcq_id'=>$mcq_id,'bookrefrence IS NOT NULL'));` — H. Jabi, Oct 17 '16 at 20:15

score 1 · Answer 1 · answered Oct 18 '16 at 05:25

I hope this code work for it bcz in code-igniter i always use like this .

 protected function _get_mcq_attept_count2($mcq_id)
    {
        $this->load->model('museranswer');  
        $where = array('mcq_id'=>$mcq_id);
        return $this->museranswe>count_by($where);
    }

    /******************* FOR MODEL *********************/

    public function count_by($where)
    {
        $this->db->select('count(mcq_id) as numrows');
        $this->db->from('user_answer');
        $this->db->where($where);
        $this->db->where('bookrefrence !=',' ');

        $qry = $this->db->get();
        return $qry->result_array();
    }

score 0 · Answer 2 · answered Oct 17 '16 at 23:44

0

Change your query like this array("mcq_id" => "$mcq_id", "bookrefr‌ence IS NOT NULL" => null). Hope you will get right answer. If it does not work, share your model with us.

answered Oct 17 '16 at 23:44

Jobayer

1,221
1
14
22

score 0 · Accepted Answer · answered Oct 18 '16 at 08:06

0

return $this->museranswer->count_by(array('mcq_id'=>$mcq_id,'length(bookrefrence)>2'));

answered Oct 18 '16 at 08:06

Sourabh Kumar

94
3
15

count the not null value using where condition in codeigniter

3 Answers3