php - 错误号 : 1054 Unknow Column Codeigniter

Question

我有一个代码可以从链接在一起的表中检索数据。这是代码

public function getdatamentor($key)
{
    $this->db->select('iduser');
    $this->db->where('idtraining', $key, false);
    $hasil= $this->db->get('ttraining');
    $this->getNama($hasil->result());
}

public function getNama($key)
{
    $this->db->select('nama');
    $this->db->where('iduser', $key, false);
    $hasil = $this->db->get('tmember');
    return $hasil;
}

但它返回错误

Error Number: 1054

Unknown column 'TWO00000' in 'where clause'

SELECT `iduser` FROM `ttraining` WHERE idtraining = TWO00000

Filename: C:/xampp/htdocs/gofastforex/system/database/DB_driver.php

Line Number: 691

感谢您的帮助

Answer 1

where 方法中的第三个参数用于转义

$this->db->where('idtraining', $key, true); //

最好阅读此处

https://www.codeigniter.com/userguide3/database/query_builder.html?highlight=where%20cla#CI_DB_query_builder::where