我需要一点帮助...我试图将MySQL查询转换为Codeigniter,但它无法正常工作...
MySQL:
SELECT
users.email,
transactions.id,
transactions.type,
transactions.status,
transactions.sum,
transactions.created,
transactions.title
FROM
transactions, users
where
users.id=transactions.user_id and
transactions.type='winning_claim' and
date(transactions.created)=date(subdate(now(),1))
Codeigniter:
$this->db->select('users.email, transactions.id, transactions.type, transactions.status ,transactions.sum, transactions.created, transactions.title');
$this->db->from('transactions');
$this->db->join('users', 'users.id = transactions.user_id');
$this->db->where('transactions.type', 'winning_claim');
$this->db->where('date(transactions.created)', 'date(subdate(now(), 1))'/*, FALSE */);
$select_la_data = $this->db->get();`
有人有想法吗?
最佳答案
*You can try this*
$this->db->select('users.email, transactions.id, transactions.type,
transactions.status ,transactions.sum, transactions.created,
transactions.title');
$this->db->join('transactions','users.id = transactions.user_id');
$this->db- >get_where
('users',array('transactions.type'=>'winning_claim',
'transactions.created'=>'date(subdate(now(), 1))'))->result_array();
关于php - 将Mysql查询转换为Codeigniter,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/45366062/