how to write this query in Codeigniter

"SELECT * FROM `login` WHERE user_name='".$email."' AND password='".$password."'";

CodePudding user response：

As codeigniter Docs (Here):

$query = $this->db->get_where('login', ['user_name' => $email, 'password' => $password]);
$row = $query->row();

CodePudding user response：

You can use

$this->db->query("SELECT * FROM login WHERE user_name='".$email."' AND password='".$password."'");

Refer Documentation