将SQL查询转换为Codeigniter活动记录 [英] Converting SQL query to Codeigniter Active Record

问题描述

我有这个SQL查询

  SELECT * 
 FROM adm_species t 
 JOIN adm_breeds e ON e .species_id = t.id 
加入fd_registrations s s.breeds_id = e.id 
 W.T.code ='cat'
 AND s.sex_id ='2'
 AND s.ownername LIKE'％sha％'
  

如何将其转换为Codeigniter Active Record？ p>

谢谢！

解决方案

尝试一下

  $ this-> db-> select（'*'）; 
 $ this-> db-> from（’adm_species t’）; 
 $ this-> db-> join（‘adm_breeds e’，‘e.species_id = t.id’）； 
 $ this-> db-> join（’fd_registrations s，’s.breeds_id = e.id’）; 
 $ this-> db-> where（'t.code'，'cat'）; 
 $ this-> db-> where（’s.sex_id’，2）; 
 $ this-> db-> like（'s.ownername'，'sha'，'both'）; 
 $ query = $ this-> db-> get（）; 
  

活动记录类

I have this sql query

SELECT *
FROM adm_species t
JOIN adm_breeds e ON e.species_id = t.id
JOIN fd_registrations s ON s.breeds_id = e.id
WHERE t.code = 'cat'
AND s.sex_id = '2'
AND s.ownername LIKE '%sha%'

How do I convert this to Codeigniter Active Record?

Thanks in advance!

解决方案

Try this

$this->db->select('*');
$this->db->from('adm_species t');
$this->db->join('adm_breeds e', 'e.species_id = t.id');
$this->db->join('fd_registrations s', 's.breeds_id = e.id');
$this->db->where('t.code', 'cat');
$this->db->where('s.sex_id', 2);
$this->db->like('s.ownername', 'sha', 'both'); 
$query = $this->db->get();

Active Record Class

这篇关于将SQL查询转换为Codeigniter活动记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！