php - 将 MySQL JOIN 查询转换为 CodeIgniter 查询

Question

我正在尝试将此查询转换为代码点火器查询。但我不知道从哪里开始。我是代码点火器的新手。请帮忙。

public function  get_loginsecuritydetails($security_date,$apt_id) {

    $sql = "SELECT s.* , IF( DATE( s.security_date ) = DATE( '$security_date' ) , 1, 0 ) AS loginstatus,a.agency_companyname FROM security s JOIN agency a ON(a.agency_id=s.security_cat) WHERE apartment_id='$apt_id'; ";
    $res=mysqli_query($sql) or die(mysqli_error());
    return $res;
}

Answer 1

您可以在 codeigniter 查询生成器中将其转换，如下所示:

$this->db->select("s.* , IF( DATE( s.security_date ) = DATE( '$security_date' ) , 1, 0 ) AS loginstatus,a.agency_companyname");

$this->db->join("agency as a","a.agency_id=s.security_cat");

$this->db->where('apartment_id',$apt_id);

$query = $this->db->get('security as s');

$result = $query->result();

return $result;