where()在codeigniter中显示“is null”而不是变量值

jobtbby3 于 2021-06-21 发布在 Mysql

关注(0)|答案(1)|浏览(364)

$email='abc@abc.com';
$pass= 123;
$this->db->select('*')->from('user')->where('email',$email)->where('password',$pass)-> get()->result();

结果如下：-

'select * from user where email IS NULL and password IS NULL';

但它和 $this->db->query(); 请帮我找出为什么它不会像：-

'select * from user where email="abc@abc.com" and password="123" ';

mysql php codeigniter

来源：https://stackoverflow.com/questions/48057258/where-showing-is-null-instead-of-variable-value-in-codeigniter

1条答案

按热度按时间

z9ju0rcb1#

使用此方法。希望对你有帮助

$email = "abc@example.com"; 
$password = "abc123";

public function getdata()
{
    // first load your model if not added in your config/autoload file
    return $this->db->get_where('table_name', array('email' => $email, 'password' => $password))->row_array();

}

赞(0）回复(0）举报 2021-06-21

我来回答

where()在codeigniter中显示“is null”而不是变量值

1条答案

相关问题

热门标签

最新问答