我需要一点帮助...我试图将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/

10-12 12:42
查看更多