Codeigniter 活动记录帮助或 mysql 帮助

发布于 2024-11-08 06:00:37 字数 683 浏览 0 评论 0原文

我有这个语法从数据库中获取一些数据，我使用codeigniter的活动记录，

$this->db->select('job_id, jobs.employer_id, company_job_id, like_job_id, logo, company_name')
        ->from('jobs')
        ->join('company_likes', 'company_likes.like_job_id = jobs.job_id', 'left')
        ->join('company_views', 'company_views.company_job_id = jobs.job_id', 'left')
        ->join('employers', 'employers.employer_id = jobs.employer_id', 'left');

        $query = $this->db->get();

        return $query->result_array();

不，这应该返回1个结果，但是，它返回4条记录，因为这是company_views表中的记录数，我想要实现的是我得到了该雇主数据库中的视图数量，但我只想使用一个查询来完成此操作。

目前，此查询用于向用户获取雇主详细信息，但我还想反馈雇主被查看的次数。

原文

I have this syntax for grabbing some data from database, I using codeigniter's active record,

$this->db->select('job_id, jobs.employer_id, company_job_id, like_job_id, logo, company_name')
        ->from('jobs')
        ->join('company_likes', 'company_likes.like_job_id = jobs.job_id', 'left')
        ->join('company_views', 'company_views.company_job_id = jobs.job_id', 'left')
        ->join('employers', 'employers.employer_id = jobs.employer_id', 'left');

        $query = $this->db->get();

        return $query->result_array();

No this should be return 1 result however, it is returning 4 records as that is the number of records in the company_views table, what I am wanting to achieve is that I get returned the number of views in the databsae for that employer, but I only want to do it using one query.

Currently this query is used to get the employer details to the user, but I also want to feed back how many times the emloyer has been viewed.

分享到QQ

分享到微博