如何使用代码点火器中的连接从两个表中获取值 - how to get value from two table using join in codeigniter

how to get value from two table using join in codeigniter

public function user_data_vi($email)
{
    $this->db->select('*');
    $this->db->from('client');
    $this->db->join('payments', "payments.email = $email");
    $q= $this->db->get();
    return $q->result(); 
}

上面的代码是我的模型和方法 user_data_vi 我有两个表client，两个表email字段中的另一个payments现在很常见，我想从数据库中检索数据第一个表有用户信息和payment table付款信息使用电子邮件字段获取两个表数据的信息。

你需要在这里添加一个where条件，请在下面找到修改后的代码

public function user_data_vi($email)
{
        $this->db->select('*');
        $this->db->from('client');
        $this->db->join('payments', "payments.email = client.email");
        $this->db->where('client.email',$email);
        $q= $this->db->get();
        return $q->result(); 
}

public function user_data_vi($email)
{
    $this->db->select('*');
    $this->db->from('client');
    $this->db->where('client.email',$email);
    $this->db->join('payments','payments.email = client.email');
    $q= $this->db->get();
    return $q->result(); 
}