doushuangai9733 2014-10-03 11:09
浏览 16
已采纳

登录时计算值为1的用户数

I have a table called user in my database.

I have a column name called isLogged on my user row.

And when the user islogged on it changes to '1'. And logged out changes to '0'.

What is the best way to count the users that have '1' in the isLogged column.

model

public function getTotalUserOnline() {
// Only Counts Number Of Users 
$query = $this->db->count_all('user');
return $query;
} 

and then echo it from controller.

$data['total_user_online'] = $this->dashboard_user_online_model->getTotalUserOnline();
  • 写回答

2条回答 默认 最新

  • dqmq0654 2014-10-03 11:14
    关注

    In Codeigniter, you can do

    public function getTotalUserOnline() {
            $this->db->select('count(*) as total');
            $this->db->from('user');
            $this->db->where('isLogged', 1);
            $data = $this->db->get()->result();
    
            return $data[0]->total;
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 visionmaster启动失败,提示为“机器不满足授权而被禁用”
  • ¥50 用logisim设计16位单时钟周期cpu
  • ¥15 IDEA中圈复杂度如何具体设置
  • ¥50 labview采集不了数据
  • ¥15 请上面代码做什么处理或什么混淆
  • ¥15 英雄联盟自定义房间置顶
  • ¥15 W5500网线插上无反应
  • ¥15 如何用字典的Key,显示在WPF的xaml中
  • ¥15 weautomate读取Excel表格信息然后填写到网页一直报错,如何解决?
  • ¥15 C#如何在Webview2中获取网页验证码