php - How to check unique email in multiple table using codeigniter?

Question

public function unique_email($email)
{
    $this->db->select('*');
    $this->db->from('instructor, student');
    $this->db->where('instructor.email',$email); 
    $this->db->or_where('student.email',$email);
    $sql = $this->db->get();
    $result = $sql->num_rows();
    return $result;
}

In the above query I am simply trying to get unique email id in multiple tables but the above query doesn't work. I don't know why?

Answer 1

Change your TRUE and FALSE as well check in controller:

In Model

 public function unique_email($email) 
    {
        $this->db->select('*');
        $this->db->from('instructor');
        $this->db->join('student', 'instructor.email = student.email');
        $this->db->where('instructor.email',$email);
    
        $query = $this->db->get();
        if ($query->num_rows() > 0)
        {
            # email exist
            return false;
    
        }
        else {
            # new/fresh email
           return true;
    
        } 
    }

Controller :

function email_exists($email) {
    $result = $this->Register_model->unique_email($email);

    if ($result == TRUE) {
        echo "Email Exists";
    } else {
        echo "New Email";
    }   

}