drhozgt6007 2018-02-19 05:21
浏览 354
已采纳

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

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?

  • 写回答

2条回答 默认 最新

  • dongliu5475 2018-02-19 05:24
    关注

    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;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 求友友们解惑,感激不尽
  • ¥15 python中aiohttp.client_exceptions.ContentTypeError
  • ¥30 DeepLung肺结节检测生成最大froc值对应的epoch报错
  • ¥15 信号发生器如何将频率调大,步尽值改成10
  • ¥15 keil 5 编程智能家具,风扇台灯开关,人体感应等
  • ¥100 找一名渗透方面的专家
  • ¥20 使用Matlab APP设计一个插补小程序
  • ¥15 evo评估时曲线出现问题
  • ¥15 eNSP拓扑图配置实验
  • ¥20 有没有兄弟会替换fmod studio的.bank文件内的音效?