当表中没有记录时，我想将结果显示为零而不是空数组？

Question

Here is the code block and this results an empty array but I want the result to be zero when it’s like that.

public function step_count($data,$count)
{ 
    $values=array();
    for ($i=0; $i < $count ; $i++) { 
        $query3=$this->db->query("SELECT `check` FROM `staffsalary` WHERE `user_id` = '$data[$i]' AND `month` = '02'");
        $result3 = $query3->result();
        array_push($values,$results3);
    }
    return $values;
}

This results an empty array, but i want the result as 0 rather than empty array to show in the view page. How to get the result as 0 when there is no record found in table?

Answer 1

You can use CodeIgniter's num_rows() function. It will return the number of records found. If no record is found, then it will return 0.

See below:

public function step_count($data,$count)
{ 
    $values=array();
    for ($i=0; $i < $count ; $i++) { 
        $query3=$this->db->query("SELECT `check` FROM `staffsalary` WHERE `user_id` 
        = '$data[$i]' AND `month` = '02'");
        $result3 = $query3->num_rows();
        array_push($values,$results3);
    }
    return $values;
}