Case Sensitive login in codeigniter

How to implement case sensitive user login in codeigniter ?. This is the topic we are gonna to see today. Implementing login with case sensitive option in codeigniter is very easy. That is, we need to give 'LIKE BINARY' after the database field name in model query.

Case Sensitive login in codeigniter

Lets see the example codeigniter controller and model codes to that are used to get case sensitive user data from database.

---

Controller Code:

<?php

function login_controller()
{
 $email = $this->input->post('email');
 $password = $this->input->post('password');
 
 if($email && $password)
 {
  $query = $this->user_model->login_model($email,$password);
  if($query)
  {
   echo "Login Success..";
  }
  else
  {
   echo "Login Failed..";
  }
 }
}
?>

Model Code:

function login_model($email,$password)
{
 $this->db->select('*');
 $this->db->from("user_account");
 $this->db->where("email",$email);
 $this->db->where("password like binary",$password);
 $query = $this->db->get();
 if($query->num_rows() > 0)
 {
  return $query->result();
 }
return false;
}

---

The main thing used here is $this->db->where("password like binary",$password);

---

Search Keywords

• Case sensitive password check in codeigniter
• Codeigniter case sensitive query
• Codeigniter Binary query