drhozgt6007 2018-02-18 21: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-18 21: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条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥50 数据库开发问题求解答
  • ¥15 安装anaconda时报错
  • ¥20 如何用Python处理单元格内连续出现的重复词语?
  • ¥15 小程序有个导出到插件方式,我是在分包下引入的插件,这个export的路径对吗,我看官方文档上写的是相对路径
  • ¥20 希望有人能帮我完成这个设计( *ˊᵕˋ)
  • ¥100 将Intptr传入SetHdevmode()将Intptr传入后转换为DEVMODE的值与外部代码不一致
  • ¥50 基于ERA5数据计算VPD
  • ¥15 寻找杂志《Tornatzky, L. G., & Fleischer, M. (1990). The Processes of Technological Innovation. 》
  • ¥15 前台多人编辑时怎么让每个人保存刷新都互不干扰
  • ¥20 如何用Python删除单元格内连续出现的重复词?